delete master data in BW 7.3

[Former Member]

Hi

In earlier versions we had a simple option to delete the master data but in 7.3 if i right click and select "delete master data" as a background or foreground job, the data does not gets deleted and how to delete master data Ex: 0EMPLOYEE. Please help.

[Former Member]

HI,

go to Infoobject --> right clikc --> maintain master data

Select rows u wanted to delete and click 'Delete' icon. And SAVE.

If system prompt u 'some master data cannot be deleted' .. continue with this message.

then goto tcode SLG1-- enter Object: RSDMD and Subobject: MD_DEL and User: ur userID and F8

In the next screen Expand node and dbl click 'Problem class additional information'

This will give u which ever objects using SIDs of this master data.

U should delete this SID according to that list.

Then U should delete particular data from DSO/Cubes.

Once data deleted from cube, then

Use Tcode RSRV -> Tests in Transaction RSRV -> All Elementary Tests -> Transaction Data -> Entries Not Used in the dimension of an InfoCube (Dbl Click)

From the right side window, expand u201CEntries Not Used in the Dimension of an InfoCubeu201D Node &

Enter InfoCube (like 0SD_C01), click u201CTransferu201D

Now, click u201CExecuteu201D (Toolbar)u2026 and the results displayed in the right side window..

Now, click u201CCorrect erroru201D (Toolbar)

Useful thread for your answer : http://scn.sap.com/thread/1721220

Thank you

[former_member188080]

Hi,

If there is any transaction level data which is available and it is linked to these SID ,it is difficult to delete that data from there.

so first u have to delete the transaction level data from various Infoproviders and once all the links are cleared u can delete the master data entry..

In RSRV also there is option where u can delete the entries..from DIMID of the cube

Thanks and regards

Kiran

[Former Member]

Below link would be of some help to you..

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

Thanks

Santosh.

[Former Member]

It talks only about how to identify the dependent object for deletion.

It does not talk of how to delete the data.

Any help gurus?