Oracle Solution for Error ora-37136

ORA-37136: (XSCCOMP11) Cannot ROLLUP dimension workspace object

which is a base of COMPRESSED COMPOSITE workspace object

, use AGGREGATE instead.

What triggered the Error:

The user ran ROLLUP on a variable dimensioned by a COMPRESSED COMPOSITE.

What should we do to fix it:

Instead of using ROLLUP, generate an aggmap and use AGGREGATE