Oracle Error ORA-33922: (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a time dimension.

Oracle Error Message

ORA-33922: (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a time dimension.

Reason for the Error

The user attempted to define a surrogate on a dimension that has type DAY, WEEK, MONTH, or YEAR.

Solution

Do not attempt to define a surrogate on this dimension.