Oracle Error ORA-37550: (XSHIERSP04) The level of MEMBER_ANCESTOR is not one level above DIMENSION_MEMBER.

Oracle Error Message

ORA-37550: (XSHIERSP04) The level of MEMBER_ANCESTOR is not one level above DIMENSION_MEMBER.

Reason for the Error

A dimension member has a parent that is not one level above the level of 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 one level above the level of this member according to the levelorder.