Skip to Content
avatar image
Former Member

Delete dimension master data in BPC 10.1

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 08, 2017 at 09:34 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded