ORA-37542
DIMENSION_MEMBER makes hierarchy HIERARCHY1 unbalanced.
Cause
An unbalanced hierarchy was detected, either because not all members of a level were at the same depth from the hierarchy root, // or one or more members of different levels were at the same depth // from the root, or both.
Action
Fix the hierarchy so that it is balanced. Ensure you check for nulls in the middle levels of the hierarchy.
ORA-37542
DIMENSION_MEMBER makes hierarchy HIERARCHY1 unbalanced.
Cause
A hierarchy is balanced if: 1) All members of a level are at the same depth from the root of the hierarchy and 2) All the members in different levels are at different depths from the root of the hierarchy.
Action
Fix the hierarchy so that it is balanced. This is often done by looking for nulls in the middle levels of a hierarchy.
ORA-37542
DIMENSION_MEMBER makes hierarchy HIERARCHY1 unbalanced.
Cause
A hierarchy is balanced if: 1) All members of a level are at the same depth from the root of the hierarchy and 2) All the members in different levels are at different depths from the root of the hierarchy.
Action
Fix the hierarchy so that it is balanced. This is often done by looking for nulls in the middle levels of a hierarchy.
