YTD dimension/element/subset calculation/formula
Posted: Tue Sep 20, 2011 4:48 pm
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
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