Oracle Error ORA-33034: (XSAGDNGL16) In AGGMAP workspace object, VALUESET workspace object in PRECOMPUTE phrase must be in the self dimension of the relation.

Oracle Error Message

ORA-33034: (XSAGDNGL16) In AGGMAP workspace object, VALUESET workspace object in PRECOMPUTE phrase must be in the self dimension of the relation.

Reason for the Error

The precompute phrase contains a valueset which is not over the self dimension of the relation.

Solution

Correct the relation phrase to contain a valueset over the self dimension or not to contain any valueset.