Question Re: Problem with copy in BPS in Technology Q&A

Problem with copy in BPS

Former Member — Tue, 15 Nov 2005 17:01:33 GMT

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

Re: Problem with copy in BPS

Former Member — Tue, 15 Nov 2005 18:21:00 GMT

Hi Valter,

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

Greetings,

Martin

Re: Problem with copy in BPS

Former Member — Wed, 16 Nov 2005 07:51:46 GMT

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

Re: Problem with copy in BPS

Former Member — Wed, 16 Nov 2005 08:53:34 GMT

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.

Re: Problem with copy in BPS

Former Member — Thu, 12 Jan 2006 11:46:03 GMT

Valter Casse!

You can solve this problem via FOX-formula.

I can help you in case of problem appear.

Aliaksandr Kuzmich

EPAM Systems.

Re: Problem with copy in BPS

Former Member — Wed, 16 Apr 2014 06:23:23 GMT

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