How to fix the Oracle error ORA-33998: (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object.?

In this post, you’ll learn more about the Oracle ErrorORA-33998: (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-33998: (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object.

Reason for the Error ORA-33998: (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object.

The user attempted to include both a dimension and its surrogate in the DIMENSION statement of a model.

How to fix the Error ORA-33998: (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object. ?

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

Use either the dimension or the surrogate in the DIMENSION statement of the model, but not both.