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
You could set up consolidations in the base month dimension and then apply a rule to your time type dimension, e.g.
['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.
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.
TM1 is easy. It is a well kept secret :D