Oracle Error ORA-33078: (XSAGDNGL39) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must refer to a dimension.

Oracle Error Message

ORA-33078: (XSAGDNGL39) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must refer to a dimension.

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.