How to fix the Oracle error ORA-36024: (XSHIERCK05) Valueset workspace object must contain values of one of the extra dimensions of relation workspace object.?

In this post, you’ll learn more about the Oracle ErrorORA-36024: (XSHIERCK05) Valueset workspace object must contain values of one of the extra dimensions of relation workspace object. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36024: (XSHIERCK05) Valueset workspace object must contain values of one of the extra dimensions of relation workspace object.

Reason for the Error ORA-36024: (XSHIERCK05) Valueset workspace object must contain values of one of the extra dimensions of relation workspace object.

The HIERCHECK command specified a valueset over an invalid dimension.

How to fix the Error ORA-36024: (XSHIERCK05) Valueset workspace object must contain values of one of the extra dimensions of relation workspace object. ?

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

Specify a valueset containing values of one of the self-relation’s extra dimensions (the dimensions in the relation’s dimension list, minus the self-related dimension itself).