Oracle Error ORA-33080: (XSAGDNGL40) In AGGMAP workspace object, you cannot reference dimension workspace object with both a RELATION statement and a DIMENSION statement.

Oracle Error Message

ORA-33080: (XSAGDNGL40) In AGGMAP workspace object, you cannot reference dimension workspace object with both a RELATION statement and a DIMENSION statement.

Reason for the Error

The user included both RELATION and DIMENSION statements in the AGGMAP referring to the same AGGMAP.

Solution

Remove one of the conflicting clauses.