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.