cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BPC 10.0 Master Data Deletion

slnkpsl
Explorer
0 Kudos

Hi all,

We have nearly 130.000 master datas in one of our dimensions and we need to delete 90.000 of them. Is there a way to delete those datas massively? Selecting all 90.000 of them and trying to delete is locking our system.

We are looking for a solution like deleting them via abap or a program.

Any help is appreciated.

Regards

Selin

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

You have a list of members to be deleted:

1. Ensure that you don't have transactional data for this list (even zeros!)

2. Create a new property in dimension.

3. Import list of members to be deleted with the new property set to "Y"

4. In the web interface filter by this property and delete members (may be using subsets).

slnkpsl
Explorer
0 Kudos

Vadim ,

Actually i have a property called Component_Type, but deleting them after filtering is locking our system (non of them have transactional data). For example; i have selected 60.000 of master datas and pressed delete button, waiting for 45 minutes so far and nothing changed in web interface, still trying to delete.

former_member186338
Active Contributor
0 Kudos

Try to delete 100 records, then 1000 records.

slnkpsl
Explorer
0 Kudos

At first we tried that too, but after figuring out that deleting like that takes 4 hours(more or less), we are looking for another way.

former_member186338
Active Contributor
0 Kudos

4 hours for what?

No another way...