Oracle Error ORA-36989: (XSRELGID23) GROUPSET and ROLLUP options in GROUPINGID require the destination relation.

Oracle Error Message

ORA-36989: (XSRELGID23) GROUPSET and ROLLUP options in GROUPINGID require the destination relation.

Reason for the Error

Either variable or surrrogate dimension was specified as destination.

Solution

Specify the destination relation.