Oracle Error Message
ORA-37541: Hierarchy element DIMENSION_MEMBER can aggregate into element MEMBER_ANCESTOR through multiple paths.
Reason for the Error
When a low level hierarchy element can reach an aggregate element by more than one path through the hierarchy, it is said to have multiple paths. The danger is that the value of the low level hierarchy element will have its value counted multiple times (once per path) in the total of the aggregate element.
Solution
Eliminate multiple paths from the hierarchy.