Thursday 14 June 2012

ORA-37136: (XSCCOMP11) Cannot ROLLUP dimension workspace object which is a base of COMPRESSED COMPOSITE workspace object, use AGGREGATE instead.

ORA-37136: (XSCCOMP11) Cannot ROLLUP dimension workspace object which is a base of COMPRESSED COMPOSITE workspace object, use AGGREGATE instead.

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

Action: Instead of using ROLLUP, generate an aggmap and use AGGREGATE

No comments:

Post a Comment