CUBE { ordinary_grouping_set | (ordinary_grouping_set) }
Syntax Elements
- ordinary_grouping_set
- One or more expressions used to group cubed report rows across multiple dimensions.
- All ordinary grouping sets must make explicit column references. You cannot specify column positions with CUBE.
- You cannot specify more than 8 columns in the ordinary grouping sets.
- This limit is on the number of table dimensions that can be cubed. The value is much smaller than the limits for the ROLLUP and GROUPING SETS options because this value specifies a limit of 28, or 256 different combinations of columns, not only columns.
- To reference a column that has a LOB data type, do one of the following:
- Cast the LOB to a non-LOB type (for example, cast BLOB to BYTE or VARBYTE, cast CLOB to CHARACTER or VARCHAR)
- Pass the LOB to a function whose result is not a LOB.