Copy Package Replace & Clear clears all data

[michael_hutchins2]

Hello Forum,

I've seen in some strings on this forum that you can update the Copy package, so that when you select Replace & Clear, it clears only the data for which you are trying to copy. Does anyone have experience with this? If so, could provide the steps for updating the copy package to do this?

I've seen some communication about updating the DIM List property in the forums, but it doesn't spell out how to do this, or even if this is the solution.

Mike

[former_member204026 · Accepted solution]

Hi,

Try the following steps.

1. Go to eData > Organize Package List

2. Modify the Copy package

3. Click on the view package icon in the "/Copy Package.dtsx"

4. Click on the "Advanceed" button on the dynamic script editor screen

5. Uncomment the below script

'PROMPT(RADIOBUTTON,%CLEARDATA%,"Select the method for copying the data from the source to destination database",0,{{"Merge data values (Copies specified records, leaving all remaining records in the destination intact)","Replace && clear data values (Copies specified records, and clears the data values for any records that mirror each entity/category/time combination defined in the source)"}},{{"0","1"}}) 

PROMPT(RADIOBUTTON,%CLEARDATA%,"Select the method for copying the data from the source to destination database",0,{{"Merge data values (Copies specified records, leaving all remaining records in the destination intact)","Replace && clear data values (Copies specified records, and clears the data values for any records that mirror each entity/category/time combination defined in the source)"}},{{"0","1"}}) 

This should enable clearing data feature.

Hope this helps.

Regards,

Badrish

[michael_hutchins2 · Accepted solution]

HI Badrish,

I'm looking for a way to allow replace and clear, but only for the selections in which I wish to copy. Not just Category/Entity/Time, but also on Account, DataSrc, etc...

Make sense?

Mike

[i045436 · Accepted solution]

Hi,

The %CLEARDATA% parameter is passed after to the Dump&Load task and the data is cleared only related to your selection.

Best regards,

Mihaela

[michael_hutchins2 · Accepted solution]

HI Mihaela,

We are on BPC 5.1 SP3, and our copy package ignores all other selections and clears the Category/Entity/Time combination selected. So for instance, if we select one Account with 2010.JAN, and Actual it will clear all accounts for the Category and Time we selected. Logically, you would think it should only clear the one account for that time period, but it does not. So I don't know if this is fixed in a later service pack or not. However, I want to find a solution to this for now until we do our next upgrade.

Thanks,

Mike

[i045436 · Accepted solution]

I understood better now your problem.

Did you try to us the Merge options? You should obtain the result you want.

Regards,

Mihaela

[michael_hutchins2 · Accepted solution]

Mihaela,

We want to also have the Replace & Clear option. So I'm looking for a way to configure the package so that Replace & Clear only clears the data points we select and not just the Category/Entity/Time combination.

Mike

[i045436 · Accepted solution]

You can try to pass the %SELECTION% parameter as well to the DUMP&Load task. That %CLEARDATA% is the parameter that arrives to this task and it looks like this is the one that delete data. Matbe specifing to this taks the SELECTION or even the DIMLIst can help. This should be tested, I didn't try.

Best regards,

Mihaela

[Former Member]

Dear Experts,

I facing a similar issue. I would like to use replace option but to include another dimensions like account and not only to restrict it to entity/cateogry/time.

Have you found a solution for this?

Thanks in advance.

Manuel

[Former Member]

I avoid Clear and Replace because it is slower and it is limited to Category, Entity and Time. I run a Clear package first, and select the intersections I want to clear. Then I run an import package and select the Merge option instead to load the new data.

Overall this process runs faster and is more reliable than doing Clear and Replace.

Perhaps someone else has a better solution, but the Category, Entity and Time limitation makes Clear and Replace useless in my humble opinion.

Greg