Oracle Error ORA-33042: (XSAGDNGL20) In AGGMAP workspace object, VALUESET workspace object must qualify all relations dimensioned by workspace object.

Oracle Error Message

ORA-33042: (XSAGDNGL20) In AGGMAP workspace object, VALUESET workspace object must qualify all relations dimensioned by workspace object.

Reason for the Error

A VALUESET over a hierarchy dimension qualifies some RELATIONs but not all RELATIONs dimensioned by the same hierarchy dimension.

Solution

Use the same VALUESET to qualify all the RELATIONs dimensioned by the same hierarchy dimension.