Skip to Content
Former Member
Jun 25, 2010 at 01:58 PM

Deletion of master data (RSDMD126) in BW



We are trying to delete master data (data type CHAR) of an info object used in a transactional cube. The info object carries 10 types. Type 3 is to be deleted. The transaction data using type 3 is reposted (IP) to type 4. Than the transactional data on type 3 is deleted from the cube with selective deletion.

When trying to delete type 3 (with or without SID) we get a message RSDMD126 that master data is still used in the dimension table (SID 67). We tried RSRV, reactivation of cube, reupload of master data etc. The only way to delete the master data was to delete the content of the cube which is not feasible for us.

Any ideas how to delete/regenerate the SID database table?