How to massively delete All DATA from BI

[Former Member]

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

[RamanKorrapati · Accepted solution]

Hi Michail,

For mass deletion, you many need to write porogram and need to give input(tables names) or

Need to go individual deletion of each targets/tables.

or Reinstallation and retransport all structure from dev to prod again.

http://scn.sap.com/thread/1909956

http://basisondemand.com/Documents/Whitepaper_on_BW_SystemCopy.pdf

https://scn.sap.com/thread/1265789

Thanks

[Former Member · Accepted solution]

So to sum up, as far  as i have understood there are 2 options to clean up the BW database;

A) 1. Delete firstly all info-providers and psa through process chain

     2. and then execute custom program based on standard fm or program with input all the infoobjects that have master data/texts

B) 1. Re-Install BW target system

     2. Collect all necessary bw objects via trasport request (grouping mode = system copy) from original bw system

     3. Import the Transport requests in the target BW system

If this is the case which one should we go for. Is the B option the usual solution for this occasion?

Finally, as regards what nithesh prakash was mentioning previously about Copying BW without data, can anyone validate that or should we forget about it?

[RamanKorrapati · Accepted solution]

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.

Thanks

[Former Member · Accepted solution]

Thank you Raman

When i'll get feedback from basis team i will let know

In the meantime if someone knows more about copying bw without copying data please post here.

[Former Member · Accepted solution]

Having a discussion with the basis team, is seems that copying bw without data is not possible.

Thus we have to pick one of the two options mentioned above.

[RamanKorrapati · Accepted solution]

Hi,

Again ask basis team how time will take to reinstall, according that you can choose which one is suitable for you(time taking wise).

Thanks

[Former Member · Accepted solution]

Basis says it would not take much, just a few hours. However we don't know how long will it take to release/import the transport request neither how long would it take to delete all the tables.

However, regardless the time taking , it sounds to me that option B is better, at least for going-live, mainly because of the disadvantages of the option A (custom program, master data dependencies, missing tables etc).

One thing i would like to know is if it it possible to collect everything in one single transport request? Is there any particular guide on how to collect object when transporting for system copy?

[RamanKorrapati · Accepted solution]

Hi Michail,

We can collect in one req, but if we face any error, whole thing need to do again. so better go with individuals. that would helpful.

Rather than individual atleast take in one request which object related specific data flow.

Like if your loading master data loads for 0CUSTOMER, collect master data sources, info pkg and dtp. like that way(you can gorup them which are related)

Below links guide you step by step.

http://scn.sap.com/docs/DOC-25970

http://scn.sap.com/docs/DOC-12029

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8049a889-81d7-2d10-1cac-ac9912bcd...

http://help.sap.com/saphelp_nw04/helpdata/en/0b/5ee7377a98c17fe10000009b38f842/content.htm

[RamanKorrapati · Accepted solution]

Hi,

Please check below link. might be informative.

http://scn.sap.com/message/13683411

Thanks

[Former Member]

Hi Michail,

for Mater data you can see any FM is available and keep that FM in Program and Insert that Program in PC's

 
RSDMDD_DELETE_MASTER_DATA
RSDPW_MASTERDATA_DELETE

See the above TWO FMs in SE37 and if it is working then keep in in one simple program and then call that Propgram in Process Chain

[Former Member]

Hi Michali,

If your scenario is to completely delete the entire data from the data providers, then better give the required the table details to your basis team so that they can easily delete data from the tables

and regarding the system copy... yes it is possible to copy BW system without data.

Thanks,

Nithesh.

[Former Member]

hi Nithesh,

Yes, our scenario is to delete all application data of BW. I assume that giving thousands of tables to the basis team is not an option, not to mention the dependencies between transaction and master data.

However could you please provide more details on how to Copy BW without data. Are you sure it is available because as fas as i'am concerned it is possible to do a copy client without data (e.g.R/3) but not a system copy which is the usual procedure for BW.

[Former Member]

Dear Michali,

Yes i agree with your point regarding master data tables. But for BW system copy, i am sure its possible to copy without data. We have done it in many instances. I am not a basis guy and i wouldnt be able to explain about the steps to be followed. For this please get in touch with your basis team, they would help you out better.

Thanks,

Nithesh.

[Former Member]

Hi Michail,

For deleting master data please refer bellow links:

http://scn.sap.com/community/data-warehousing/netweaver-bw/blog/2012/01/01/bw-730-different-ways-to-...