Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 30, 2013 at 01:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 30, 2013 at 11:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 30, 2013 at 10:33 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 30, 2013 at 10:34 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.