Page 1 of 1
YTD Concept in TM1
Posted: Wed Jul 14, 2010 6:40 am
by ravi
Hi All,
Could someone explain me how build the YTD dimension and how the YTD calculations happnes in TM1
Regards,
Ravi
Re: YTD Concept in TM1
Posted: Wed Jul 14, 2010 9:09 am
by Wim Gielis
Ravi
Eeasiest (and most efficient) is to have 12 n type elements for the months.
Then you add consolidations for the YTD's.
YTD Jan is the sum of Jan.
YTD Feb is the sum of Feb and YTD Jan.
YTD Mar is the sum of Mar and YTD Feb.
And so on.
Or:
YTD Jan is the sum of Jan.
YTD Feb is the sum of Jan and Feb.
YTD Mar is the sum of Jan and Feb and Mar.
And so on.
A TI process could create the structure but in the end, doing this manually is not the end of the world
You could also stick with 12 simple elements for the months, and use another dimension to have a Cumul element (calculated with rules). It's more heavy because of the rules. Yet, comparing months and YTD's is easier in a view if you do it like this.
HTH,
Wim