YTD dimension/element/subset calculation/formula

yzbboy

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

fs111

The answer is waiting for you in the other thread you asked this question in: