Current Month - Last 12 Months in OLAP Universe

[Former Member]

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

[IngoH · Accepted solution]

Hi,

you need to solve this in the BW query using EXIT variables as the MDX does not offer any system date dependency.

Ingo

[former_member142702]

Hi

I would recommend to modify the existing customer exit variable so that it will restrict the data for the last 12 months. You can then create a prompt in your web intelligence report that limits additionally the data to the current month when necessary.

Regards,

Stratos