Skip to Content
0
Former Member
Aug 29, 2006 at 07:13 AM

Calculated Key-Figure based on Cumulated Key-Figure

60 Views

Hi BW-Community,

I have problems defining a ckf based on a key-figure wich are marked as cumulated. I know this topic was discussed before

but I did not find a acceptable solution yet.

Here is my example (as it should be)

Cum KF1 KF2 CKF3 (KF1 % KF2)

2 2 100%

4 2 200%

6 2 300%

And this is the Output from BW

Cum KF1 KF2 CKF3 (KF1 % KF2)

2 2 100%

4 2 100%

6 2 100%

BW uses the not cumulated keyfigure-value instead of the cumulated value,

I tried several things:

1.) Use the class CL_RSR_WWW_MODIFY_TAB and redefine the method data_cell to do a manual calculation on the results. This works but

it is very inflexible and restricted on WEb Template also the Excel Integration do not work properly.

2.) Mark the CKF also as cumulated but this don't work either.

My customer uses such calculation on almost every Query and Report so I need a practicable solution.

I think the best way to solve this is in the staginf prozess, but i did not find a solution yet.

Does anybody know a workaround, solution? We will put to NW2004s soon is there any chance that this will work

in this release?

Thank you in advance

Greetings

Timo