Oracle Error Message
ORA-37547: (XSHIERSP01) DIMENSION_MEMBER has no level associated with it.
Reason for the Error
DIMENSION_MEMBER did not have an associated level. Level based hierarchies must have a level for every dimension member.
Solution
Add level assignments for all dimension members in the hierarchy.