Oracle Error ORA-37541: Hierarchy element DIMENSION_MEMBER can aggregate into element MEMBER_ANCESTOR through multiple paths.

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.