cumulative KeyFigure on AMDP BW-Transformation

[Former Member]

Hi,

my requirement is to create a cumulative KeyFigure on AMDP, which shows balance (INVD_VAL) of month for a Customer and cumulative Balance (ZCUMINVCD) per end of the year.

How can I calculate a cumulative amount key figure per year on amdp?

my codes like this;

*****Tranformation************

when i tried this code, i got false cumulative values on BI.

Result :

if i tried to on SQL, i got true Cumulative Value.

Thanks

Sascha

[former_member231518]

Hi Sascha,

I was wondering whether the data are correct in LISTCUBE.

If it is correct in LISTCUBE and not correct in query, I suppose you could add tag "BW Analytic Engine (OLAP)" here.

I suppose you may want to check following wiki for more information: LISTCUBE

Best regards,

Tibbie

[Former Member]

Hi Tibbie,

thanks for your Comment. i guess, its script issue..

thx