Current Month - Last 12 Months in OLAP Universe
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.
Edited by: patnaik24 on Apr 12, 2010 10:50 PM