YTD Concept in TM1

[ravi]

Hi All,

Could someone explain me how build the YTD dimension and how the YTD calculations happnes in TM1

Regards,
Ravi

[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