Skip to Content
0
Former Member
Apr 12, 2010 at 07:34 PM

Current Month - Last 12 Months in OLAP Universe

75 Views

I need to create a conditional objects at OLAP Universe and use it in WEBI report to run for last 12 months from Current Month.

We have exit variable for CM (Current Month). Can any one advise how to create the conditional object at Universe level to restrict always 12 months worth of data. I need to schedule the report and when ever it runs, it shouls pull only last 12months.

Can I implement like [0CALMONTH].CurrentMember - 12 , I need to get last 12 months. I need to do this only with Time dimension, I dont want to have any measure assosiated with just like in regular RDBMS definitions in Universe.

Thanks

Pat

Edited by: patnaik24 on Apr 12, 2010 10:50 PM