YTD dimension/element/subset calculation/formula

Post Reply
JayM
Posts: 23
Joined: Wed Sep 14, 2011 3:21 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

YTD dimension/element/subset calculation/formula

Post by JayM »

Hi I am new to this.

I have Time Dimension in my cube which has everything separately rolling up to Year i.e, Year <-- quarter <-- Month, which I have uploaded from an excel source file.

Do I have to create new column called YTD in excel and then rerun the process in TM1 or I can create the new element/subset called YTD using Time Dimension in the existing cube?

Please help me as I am not able to get this.

Thanks,
Jay
User avatar
qml
MVP
Posts: 1094
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: YTD dimension/element/subset calculation/formula

Post by qml »

The answer is waiting for you in the other thread you asked this question in:
http://www.tm1forum.com/viewtopic.php?f=3&t=1936
Kamil Arendt
Post Reply