Oracle Solution for Error ora-36982

ORA-36982: (XSRELGID03) The destination variable/relation workspace object

must be dimensioned by all dimensions of the source relation workspace object

that have more than one value in status.

What triggered the Error:

Destination variable/relation does not have enough dimensionality to hold the result from the multi-dimensional source relation.

What should we do to fix it:

Either limit the status of hierarchy dimensions or redefine the destination variable/relation with the extended dimensionality