Oracle Solution for Error ora-33042

ORA-33042: (XSAGDNGL20) In AGGMAP workspace object

, VALUESET workspace object

must qualify all relations dimensioned by workspace object

.

What triggered the Error:

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

What should we do to fix it:

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