Import transaction data from flat file : Modify key in the Replace data option

[former_member597889]

Dear experts,

I've been requested to provide help for a client of my company I don't know.

They are working on BPC NW 10.0.

As of today they use the standard data package "Import transaction data from flat file" but are not satisfied because some of their entities have changed code and are not overwritten when they load new data.

In standard this package has a ""Replace data in same data region of Entity, Category, Time and Audit ID" option.

They are asking for the package to replace data in same data region of Category, Time and Audit ID only.

The prompt does not allow me to modify this key.

What is the simplest way to bring the required modification? Create a specific data package (if so, can you give some advice)? Do I need to create a specific process chain?

Thank you for your support.

Best Regards,

Axel

[former_member186338]

"File 1 (old file)

Entity 1 : 100

Entity 2 : 50

File 2 (new file)

Entity 2 :150

Data is transfered from entity 1 to entity 2 and entity 1 is not available in file 2."

Sample not clear! What do you want to achieve?

[former_member186338]

You have 2 options:

1. ROUTINE badi that will dellete data before load based on your requirements.

2. Clear package launched before data load (in package link) - but you will need to provide scope each time.

[former_member597889]

Thank you!

[former_member186338]

axellemaitre

Please accept the correct answer!

[former_member597889]

Each month, Control will generate a file with their data. The file is sent to a shared folder and automatically loaded to a SAP BPC cube via the standard package (through a Package Link in which they also execute a light optimize).

Sometimes, in their file, Control will transfer data from one entity to another leaving a former entity with no figure associated so that it does not appear in the file.

This is the reason why they want to replace data based on Time, Phase and Audit ID. So that the data on the former entity is overwritten.

The solution with the BADI would probably work but it seems like a lot of efforts.

Isn't there a solution with a package to load transaction data from a flat file while selecting specific dimensions to use as key to replace data?

Best Regards,

Axel

[former_member186338]

"Sometimes, in their file, Control will transfer data from one entity to another leaving a former entity with no figure associated so that it does not appear in the file." - sorry, but not clear!

[former_member597889]

File 1 (old file)

Entity 1 : 100

Entity 2 : 50

File 2 (new file)

Entity 2 :150

Data is transfered from entity 1 to entity 2 and entity 1 is not available in file 2.

[former_member186338]

Yes, everything is possible! But the requirements are not clear... Please explain step by step

[former_member186338]

Just use Clear package before import. You can't modify import package.

[former_member597889]

Dear Vadim,

Thanks a lot for your answer.

Ideally they would like to execute data deletion automatically. Correct me if I'm wrong but the use of this package will require to define the prompt to select the data to delete.

Is there a way to delete data dynamically? Can we use BADI to scan data from flat file and generate the prompt for the package?

Thank you for your help.

Best Regards,

Axel