Thursday, 14 June 2012

ORA-37135: (XSCCOMP10) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. The RELATION statement for dense dimension workspace object must precede RELATION statements over the bases of the COMPRESSED COMPOSITE.

ORA-37135: (XSCCOMP10) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. The RELATION statement for dense dimension workspace object must precede RELATION statements over the bases of the COMPRESSED COMPOSITE.

Cause: The user ran AGGREGATE on a variable dimensioned by a COMPRESSED COMPOSITE using an illegal AGGMAP. The AGGMAP contained a RELATION statement over some base of the COMPRESSED COMPOSITE followed by a RELATION over some other dimension of the variable.

Action: Change the order of the RELATION statements in the AGGMAP.

No comments:

Post a Comment