Purge from staging DSO layer...

[darryl_goveas3]

Hi Experts,

We are loading data from SAP and non-SAP sources into BW (7.0). We load into PSA's first and then stage a lot of the data in a layer of DSO's before finally moving the data to a reporting layer (DSO and or Cubes).

I have built a chain to purge out data from the PSA's that is older than a month, and now want to also purge out data from the staging DSO's. However, since I am trying to delete older data but not the most recent data it keeps telling me it has to delete the new data requests before it can remove the older ones.

I saw some posts about using the selective deletion functionality, but didn't see any 'delivered' processes to build these into process chains? Also, I was wondering how the system would react since I have the data already populated to another set of infoproviders (for reporting), but by deleting this older data the two layers would no longer be able to be reconciled.

Thanks for any insights!

Cheers,

Darryl

[former_member197610 · Accepted solution]

Daryll,

To do selective deletion of data from an ODS try using the function Module RSAN_ODS_DATA_DELETE in your process chain.

Use your chare as key for selective deletion.

Hope this helps.

[Former Member]

Hi,

Apart from the information prvided above, You can see the below thread which contains d he procedure of selective deletion of data from DSO in process chains.

Also this blog explains the procedure of doing selective deletion form DOS and CUbe

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3414900)ID0554546850DB00062871813295399254End...

Hope this helkps,

Sri..

[darryl_goveas3]

Thanks all - lots of great info to look at!

fyi - there is also some good info from the 'help' on the selective deletion option under the manage DSO (Contents tab).

I ended up using the SAP generated program from t-code delete_facts to build a solution.

Cheers,

Edited by: Darryl Goveas on Oct 2, 2009 4:34 PM

[former_member181964]

Hi,

Check the following Article, it will help you how to automate dynamically.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/business-intellige...

Thanks

Reddy

[darryl_goveas3]

Thanks Surendra!

That is exactly what I did, but it feels great to be validated by someone elses process design!

Best Regards,

Darryl

[Former Member]

Hi,

You cannnot remove old requests from DSO.

The reason is the data in the DSo will be aggregated (Records with same Key) after activation.

So the syustem will not allow you to delete old requests from DSO directly.

Even though if you can find a way to delete the data from DSOactive table directly, it will lead o inconsistencies.

Rather you can delete data from the change log table of DSO.

You have the option of delete change log in process chain.

Use this to delete data from change log table.

Selective deletion is normally done foe Infocubes and there is no option to do this in the DSOs.

Hope this helps,

Srinath.