BI 7 WAD - Copy function - Add data instead of overwrite

[Former Member]

Hi,

We use copy function to copy data from one version to another. We need to add data to the second version. But when we execute the copy function, data in the second version is overwritten. Can anybody help how to do this in planning modeler on BI 7 (or WAD). This can be done in BPS0 but we would like to do the same in RSPLAN.

regards,

Lokesh Nandula

[Former Member]

Hello,

I don't have an access to IP here, but in case the same option than in BPS does not exist, why don't you write a FOX in order to make your copy add instead of overwrite?

Something like : NewValue = OldValue + NewValue

Regards,

[Former Member]

Thanks Jeoffrey. In the below link its stated that ''The key figure values for the To values are always overwritten during copying"

http://help.sap.com/saphelp_nw70/helpdata/en/44/21e0697641648fe10000000a1553f7/frameset.htm

Infact, we already started with FOX...but couldnt complete it. Can you please check the below FOX. We use a variable for Version.

Operand Keyfigure, Version

-

---

DATA VAR1 TYPE 0VERSION.

VAR1=VARV (ZKMDVFIB_VERSION).

{0AMOUNT, VAR1} = {0AMOUNT, VAR1} + { 0AMOUNT, Z01 }.

{ZIAMT1, VAR1} = {ZIAMT1, VAR1} + { ZIAMT1, Z01 }.

{ZIAMT2, VAR1} = {ZIAMT2, VAR1} + { ZIAMT2, Z01 }.

[Former Member]

Hi,

Instead of seperate line for eack KF you can also use a FOREACH for KFs....eg.

FOREACH Keyfigure,

{keyfigure, VAR1} = {Keyfigure, VAR1} + {Keyfigure, Z01 }.

ENDFOR.

It should work. try. Make sure that all the keyfigures and the versions are there in the level.

Best of Luck!

SK