Problem with copy in BPS

[Former Member]

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.

[Former Member]

Valter Casse!

You can solve this problem via FOX-formula.

I can help you in case of problem appear.

Aliaksandr Kuzmich

EPAM Systems.

[Former Member]

Hi Aliaksandr,

I am currently facing the same issue in BI-IP.

Can you provide me some example code for a FOX-Formula working like this:

• Copying data from source cube to target cube
• update same key
• do not invert records in target cube which do not exist in source cube

Thanks in advance!

Marco

[Former Member]

Hi Valter,

I think you achieve the desired result by selecting the option "Add to existing values" when defining the parameter group.

Greetings,

Martin