How to delete master data from InfoObject

[Former Member]

Hello,

Can anyone give me an advice for the following problem :

160 employees have been deleted from R/3 but still exist in BW.

I am searching a way to delete them in BW but I have the following problem :

- selective deletion in InfoCubes and ODS is OK

- when I try to delete them in 0EMPLOYEE , I received the message

"master data xxxxxxxx (SID xxxxxxxx) is used in BI0/QPERSON and therefore can't be deleted.

The reason is that 0PERSON is an attribute of 0EMPLOYEE and vice versa.

No records in R/3 exist for those employee.

Any idea how can I delete them in BW in 0EMPLOYEE and 0PERSON ?

Thanks for your help,

IE

[Former Member]

Hello,

since 0PERSON is an attribute of 0EMPLOYEE

you have to delete the master data of 0PERSON first

and then the data of 0EMPLOYEE.

Best Regards

LL

[Former Member]

Hi Ingrid,

1. delete the data from all infocubes and ODS's, where the infoobject is available.

then the masterdata isn't in use. all SID's should be deleted from the dimension tables.

Now you can delete the masterdata with the AdminWorkbench.

2. delete the employees from 0EMPLOYEE.

3. delete the employees from 0PERSON.

you can also try the function: archive.

Sven

[Former Member]

Hi Ingrid,

since the check is performed only for navigational attributes, try to switch off the navigation property in 0PERSON attributes management...there is no harm in trying!

Let me know...

Bye,

Roberto