TM1 Forum

Hi All,
i have a Time dimension with several nested consolidation. It is not a "perfect" hierarchical structure. It looks like

Time Dimension
-------------------

Current month
-> 2013/03
Past 12 months
-> 2013/03
-> 2013/02
-> 2013/01
...
-> 2012/04
Next FY month
-> 2013/04
-> 2013/05
-> 2013/06
..

As you can see, there the level 1 is full of months and the level 0 represents some logical groupings.
Can I create a named Hierarchy for each of these logical groupings , for instance a "past 12 months" hierarchy?
I tried to set the defaultMember to "Past 12 months" but it still shows all consolidations (a multi-level hierarchy) when I am in Cognos.

I hope I am clear enough and somebody can answer this!

There are several ways to do this. One way I could think off the top of my head is to create control cube containing the current month. Then create text attributes (or a lookup cube) +1, +2, -2, -1, etc. Have rules in place to automatically calculate theses based on the first control cube. Then a have a process that rebuilds your time hierarchies based on these attributes / control cube. This way each month you just change your current month and run the process. There is obviously a lot more to it than that but this should give you something to think about.