Problem with copy in BPS

[#1]

I have realized a function, in a multi-planning area, that copy data from a cube to another. I want that all "record" (within selections) from "source" cube were copied into "destination" cube, eventually over-writing existing value for record with same "key".

Running this copy function in a real environment, i obtain that records from source were copied into destination but destination record not contained in source cube were deleted from destination cube.

This is a standard "modus operandi" of copy function (confirmed by SAP).

Do you know how can i realize function like i need (copy all from source without deletion of destination record not present in source)?

Thanks in advance.

Best regards.

Valter Casse

SSC

AMS-BW

[Former Member · Accepted solution]

Thanks for your mail.

This is a solution, but has a problem on "repeatability": if copy function is linked to button on web layout, if user press twince (or more) the button, the result is that quantities will be increased!

I search a solution with copy that can be repeated.

Best regards.

Valter Casse

[Former Member · Accepted solution]

OK, so what you want is a function which over-writes some data, but not other data.

I see no other solution than introducing a sort of addional intermediate step where the user copies to a different characteristic combination than the data you do not want to overwrite.