Best practise how to accumulate a time scale in TM1?

[craig_karr]

I have a TM1 cube wit ah few dimensions and a simple time scale that consists of the months and then a total year, ie. Jan, Feb, March.....Total Year

In this cube I would like to have an extra dimension that would make it possible to switch between periodical values and accmulated values for the time scale. The extra dimension would contain two members, one called for example M.Per and when that member is selected you would have periodical values for example:

Jan   Feb   Mar   and so on
100   50     75

If you instead choose M.CTD I would like accumulated values for example:

Jan    Feb   Mar

100    150    225

But I have no idea how to achieve this. in Planning I would have used a BIF (built in function) but I don't know how to do it in TM1. Is there any best practise? One alternative would of course be to create accumulated members of each month and the create a subset containing those members

[OLAPBPMguy]

You could set up consolidations in the base month dimension and then apply a rule to your time type dimension, e.g.

Code Select Expand

['M.CTD'] = DB('cube', !dim1, !dim2, !dim3, !month | ' YTD', 'M.Per');

But why would you bother to do this? For 1 you have to create the consolidations anyway and 2 for the end user the 2nd dimension really adds no utility as it is just as easy to simply select a YTD consolidation (or set of YTD members) from the month dimension as to pick M.CTD from the type dimension anyway.

[craig_karr]

I went for the alternative to just create the consolidations as you suggested and then I created a subset with all the consolidated months. It was easy.

[OLAPBPMguy]

TM1 is easy.  It is a well kept secret  :D