REG : Selective Deletion

20 Views

Hi Guru's

I have an issue with selective deletion and iam sure you people can solve it.My issue is as follows :

I have a Infocube which holds data regarding Forecast.It is loaded and compressed daily by process chains.After loading there is a step to selectively delete data which is two days old due to business needs.This selective deletion runs daily in the process chains.Daily 7 Million records are deleted and its taking nearly 7 hours to complete this step which is causing problem in accessing reports by the users as it is locking the Infocube.Now my question is how can i improve the performance of this selective deletion and which area i need to trace where the deletion is taking more time.

UR swift replies are appreciated as usual.

Thanks and Regards

Sandeep.