Forum Stats

  • 3,838,667 Users
  • 2,262,392 Discussions
  • 7,900,730 Comments

Discussions

MetaData Rule Failed:-The member ' ' cannot have multiple parents in the same hierarchy ' '

Dear Gurus,

We are trying to pull the entity hierarchy from EBS to Hyperion through FDMEE-Metadata rule, but its failing with below error in process log

error:-

RuntimeError: The hierarchy '9100000' for dimension 'Entity' is invalid.  The member '9101200' cannot have multiple parents in the same hierarchy '9100000'.

FDMEE Setup:-

EPMA Option:-Replace

pastedImage_3.png

Backend table:-

AIF_DIM_HIERARCHIES_STG

pastedImage_2.png

So we were expecting, the process should run and create one base member 9101200 under 9101000 and shared member 9100000.

Could anyone please explain the concept on this and help us to resolve this kind of issues.