Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Thanks

Pat

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

Former Member
replied

Hi,

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

Ingo

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question