ERROR LOADING HIERARCHY- Detected duplicate member

[Former Member]

Hi experts,

I´m trying to load 0COSTCENTER hierarchy to BPC. But it fails when loading because of "Detected duplicate member".

Looking in BW, the ID of the 0HIER_NODE is the same ID as 0COST_CENTER.

How can I make a transformation file that identify when is a Node and when is an InfoObject?

[Former Member]

Hi Maria,

few options,

• change/fix in BW
• in the transformation file nodename line, you can prefix the nodes to something else, then all nodename will change

I would prefer to fix it in BW.

Andy

[Former Member]

Not an option to fix or change in BW.

So, the unique option is in the transformation file. I have put prefix to nodes but it still throws the same error of duplicate member.

How can I do a parameter that when the node is not a parent then respect the same nodename. Example, NODENAME= *IF InfoObject=0COSTCENTER then NODENAME, InfoObject=0HIER_NODE then *STR(N)+NODENAME

Anny suggestions?

[Former Member]

Hi Maria,

I thought about it and my suggestion wasn't complete.

You can only prefix to IDs and nodenames, the one from master data load and one from hierarchy load.

so whatever you are doing for ID you need to apply to nodename.

You can not change the parent IDs, unless you use routines in the transformation file.

For what you suggested can be done using routines, you need an ABAPer for that.

Andy

[Former Member]

Hi Maria.....Can you take one example and explain a little in detail about the cost center hierarchy.....Is it only one case that there is duplicate member or very few or in many nos.

What are the Set Selection parameters selected during the Transformation file validation and the error log....Please share screenshots.

If the duplicate members are less, then you can use conversion file to rename the node names.

Hope this helps...

Regards,

JP