Oracle Error ORA-33066: (XSAGDNGL32) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must be a hierarchy dimension of the relation.

Oracle Error Message

ORA-33066: (XSAGDNGL32) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must be a hierarchy dimension of the relation.

Reason for the Error

The user specified an invalid qualified data reference for the hierarchy dimension.

Solution

Adjust the AGGMAP so that it uses a valid dimension value qualified data reference.