SP8 for SAP BW 7.4 has introduced BW’s newest modelling object: the Advanced DSO. The Advanced DSO is BW’s new major modelling object that plays a central role in any SAP BW on HANA data model. It is used as a classical DSO, info cube, PSA or write optimized DSO. The Advanced DSO manages to replace all of these objects by basically being all of themWhen creating the Object you have to decide about the properties the Info Provider shall have.
Sometime we choose Classical DSO option for data provision to next layer and so change log table comes into picture. One thing missing at the moment is the possibility to delete the Change log via process type. But according to SAP this functionality is to come in future ( may be BW 7.5 ).
At this moment, it is possible to do the deletion manually to delete the requests manually in the manage UI but no workaround to delete in batch. However, SAP has recently come with a workaround.
After implementation of this note #2253065, program “RSDSO_REMOVE_REQS_PC “ will be available in your BW on HANA system . This program internally calls Function Module M “RSDSO_REMOVE_REQUESTS_API” to delete change log requests in batch.
Take an example, DSO “Z_TEST” ADSO contains 13 change log requests.
We run program “RSDSO_REMOVE_REQS_PC” for ADSO “Z_TEST” with age 15 days
All change log data older than 15 days are deleted now.
We can create an ABAP variant having ADSO name and age of requests to be removed.
We can use this ABAP program and variant in process chain using ABAP process type to automate change log deletion via process chain.