Skip to Content
Author's profile photo Sk Kamruzzaman

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

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Luis Loebel
      Luis Loebel

      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