Skip to Content
author's profile photo Former Member
Former Member

deletion of master data

Hi

We do not have BW-Q/A.

So i am deleting all master data in the objects(which has master data from dev R/3_,so that i can load r/3 Q/A data which is our PRODR/3 replica.

First i deleted all the data in the info providers and trying to delete master data from the objects.

So when i do this,it asks

Do you want to delete only the contents of the fact table

in InfoCube, or do you want to delete the dimension tables as well?

So i select fact and dim tables as well.

It asks do you want to delete contents of the cube?I say yes.

It says

nfoCube/ODS object contents are to be deleted !

There are still dependent table entries for this InfoCube/ODS

Example control entries for scheduled actions

Logs Just as Rollup, Compressing, Reconstruction...

Also delete these entries ?

Possible scheduled actions must be rescheduled afterwards

I say delete entries.

It gives a list data base tables deleted and recreated.

It says content of the cube successfully deleted.

So is this the right way?

Is there any way i can delete all the master data content in one shot,instead of going to each and every object and deleting the content of cube,content of ODS,content of Master data...

Sorry for the long mail

But i wanted to know what goes on actually.

Thanks.

Haarika.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 04, 2005 at 05:27 PM

    Hi Haarika,

    as already discussed before in these forums, you have to delete content for every provider in which there are data related to your master data..there is no choice !!!

    You can use a pgm in which, in a loop with all the providers, you can use FM 'RSAU_INFOCUBE_CONTENT_DELETE' (with some adjustment in which you can delete all the FMs POPUP_TO_CONFIRM_STEP that are the reason of several pop-ups)...but I don't think it's a useful way...

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      If you will have to do this on several occasions in order to repeat testing, it may be worth your effort to create process chains to perform the deletions.

      Like this you will also be certain not to miss out something.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.