ORA-37541: Hierarchy element DIMENSION_MEMBER can aggregate into element

michaeljet

ORA-37541: Hierarchy element DIMENSION_MEMBERcan aggregate into element

MEMBER_ANCESTOR through multiple paths.

Cause: When a low level hierarchyelement can reach an aggregate element by

more than one path through the hierarchy, it is said tohave multiple paths. The

danger is that the value of the low level hierarchyelement will have its value

counted multiple times (once per path) in the total ofthe aggregate element.

Action: Eliminate multiple paths fromthe hierarchy.