Oracle Error Message
ORA-37548: (XSHIERSP02) DIMENSION_MEMBER is not specified as a member of HIERARCHY1.
Reason for the Error
When a dimension member is part of a hierarchy, it appears in the INHIER valueset associated with the hierarchy. This dimension member is missing from this value set and thus should not be part of this hierarchy.
Solution
Alter the hierarchy’s membership to include the specified dimension member.