Oracle Error ORA-33918: (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.

Oracle Error Message

ORA-33918: (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.

Reason for the Error

Not all kinds of dimensions can have surrogates. The user attempted to define a surrogate of a prohibited kind of dimension.

Solution

Do not attempt to define a surrogate on this dimension.