Oracle Error ORA-33040: (XSAGDNGL19) In AGGMAP workspace object, VALUESETS workspace object and workspace object are both over the same hierarchy dimension.

Oracle Error Message

ORA-33040: (XSAGDNGL19) In AGGMAP workspace object, VALUESETS workspace object and workspace object are both over the same hierarchy dimension.

Reason for the Error

Two or more different VALUESETs over the same hierarchy dimension are used in the AGGMAP.

Solution

Use the same VALUESET for two RELATION phrases or use two different VALUESETs over two different hierachy dimensions.