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
YTD dimension/element/subset calculation/formula
- 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
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
http://www.tm1forum.com/viewtopic.php?f=3&t=1936
Kamil Arendt