duplicate key loading a Hierarchy from bw to BPC 10 NW

[michele_medaglia5]

Hi BPC Friends

I am loading a BW Hiearchy to BPC and I have this message:

duplicate key for   CC_117334200

I went to BW and I saw that it is true but one is a folder and the other is a base member as you can see in the screenshot

How can I load this hierarchy?

[Former Member · Accepted solution]

The hierachy textnode (Warehouse & Distribution) needs to be changed to a unique name.  I assume this was defined in ECC and could be changed there.

The Node name for 0COSTCENTER is based off a concatenation of the masterdata id and controlling area id.  In this case a hierachy textnode with a duplicate id (to cost center) has been created.  The only way to corrected this on the BPC side is to do some mapping in the transformation file but then you will create inconsistencies in your masterdata between ECC/BW/BPC.