I have a Write Optimized DSO with duplicate data, the data is duplicate at PSA level ,hence the Infocubes that have DSO as data mart also have duplcates for a day at the start of the month.
I have segregated the duplicates in an excel files and found the condition of selective deletion to the DTP request ID and data package and as we are working on a retail project , the store number that has the duplicate records.
Now for selective deletion, we dont get DTP request & Data package ID as conditions to delete teh record.
What are the possible methods that we can go for in this case?
and I need to delete all the requests in the infocubes after the date we have duplicate data and reload all the data from DSO into infocube.