Skip to Content
0

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

Nov 01, 2016 at 05:29 PM

222

avatar image
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.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

8 Answers

Vadim Kalinin Nov 01, 2016 at 06:15 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 02, 2016 at 02:01 PM
0

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 ?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

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

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.

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Nov 02, 2016 at 03:03 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

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

This is what I have in BW hierarchy structure:

200ABBB --> parent node

BBBD-BFDD ---> child node

200025525

200025825

200058258

Show 1 Share
10 |10000 characters needed characters left characters exceeded

And what do you want to have in BPC?

0
Vadim Kalinin Nov 02, 2016 at 04:32 PM
0

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

Or simply 2000* to *

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 02, 2016 at 04:22 PM
0

The following is what I want to have :

200ABBB --> parent node

BBBD-BFDD ---> child node

25525

25825

58258

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 02, 2016 at 05:20 PM
0

Hi Vadim,

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Strange... I am lost with your requirements :)

0