Skip to Content

Deleting large amounts of data

We are running SAP BPC MS 10 SP19 and SAP EPM SP24 Patch1. We have deleted large amounts of data from 1 model and we expected to see a performance change but we did not. I did do a Full optimization after the deletion but we so no change. We deleted about 5 million records and we still roughly have 20 million still in the model. Anything else I can do that could help?

Regards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 10, 2017 at 01:48 PM

    Hi Oscar,

    When you say performance problems, can you point at a specific report or script that is having issues?

    /Cecilia

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 05, 2017 at 07:26 PM

    We have a input schedule that runs off the model that pulls data from 7 dimensions. When we retrieve data it takes about the same amount of time as it did before we did the deletions. We actually deleted members which removes the data in the model as well. I am wondering if I need to re-index.

    Add comment
    10|10000 characters needed characters exceeded