Selective Deletion For DSO and InfoCube...
I'm working on SAP NetWeaver BW 7.3 and I have a scenario in which I need to delete the contents/data of DSO and InfoCube for Current Year/Month. I will load daily current month data and need to schedule the deletion of current month/year records from DSO and InfoCube before loading the new records. Say; today is 11-06-2015 and I have to delete previously loaded data which will be from 01-06-2015 to 10-06-2015 and then I will load new data till today (11-06-2015).
1. How can I make this "Selective Deletion" automatic for DSO and InfoCube for currently Year/Month data deletion?
2. Is there any variant for Process Chain to be utilized for this particular task?
3. How can I achieve this particular task in hand?
I will appreciate your reply.