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

How to delete master data from InfoObject

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2004 at 02:52 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2004 at 10:58 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 14, 2005 at 09:13 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

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.