Oracle Solution for Error ora-33003

ORA-33003: (XSAGDIMDROP) workspace object

, to be transformed during data load, must be a base dimension and not otherwise referenced in the AGGMAP.

What triggered the Error:

The user tried to specify a dimension in a dataflow-related clause in an aggmap which is already in another RELATION statement, DIMENSION statement, or possibly dimensioning the AGGMAP, or they specified a composite or conjoint dimension, or an object which is not a dimension

What should we do to fix it:

Remove the conflicting reference or specify a valid object