How to automate selective deletion after successful transfer of data from the info provider

[sengupta13_amartya30]

Hi Guys,

Problem Statement : Let say we wanted to move selective sap bw data to any external data storage. So after successful transfer now that same data remain in our HANA memory too, so how can we delete that particular data. I know about selective deletion but is there any way to make it automatic, meaning if data move successfully to data storage then data in BW(InfoProvider) will delete automatically and if it fails then it will do nothing.

Thank you in advance.

[MKreitlein]

Hello Jishu,

one option, which would not fit your needs by 100% but comes near would be the process chain variant "Delete Overlapping Requests from DataStore Object (advanced)":

With that you can load a DTP into the aDSO, then extract the data from new table (or from w/o aDSO) to your external data storage ... and with the next process chain run, this old request is removed when the next load with the same DTP was successful.

The only difficulty is the missing relation between DSO load and data extraction.

If your extraction fails, but the process chain runs the next time, it will delete the old and update the new request anyway.

But this solution comes out of the box 🙂

BR, Martin

[sengupta13_amartya30]

Hello Martin,

Thanks for answering my question I will try to do this.

Regards,

Jishu