Delete dimension master data in BPC 10.1

[Former Member]

Hi,

I have a requirement to delete dimension master data in BPC 10.1

I will explain the scenario here.

First assume there are 1000 records in material master dimension and there exists transactional data to these 1000 records. And then we are going to replace 500 random records with new materials and transaction data related to this materials will be migrated to New Materials. To achieve this, we are keeping 1000 old records+500 New records in Dimension master data and we are migrating the old materials data to New materials in the cube.

Now we want to delete 500 old records(which we want to replace with the New materials). Selecting these records manually in the dimension and then deleting requires lot of time.

Please suggest me if there is any way or standard package to do this or Please let me know if there is any program to handle the above scenario.

Thanks,

Amaresh

[former_member186338]

1. Clear all data on 500 old members

2. Perform Light Optimize with zero elimination enabled to remove zeros.

3. Create new property and mark old members as Y in this property.

3. In the web administration sort members using this property.

4. Select all lines with Y

5. Delete selection.

6. Process dimension.