Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to massively delete All DATA from BI

Dear fellows,

I would like to hear your opinion on the following subject.

Our BW 7.0 production system is having test data at the moment (due to a system copy from development).

However, in order to go-live we would have to clean the data before the initial production load (and retain the content, info-providers etc).

How is it possible to delete massively and in a fast way all the application data contained in the Info-Providers, PSAs and Master Data.

So far, i have created a process chain containing process types;

"Deletion of Requests from PSA"   to delete the data of respective PSAs and

"Complete Deletion of Data Target Contents"  to delete the data of respective Info-Providers.

However there is not such a process type for master data deletion.

We are running BW 7.0 and we have enabled the new MD deletion based on note 1370848.

However even the new MD deletion version does not seem to provide mass deletion function (for multiple info-objects).

So the questions are;

1) How can we massively delete all master data?

2)  Is there any other way of apart from creating process chain to delete massively all necessary Info-Providers & PSAs?

3) On basis perspective, is it possible to copy a BW system without the application data?

Please share your ideas

Former Member
Former Member replied

Hi Michail,

B would be best one if basis team can't do copying data without str.

For example, if we go with A option, if we miss deletion of tables like sid or dim ids by mistake. its may create problem we we do reloading data.

Even compare to transport, deletion of each and every table might be time consuming one, we cant sure deletion will perform smoothly. some dependences may create problem.

As said by nithesh, please with help of basis team,Please check with basis team and you can choose right one.

If basis team can perform copying str without data, this will be the best to go.

Regarding basis activity we can't give perfect one, because we are purely BW Side.

Hope you got it.


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question