Hi TM1 Gurus
I have a cube view like the foll
______________________________________________________________________________
Year Dim(To select years from 2008-2010)
------------EAD(Current)----EAD(Forecast)
q1
---Jan
---Feb
---Mar
q2
---Apr
---May
---Jun
q3
---Jul
---Aug
---Sep
q4
---Oct
---Nov
---Dec
We have values for Ead(Current) and for EAD (forecast)they want to use previous month data. For jan 2010 u should have dec 2009 data(of Ead current), for feb 2010 u should have jan 2010 data(of Ead Current)
How can i do it with less rules, like i dont want to write rule for every month.Please suggest me the best way to do it.
Thanks
Daya
daya007
Posts: 10
Joined: Thu May 27, 2010 10:47 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2007
You could use the index (dimix) in rule. Which it seems you don't want to or use an attrib in a variable -1 to make forecast=to current-1