Bex Cumulative Key Fig
We have 2 key fig like A & B in Bex .
A – normal key fig
B – checked cumulative in Bex key fig properties -> Calculation – check cumulative.
my requirement is display Key fig A, B & C.
where C = A + B, C – formula
Retort output coming is below which is wrong bcause B value is cube level value( original value ) not report level value
type | Calendar Day | Calendar Year/Month | A | B – Cumulative | Formula C |
Technical | 15.03.2012 | MAR 2012 | 0 | 0 | 0 |
Technical | 12.01.2012 | JAN 2012 | 33 | 33 | 66 |
Functional | 06.03.2012 | MAR 2012 | 365 | 398 | 730 |
Functional | 20.03.2012 | MAR 2012 | 0 | 398 | 0 |
Functional | 28.03.2012 | MAR 2012 | 7 | 405 | 14 |
when we adding A + B in C column the output is coming key fig original value not Cumulative value. Means
Cube level Data is adding & displaying report. I need the Cumulative value which will be adding with A .
Kindly suggest me.. if it is possible..
Regards,
Kamruz
Hi, check the note 2010790 - Cumulative Value Display:
https://service.sap.com/sap/support/notes/2010790
WIKI: Cumulative Value Display - SAP NetWeaver Business Warehouse - SCN Wiki
It will solve your problem.
Loebel