Skip to Content
0
Nov 09, 2011 at 02:02 PM

SAP BPC 7.5 SP 7 - Master Data Load Detected duplicate member ID

292 Views

Hi Gurus I have a requirement.

I am loading the Master data for Cost Center - initially while loading master data i didnot load hierarchy. Now I started to load the Master data with Hierarchy but when ever I tried vailidate the transformation file then it is throwing the "Detected Duplicate member "

Let me show you the transformation - what I wrote there

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = TAB

*MAPPING

ID=ID

*CONVERSION

ID=Master_Data_Conversion.xls

Conversion Master_Data_Conversion.xls has the following code this is to remove the spaces EXTERNALINTERNAL

*js:%external%.toString().replace(/\s+/g,"")

Let me show you how I have selected the Data type - Master Data /text from NW BW Infoobject

Selection of infoobject - 0costcenter

Format - External Format

Set Selection - first Tab - Attribute I only wante the Control Area which is 1000 so - Control Area = 1000

2nd Tab - Hierarchy - Import Text node - yes Hierarchy node - xxxxxxx Version - Empty Member ID - first member Level - Blank

3rd Tab Language - English

4th Tab Attribute list - Controling Area only is selected

Note: Let me tell you that when I am loading the Master data with out Hierarchy inthe Set Selection the loading is succesful but when I am doing it with the Hierarchy as mentioned in the 2nd Tab I am getting the error as following.

Master data (dealt by table level) has errors

Detected duplicate member ID '201100'

Also, the Master data for Cost Center in the BW is a time dependent so it is having Valid to and Valid from fields which is not there to be delt in the BPC.

Please Help