Skip to Content

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

SAP BEx Current Month vs Previous Month

Hello Dear Guru's

I'm having some troubles into using the right variable or method for me to accomplish the next:

0CALMONTH          Value          Value -1 Month

...

2014/05                    100

2014/06                    150               100

2014/07                    200               150

2014/08                    150               200

2014/09                    200               150

2014/010                  210               200

2014/011                  150               210

2014/012                  100               150

2015/01                    99                 100

2015/02                    300               99

2015/03                    310               300

2015/04                    300               310


We've been trying to use a Restricted keyfigure with 0CALMONTH as a Characteristic being filtered by various types of variables with no success.


Perhaps we're doing something wrong in the concept.


Anny suggestions might be very useful,


Thank you

replied

Hmm, doesn't seem so easy for me at query level before the 740 (because calmonth is displayed, filters or RKF won't work).

This can easily be done through data staging (with a new KF = value of the month -1) or less easily  through a virtual KF (not so sure for this one).

In 740, the variable type current member can be used to achieve this:

See Current Member Variables - SAP NetWeaver Business Warehouse - SCN Wiki

Regards,

Frederic

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