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