Switching between different time dimensions

[Rizzy]

Hello Community,

Is there a way to set up a time dimension that can switch between weekly, monthly periodic and monthly year to date?

I am working in Planning Analyst and our end users would like to see this on the web via the Contributor Admin Console.

Thank you in advance for your help.

[Pawel]

HI,

You could either create a hierarchy in your time d-list, or create three different d-lists (and cubes), define the time periods accordingly and match by description.

Ludi

[Rob_D]

Hi Riz,

I think you would need to experiment a bit with this but you may be able to use of the "Cumul" BiF to set up a Dlist which enable users to switch between Monthly Periodic & Monthly Year to Date. To get weeks in as well may need a little more thought. Remember one of the Dlists in your cube will need to be denoted as a Time Scale Dlist, although not the one containing the BiF.

There is an example in the IBM Analyst training Student Guide in chapter 4 where this function is used for Gross Margin.