Skip to Content

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.

/wp-content/uploads/2015/12/a1_857887.png

We run program “RSDSO_REMOVE_REQS_PC” for ADSO “Z_TEST” with age 15 days

/wp-content/uploads/2015/12/a2_857931.png

All change log data older than 15 days are deleted now.

/wp-content/uploads/2015/12/a3_857932.png

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.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Sankar Reddy

    Hi Dhiraj,
    Thanks for post. We are facing issue with PSA deletion which is updating data to ADSOs. We have added the DS to process chain variant to delete history data older than 8 days from PSA. Can you please help here.

    Thanks
    Sankar

    (0) 

Leave a Reply