BPC Hierarchy Not aligned with BW

[former_member200880]

Dear All

We are facing issue with one dimension [ profit center] hierarchy. The BPC package updating the parenth1 property is not updating for all members.

The BPC package pulls the same hierarchy existing in BW system. However for a a node in BW has nearly 32 child/base members. From this node the last child is not aligned to its node in BPC.

we tried to manually maintain parenth1 property in BPC. However this is not permanent fix.

We tried to assign the member which missing with parenth1 to other node in BW and ran BPC pacakge again. This time that member got new parent, however the last but one under that node lost its parenth1 property.

is there any limitation of child/bas members in hierarchy for a node ?

Please advise

[former_member186338]

"is there any limitation of child/bas members in hierarchy for a node ?" - no, there is no limit!

You are doing something wrong, may be incorrect key date...

[former_member200880]

Hi Vadim

the keydate is set to future date 9999-12-31. Its strange that when we move that member to other Node in bw and run bpc package, that member aligns and the current last but one member in BW is mis-aligning now.

[former_member186338]

"Its strange that when we move that member to other Node in bw and run bpc package, that member aligns and the current last but one member in BW is mis-aligning now." - Sorry, but I do not understand what do you mean!

If you want support - please illustrate your question with screenshots to make the issue clear!

[former_member186338]

P.S. Also - transformation, conversion files are missing

[former_member200880]

HI Vadim

Here is the complete details of the issue

BW - Profit Center:

The member at 1000300416 has parent in BW . Below screen contains member of under a node called 1000P60183. There are nearly 32 member under this node. However the last node 1000300416 in BW lost its relatinship in BPC.

Attached BPC screenshot.

Transformation files/ conversion files are good and checked.

Further tests we performed : We have deleted 1000300416 in BW hierarchy under that node. Now execute bpc hierarchy load. Now the last but member 1000300415 loosing its parent relationship in BPC.

BPC - Profit center Hierarchy

Here 1000300416 is idle, and not under its parent that is in BW system.

[former_member186338]

"Transformation files/ conversion files are good and checked." - sorry, but let me decide.

[former_member200880]

Transformation file

[former_member200880]

Conversion File

[former_member200880]

Conversion file

[former_member200880]

Hi Vadim

Attached both Transformation file and conversion files.

Please let me know your thoughts.