Oracle Error ORA-33014: (XSAGDNGL06) In AGGMAP workspace object, variable operator workspace object cannot be dimensioned by rollup dimension workspace object.

Oracle Error Message

ORA-33014: (XSAGDNGL06) In AGGMAP workspace object, variable operator workspace object cannot be dimensioned by rollup dimension workspace object.

Reason for the Error

Operator variables cannot have the rollup dimension as one of their base dimensions.

Solution

Modify the definition of the operator variable so that the current rollup dimension is not one of its bases.