To retrive previous month based on month prompt

[Former Member]

Hi,

My universe is based on SAP BEX query. I have a requirement to report the previous month data based on a month prompt. Since the universe is based on the MDX, could anyone suggest a way to calculate previous month from universe.

Appreciate your responses.

Regards,

VyshBO

[Former Member · Accepted solution]

Hi VyshBO,

You can refer below syntax and prepare a filter object in universe to get Previous Month.

 <FILTER KEY="[ZMONTH].[LEVEL01].[[ZMONTH]].[Value]"><CONDITION OPERATORCONDITION="Equal"><CONSTANT CAPTION="-1"/></CONDITION></FILTER> 

Regards,

Vinesh

[Former Member · Accepted solution]

Hi VyshBO,
> 
> You can refer below syntax and prepare a filter object in universe to get Previous Month.
> 
> 
 <FILTER KEY="[ZMONTH].[LEVEL01].[[ZMONTH]].[Value]"><CONDITION OPERATORCONDITION="Equal"><CONSTANT CAPTION="-1"/></CONDITION></FILTER> 
> 
> 
> Regards,
> Vinesh

Can you explain that syntax, Vinesh? In particular, what does the [[ZMONTH]] imply?

[Former Member]

Welcome to the forums.

I'm from a database background and found this disappointing too.

You'll need to either amend/create a query or create a filter at the report level.

The report level logic is easy enough but would involve a lot of data being pulled back (depending upon the volumes in BW).

Regards,

Mark