Load Hierachies from BW to BPC Hierarchy

[former_member220155]

Hi,

I am loading  0ACCOUNT hierarchy from BW to BPC I have multiple nodes with different lengths.

BW Hierarchy like this

Node A XXXXYZ10000

  Node B XXXXYZ10006

   Node C XXXXYZ100060

I want strip off first 4 chars XXXX and add the prefix 'A' to YZ10000 like this

BPC Hierarchy should be like this

Node A  AYZ10000

  Node B  AYZ10006

   Node C  AYZ100060

I have created transformation file like this below mapping

NODENAME=*STR(A)+NODENAME(5:11)

HIER_NAME=HIER_NAME

PARENT=PARENT

ORDER=ORDER

IOBNM=IOBJNM

VERSION=VERSION

but I am getting error like duplicated member AYZ10006  since last node length is 12 chars but I am using only length 11 so it is Node B, Node C are getting same and it is giving duplicate error. If I use NODENAME=*STR(A)+NODENAME(5:12) the entire hierarchy is getting failed .

can someone help me how to fix this issue what it best way to do transformation. Please share your ideas on this.

Thanks in advance.

Best regards

SG

[Former Member]

Hi S,

from your question you are saying you want to map all those nodes with the same member IDs?

what do you mean by node A, B, C?

If you replace XXXX with only A then of course you will be getting duplicates as you have 3 similar IDs to start with.

Please tell us what your final results should look like.

Andy

[Shrikant_Jadhav]

Hi,

Try  SUPPRESSCHARACTER=XXXX in OPTIONS section.

May be helpful.

Shrikant