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.