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.
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
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.