ORA-37541
Hierarchy element DIMENSION_MEMBER can aggregate into element MEMBER_ANCESTOR through multiple paths.
Cause
Multiple aggregation paths were detected for one or more low-level hierarchy elements. This could cause such elements to be counted // more than once in the elements to which they aggregate.
Action
Eliminate multiple paths from the hierarchy.
ORA-37541
Hierarchy element DIMENSION_MEMBER can aggregate into element MEMBER_ANCESTOR through multiple paths.
Cause
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.
Action
Eliminate multiple paths from the hierarchy.
ORA-37541
Hierarchy element DIMENSION_MEMBER can aggregate into element MEMBER_ANCESTOR through multiple paths.
Cause
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.
Action
Eliminate multiple paths from the hierarchy.
