Cube

Definition

Returns a GroupBy clause and extra rows that represent the subtotals for all combinations of grouping columns. Cube creates all possible grouping sets (see example).

Options

1. Cube columns (+add):

2. Agg function (+add):

Parameters

1. Column input:

   • Def: Specify the name of the column.

2. Column output:

   • Def: Specify the name of the column.

3. Function:

   • Def: Specify the function to use.

Additionnal Comments

Functions:

1. count:

   • Def: Count the element in the Column input for each group.
     Link to the Count page.

2. sum:

   • Def: Sum all the element of the Column input for each group.
     Link to the Sum page.

3. avg:

   • Def: Returns the average of the Column input for each group.
     Link to the Average page.

4. mean:

   • Def: Returns the mean of the Column input for each group.

5. var:

   • Def: Returns the variance of the Column input for each group.
     Link to the Var page.

6. std:

   • Def: Returns the standart deviation of the Column input for each group.

7. max:

   • Def: Returns the maximum value of the Column input for each group.
     Link to the Max page.

8. min:

   • Def: Returns the maximum value of the Column input for each group.
     Link to the Min page.

Example

CUBE(YEAR,MONTH,DAY)

• YEAR,MONTH,DAY
  YEAR,MONTH
  YEAR,DAY
  YEAR
  MONTH,DAY
  MONTH
  DAY