on 10-08-2015 12:35 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Fedrico,
Try to create New selection on your first Key Figure and use Offset ' -1 ' in your 0CALMONTH Variable for your Second Key figure column.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you are comparing cal month against value (current month) and value(previous month) which is not correct.
you can compare a date against value (CM) and value (PM) .. (or) compare month against current year and previous year .
what is your requirement?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Fedrico,
Can you explain the issues/sample report lay out.
Regards,
Satya.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.