Previous month

[daya007]

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

[Atif.Hameed]

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