Skip to Content
avatar image
Former Member

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

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.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Nov 01, 2016 at 06:15 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2016 at 02:01 PM

    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 ?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2016 at 02:59 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2016 at 03:03 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2016 at 03:49 PM

    This is what I have in BW hierarchy structure:

    200ABBB --> parent node

    BBBD-BFDD ---> child node

    200025525

    200025825

    200058258

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2016 at 04:32 PM

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

    Or simply 2000* to *

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2016 at 04:22 PM

    The following is what I want to have :

    200ABBB --> parent node

    BBBD-BFDD ---> child node

    25525

    25825

    58258

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2016 at 05:20 PM

    Hi Vadim,

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

    Add comment
    10|10000 characters needed characters exceeded