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 ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...