Oracle Error ORA-36993: (XSRELGID10) OBJECT workspace object must be a VARIABLE, RELATION, or a numeric SURROGATE DIMENSION based on the level dimension workspace object.

Oracle Error Message

ORA-36993: (XSRELGID10) OBJECT workspace object must be a VARIABLE, RELATION, or a numeric SURROGATE DIMENSION based on the level dimension workspace object.

Reason for the Error

not a surrogate dimension, or the surrogate dimension is not based on the level dimension.

Solution

modify/change the surrogate dimension.