Skip Headers
Previous
Previous
 
Next
Next

Aggregation Operators

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 AVERAGE, which counts only non-NA children, HAVERAGE counts all of the logical children of a parent, regardless of whether each child does or does not have a value.

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 WAVERAGE, HWAVERAGE includes weight values in the denominator sum even when the corresponding child values are NA. Identify the weight object in the Based On field.

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.