Oracle Error Message
ORA-36024: (XSHIERCK05) Valueset workspace object must contain values of one of the extra dimensions of relation workspace object.
Reason for the Error
The HIERCHECK command specified a valueset over an invalid dimension.
Solution
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).