Hello,
Here's a newbie question that I am having a heck of a time figuring out...
I want to return only the balance at the begining of the year. My time dimension has a hierarchy as follows:
-Fiscal Year
--Month
---Period
I then created (from the template) a Calculated Member that does return the number. However, as you can see, it is only from Fiscal Year 2006, the first period (Period Number = 1)
Aggregate
(
OPENINGPERIOD([Dim Row Date Vw].[FiscalYear - EnglishMonth].[Period Number],
[Dim Row Date Vw].[FiscalYear - EnglishMonth].[FiscalYear].&[2006].&[1]),
[Measures].[ACTIVE]
)
How do I change this so it pulls from the first period for each year, at the beginning of that year
Thank you for the help.
Newbie question - Getting the headcount at the beginning of the year using OpeningPeriod
Lawrence 007
Dexter
Something so simple, of course I didn't see it.
Thank you so much for the help.
bkejser
Mosha,
Thank you for the information. I do have AS2005 EE, but how exactly do I use a semiaditive measure to get the count of just Period Number 1 from each year
I thought that the semiadditive would still add up each Period, so I don't know exactly how to refer to just the Period Number 1.
Thank you for the help.
spelger