Oracle Error ORA-37542: DIMENSION_MEMBER makes hierarchy HIERARCHY1 unbalanced.

Oracle Error Message

ORA-37542: DIMENSION_MEMBER makes hierarchy HIERARCHY1 unbalanced.

Reason for the Error

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.

Solution

Fix the hierarchy so that it is balanced. This is often done by looking for nulls in the middle levels of a hierarchy.