Member of dimension has an invalid hierarchy parent 'RC4 48' in BPC 10.1

[Former Member]

Hello BPC experts !

I'm new to BPC , and I'm getting the following error Member of dimension has an invalid hierarchy parent 'RC4 48' in BPC 10.1 . Parent is 'RC4 48' . It looks like there is a space in the node. I think it is because of the space in RC4 48" and I would like to load RC448 without space

How do I find out the offset of the space so that I can remove it (script logic) and how do I remove an unwanted space in transformation.

[Former Member]

Hi Vadim,

Never mind....thanks for your willing to help !

[former_member186338]

Strange... I am lost with your requirements 🙂

[former_member186338]

Then you can use JavaScript in the conversion file to remove 2000 at the beginning.

Or simply 2000* to *

[Former Member]

The following is what I want to have :

200ABBB --> parent node

BBBD-BFDD ---> child node

25525

25825

58258

[Former Member]

This is what I have in BW hierarchy structure:

200ABBB --> parent node

BBBD-BFDD ---> child node

200025525

200025825

200058258

[former_member186338]

And what do you want to have in BPC?

[former_member186338]

I am not sure that the idea to do something based on length is correct... But you can use JavaScript in the conversion file.

[former_member186338]

Please explain using some sample: what you have in BW and what do you want to have in BPC.

[Former Member]

I'm loading master data from a BW info Object with a hierarchy. The hierarchy nodes have different number of characteristics. I need to add a logic in my transformation file which allows me to know if a member I'm trying to load is a text node member or a simple attribute.

The data is like this

200ABBB --> parent node

BBBD-BFDD ---> child node

200025525

200025825

200058258

Where 200 is the company code.

The problem is that the hierarchy nodes are not of the same size, and don't all contain company code. But the attributes have the same size , but I don't want to load the company code.

in my transformation file , mapping section, I need to do some thing like :

ID=*IF(ID.toString.lenth <> 10 then ID+ID(5:10)

if the length is greater different than 10 , I know that is it a text node for the hierarchy otherwise give me the last 5 characters of the attribute.

I can also figure out if a member is composed of number value then I can tell which one is attribute or a text node.

[Former Member]

Hi Vadim,

Yes, you are right, and I think I have figured out how to remove the space in the hierarchy node. Now do you know about any way/sript logic function I can use to test the length of hierarchy node if it is not fixed ? In BW you can use strlen( string ) which will give you the length of the string. Dow we have something like that in BPC script logic ?

[former_member186338]

Sorry, but absolutely not clear! Script logic has no relation to master data load. What do you want to achieve in general?

[former_member186338]

Loading master data from BW is 2 step process. First you load all members including base and parents. Second you establish relationship between members. The same logic has to be used in conversion for both steps. You have to replace spaces on the first step also.