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

Can't process dimension because of duplicated member that can't be removed.

Hello experts,

I don't how it happens, but I have for my dimension "Material" a duplicated record.

When I "maintain dimension" I can see my correct material line with all properties and description filled, and another line with only the ID filled, it is prefixed with a space ' '.

I can't delete the line : when I process the dimension I get the error message :

Delete and insert member '0001' in one transaction is NOT allowed!

Duplicated member ID '0001' detected!

Error in Admin module.

This thread as the same error and is "Answered" but no precision on the way to solve the problem :

BPC Duplicate Member

I precise that my BW cube contains both loaded data and data coming from input schedules, so I can't delete all data.

When I manage the infoobject Material from the backend I can't delete the problematic line.

Thanks in advance for your help.

Guillaume P.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jul 04, 2011 at 03:10 PM

    Hello Guillaume,

    First question would be: what do you want to do with records that have all members same and only material different, i.e.one of those two members. Do you want to add those records or override with the latest?

    Lets' assume for simplicity that you don't have such records.

    Can you find out if that member that you want to delete is in loaded data or in Input schedule data? If it's in loaded data that you can reload, then you can selectively delete that data fix MD and reload corrected Transaction Data.

    Another option would be to export those records into a flat file, fix that member, delete wrong records from the Application and load those records back.

    One more option, is to write a simple script that moved data from 0001 to some other member and makes 0001 values zeroes; than run Light Optimization with zero elimination, fix 0001 from MD and than similar script that moved data back to corrected 0001.

    Please let me know if none of this works for you,

    Gersh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi

      I have the same problem

      But the situation is a little different

      I donot have T data in the me to be delted

      nor

      i could save the data of the infoobject after deleting the particular member with or without sids

      any suggestions how to delete from the backend

      so i can process the dimension successfully

      thanks

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.