Oracle Error ORA-33074: (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.

Oracle Error Message

ORA-33074: (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.

Reason for the Error

The hierarchy dimension offset is an invalid dimension position.

Solution

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