I'm struggling to define a calculated member which sums up the measure from current loaded month in the time dimension to 12 months prior. For example, if the current loaded month into my [Date].[Date Hierarchy] is August 2010 then it should sum up from
August 2009 to August 2010.
I tried to get the current loaded month using
CLOSINGPERIOD ([ Date].[Date Hierarchy].[Month Name],
strtomember("[Date].[Date Hierarchy].[" + cstr(year(now())) +"]"))
but it gives me the month of December instead of August.
Any Help?
Thanks,
Parth
View Complete Post