We have compressed Info Cube which is getting data from two data source (0HR_PA_0 and 0HR_PA_1), we load full load every day from data source (0HR_PA_1) and delta from 0HR_PA_0, we have Delete Overlapping Request from info cube in process chain to delete 0HR_PA_1 data from info cube.
Unfortunately we have compressed this info cube manually without knowingly about Overlapping Request from info cube in process chain, now process chain is not able to delete requests from info cube because of compression. Now are getting double records in the report.
We can’t go for selective deletion for (example Cal year/month) because info cube also data from other data source (0HR_PA_0).
In this scenario what is the best solution to remove compressed requests from Info Cube.