Oracle Error ORA-37551: (XSHIERSP05) Leaf value DIMENSION_MEMBER is not on the same level as the rest of leaf dimension values.

Oracle Error Message

ORA-37551: (XSHIERSP05) Leaf value DIMENSION_MEMBER is not on the same level as the rest of leaf dimension values.

Reason for the Error

The detail or leaf values of this hierarchy must all have the same level. This member is on a different level than most of the leaf values.

Solution

Fix DIMENSION_MEMBER’s level so that all leaves are on the same level.