Oracle Solution for Error ora-33072

ORA-33072: (XSAGDNGL35) In AGGMAP workspace object

, the hierarchy dimension QDR over dimension workspace object

must be specified for every relation dimensioned by that hierarchy dimension.

What triggered the Error:

Multiple dimensions share the same hierarchy dimension, but it is only qualified within a subset of the AGGMAP relations.

What should we do to fix it:

Adjust the AGGMAP so that it uses consistent qualified data references.