Purging data in SAP BW4HANA

[Valeti]

Hello Experts,

1. Can we directly delete the data from cold tier by using DELETED option in RSOADSODTO and to clear physically data , clean up option in cockpit view.

2. how to  purge the data in ADSO which doesnot have time char ( TD) as part of compliance.

Request you to share your expertise .

[Valeti]

Thanks for your knowledge sharing ..

[roland_szajko · Accepted solution]

Hi

1. https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/b912a621e66c4da3a0a577da178ba...

2. You can use:

• Delete Content
• Selective Deletion

Also see:
3232938 [BW Central KBA] How-To: Data Management for BW Infoprovider tables

[Valeti · Accepted solution]

Hi Roland, Thank you for the input. we are planning to purge the data for more than 100 , in that selection deletion option is not satisfied. Could you suggest please.

[roland_szajko · Accepted solution]

Not sure I understand what you mean. If you need to delete the whole content for multiple providers, then just use a process chain and add the providers to the "Delete content" variant. If you need to do selective deletion on multiple providers, then you have to perform it individually on the providers.

[Valeti · Accepted solution]

Hi,

Our requirement is to purge the data in more than 100 ADSO's based on retention period from business.

Few ADSO's have data in cold store, i tried to deleted the data in cold  store by selecting a single partition using " Deleted " option and tried to clean up  in Cockpit, 

however, the deleted partition  still  shows in DTO Admin screen. 

How to make it invisible in screen though the data is not shown in ADSO.

Thanks,

Shyamala. 

[roland_szajko · Accepted solution]

If the ADSO has static partitions, then the partition itself is not deleted. It stays there, but will be empty. You are just removing the data, but not the partition itself.

Why is it a problem, that an empty partition is visible anyways?

[Valeti · Accepted solution]

Hi Roland.

Thank you for the update.

As per the link i understood that the partition which is deleted will not shown once clean up action is executed, so had a confusion on it.

https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/b912a621e66c4da3a0a577da178ba... 

But post your clarification , I assume that the static partition remains as such with deleted status for that specific partition.

Correct me if am wrong.

Thanks,

Shyamala.

[roland_szajko · Accepted solution]

Let's say I have an ADSO with 3 static partitions. 2 of them is in COLD:

I mark partition 0001 to be deleted:

but the data remains (see "Cold Rows").

As stated in the document Deleting Data:

"You can then delete this data physically in SAP BW∕4HANA in the Data Tiering Maintenance app (choose Clean Up) or by using the process chain type Cleanup Archive. "

After this the data is deleted and the partition remains in "Deleted" status. See "Cold Rows":

As stated in the above document:

"To deactivate this lock, you can simply change the temperature to Warm or Hot."