Oracle Error ORA-33022: (XSAGDNGL10) The measure dimension workspace object must be a TEXT or ID base dimension that does not dimension AGGMAP workspace object, but is in the same analytic workspace.

Oracle Error Message

ORA-33022: (XSAGDNGL10) The measure dimension workspace object must be a TEXT or ID base dimension that does not dimension AGGMAP workspace object, but is in the same analytic workspace.

Reason for the Error

A MEASUREDIM was supplied in the AGGMAP that was not acceptable.

Solution

Modify the MEASUREDIM clause to specify a valid dimension.