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

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

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.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...