Parent XXXX has different children in ParentH1 and ParentH2

[Former Member]

Hello,

Due to some changes, I have to maintain a hierarchy . Basically there are some changes in top level. Currently we have 2 hierarchies and the structure like below.

ID                 P1                          P2

A                 Empty                     Empty

B                 A                            Empty

C                 B                            Empty

Z                  Empty                    Empty

Y                  Empty                    Z

X                  Empty                    Y

D                  B                           Y        

Here D is also a parent node. when I process the dimension, i'm getting error like Parent D has different children in ParentH1 and ParentH2. I have other parents with different parents but they were fine. Please let me know if I am missing something here.

Thanks.

[former_member186338 · Accepted solution]

Hi Suman,

Something incorrect: BPC standard do not support parents having different children in ParentH1 and ParentH2. By design!

Vadim

[Former Member · Accepted solution]

Hello Vadim,

Thanks for the response. Looking at the error message, I had simillar thought and went on checking hierarchies but they are different. Please see below.

Currently I am getting error for the account 055101 which has different parents in parenth1 and parenth2. however I have other account with different parents but they are fine. Example 044501 which has different ones. I have checked the children of 0445FC and 44500F but they are different.

Kindly let me know if something can be checked.

Thanks,

Suman

[former_member186338 · Accepted solution]

The restriction is not about different PARENTS it's about different CHILDREN of the same parent! Hope you understand me...

Vadim

[former_member186338 · Accepted solution]

Correct:

H1:

PARENT1

     BASE1

     BASE2

H2

PARENT2

     BASE1

PARENT3

     BASE2

Incorrect:

H1:

PARENT1

     BASE1

     BASE2

H2:

PARENT1

     BASE1

In H2 PARENT1 - same as in H1 - has different children!

Vadim

[Former Member · Accepted solution]

Thanks Vadim, found the issue. there were differences in children of the same parent.