Home > About Dimensional Database ... > About Cubes > Aggregation Operators
![]() Previous |
![]() Next |
Table: OLAP Aggregation Operators describes the aggregation operators. The numeric data types are: BINARY_DOUBLE
, BINARY_FLOAT
, DECIMAL
, FLOAT
, INTEGER
, and NUMBER
OLAP Aggregation Operators
Operator | Data Types | Description |
---|---|---|
Average |
Numeric |
Adds data values, then divides the sum by the number of data values that were added together. |
First Non-NA Data Value |
All |
The first real data value. |
Hierarchical Average |
Numeric |
Adds data values, then divides the sum by the number of the children in the dimension hierarchy. Unlike |
Hierarchical First Member |
All |
The first data value in the hierarchy, even when that value is NA. |
Hierarchical Last Member |
All |
The last data value in the hierarchy, even when that value is NA. |
Hierarchical Weighted Average |
Numeric |
Multiplies non-NA child data values by their corresponding weight values, then divides the result by the sum of the weight values. Unlike |
Hierarchical Weighted First |
Numeric |
The first data value in the hierarchy multiplied by its corresponding weight value, even when that value is NA. Identify the weight object in the Based On field. |
Hierarchical Weighted Last |
Numeric |
The last data value in the hierarchy multiplied by its corresponding weight value, even when that value is NA. Identify the weight object in the Based On field. |
Last Non-NA Data Value |
All |
The last real data value. |
Maximum |
All |
The largest data value among the children of each parent. |
Minimum |
All |
The smallest data value among the children of each parent. |
Nonadditive |
All |
Do not aggregate any data for this dimension. Use this keyword only in an operator variable. It has no effect otherwise. |
Scaled Sum |
Numeric |
Adds the value of a weight object to each data value, then adds the data values. Identify the weight object in the Based On field. |
Sum |
Numeric |
Adds data values. (Default) |
Weighted Average |
Numeric |
Multiplies each data value by a weight factor, adds the data values, and then divides that result by the sum of the weight factors. |
Weighted First |
Numeric |
The first non-NA data value multiplied by its corresponding weight value. |
Weighted Last |
Numeric |
The last non-NA data value multiplied by its corresponding weight value. |
Weighted Sum |
Numeric |
Multiplies each data value by a weight factor, then adds the data values. |