Question:
Hi SAPers!
Could you tell me if there any way to clear the necessary data from Cube and documents? For example I want to clear the results of a method wich generate posting. If I use Mass Reversal it just generate new documents as I understand but I'd like to clear documents of the method at all. If I use "Delete Data" in content menu of the cube (and ODS with Documents too) it clears all data in the cube, it is also not that I need.
Thank you in advance.
_________________
Mike
Answer:
use selective delete, you can restrict on characteristics only
Answer:
Thank you very much, I've found it!
_________________
Mike
Answer:
In order to delete BCS Documents from the ODS and Totals Records from the Cube we opted for a combination of ABAP and SEM-BPS. An ABAP program was written for the deletion of the ODS Documents and we used the standard BPS Delete function for the totals in the Cube.
The ABAP program was the called-up via a custom exit on the Consolidation Monitor in BCS. Upon Execution of the task (Test or post), the BPS planning funtions are executed via the API interface, the ODS are deleted through ABAP and a log of the results is displayed in the BCS monitor. Pretty Cool!! The program even took care of the status of the Consolidation tasks before and after execution. Needless to say, our user was very happy with the final product.
A similiar integration with BPS was used to copy data between consolidation versions and monitors. We are on SEM 3.5 runng BW 3.1. It seems this integration is going to become standard functionality in SEM 4.0 (BW 3.5). Any experience you would like to share?
Cheers,
Rodolfo