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

175 Views

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.