Time Period Rollups Dimension

[unbreakable79]

Hello,
I have a requirement to create a time period rollup dimension. The dimension would have the following. Trailing 1 - 3 months, Trailing 4-6 Months, Curr Y-T-D etc. I am not sure how to do this. Would this be done by created a calculated dimension. Any help with sample MDX query would be greatly appreciated.
Thanks,
Bhargavan

 

[MDXer]

A Quick Summary, in SSAS the way you accomplish this is:

1) In your DSV create a new Table (TimeCalcs) and using a Named query this should have a single Value of Current Period.
2) Create a Time Calcs dimension with this named query as the source.
3) Add this dimension to your cube with the relationship being a reference on the Date key of your date/time dimensions.
4) Create the Calculated Members in the cube but your Formula should be NULL
5) Using MDX Script you need to write a the calculations and scope them to your date dimension. You need a set of MDX scripts for each date hierarchy.

detail instructions:
A Different Approach to Implementing Time Calculations in SSAS


Time calculations in UDM: Parallel Period


Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[unbreakable79]

Paul,
That is EXACTLY what I am looking for. I will follow those steps and will let you know how it goes.

Thanks a lot.