Oracle Error ORA-37552: (XSHIERSP06) DIMENSION_MEMBER is associated with a level not found in the levelorder valueset.

Oracle Error Message

ORA-37552: (XSHIERSP06) DIMENSION_MEMBER is associated with a level not found in the levelorder valueset.

Reason for the Error

DIMENSION_MEMBER must have an associated level that is found in the levelorder valueset so that we can figure out DIMENSION_MEMBER’s level depth.

Solution

Fix DIMENSION_MEMBER’s associated level.