Cube content deletion is taking more time than usual.

[Former Member]

Hi Experts,

We have a Process chain which ideally should run in every two hours. This chain has a delete data cube content step before the new data is loaded in the cube. This chain is running fine for one instance & the other instance is taking more time so it is quite intermittent.

In the process chain we are also deleting contents from the Dimension tables (in the delete content step). Need your inputs to improve the performance of this step.

Thanks & Regards

Mayank Tyagi.

[Former Member]

Hi Mayank ,

You can delete the indexes of the cube before deleting the contents of the cube . The concept is same as of data loading that data loads happens faster when indexes are deleted .

If you are having aggregates over this cube , then that aggregate will be also adjusted .

Kind Regards,

Ashutosh Singh

[Former Member]

Hi Ashutosh,

Unfortunately these are not related to my problem & it is very intermittent so I think it is depending upon the system response only, but anyway thanks for your answer.

Thanks & Regards

Mayank Tyagi.