Oracle Error ORA-37549: (XSHIERSP03) The level of DIMENSION_MEMBER is not lower than the level of MEMBER_ANCESTOR.

Oracle Error Message

ORA-37549: (XSHIERSP03) The level of DIMENSION_MEMBER is not lower than the level of MEMBER_ANCESTOR.

Reason for the Error

A dimension member has a parent that is lower or on the same level as this member according to the levelorder valueset.

Solution

Fix the child and/or parent levels so that every dimension member has a parent whose level is higher than the level of this member.