How to fix the Oracle error ORA-37548: (XSHIERSP02) DIMENSION_MEMBER is not specified as a member of HIERARCHY1.?

In this post, you’ll learn more about the Oracle ErrorORA-37548: (XSHIERSP02) DIMENSION_MEMBER is not specified as a member of HIERARCHY1. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-37548: (XSHIERSP02) DIMENSION_MEMBER is not specified as a member of HIERARCHY1.

Reason for the Error ORA-37548: (XSHIERSP02) DIMENSION_MEMBER is not specified as a member of HIERARCHY1.

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.

How to fix the Error ORA-37548: (XSHIERSP02) DIMENSION_MEMBER is not specified as a member of HIERARCHY1. ?

You can fix this error in Oracle by following the below steps

Alter the hierarchy’s membership to include the specified dimension member.