The Rules tab identifies the aggregation rules for the measure.
Order
The order in which the dimensions are aggregated. When the aggregation operators are the same across all dimensions, the order is not important. However, some combinations of operations produce different results depending on the order in which they are calculated. To change the order, select a dimension and use the arrow keys to move it up or down the list.
Dimension
The dimensions in the measure that will be aggregated.
Operator
Choose the type of calculation you wish to perform across each dimension.
| Operator | Description |
|---|---|
| Average | Adds data values, then divides the sum by the number of data values that were added together. |
| First Non-NA Data Value | The first real data value. |
| Hierarchical Average | 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 | The first data value in the hierarchy, even when that value is NA. |
| Hierarchical Last Member | The last data value in the hierarchy, even when that value is NA. |
| Hierarchical Weighted Average | 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 | 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 | 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 | The last real data value. |
| Maximum | The largest data value among the children of each parent. |
| Minumum | The smallest data value among the children of each parent. |
| Nonadditive | Do not aggregate any data for this dimension. Use this keyword only in an operator variable. It has no effect otherwise. |
| Scaled Sum | 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 | Adds data values. (Default) |
| Weighted Average | () Multiplies each data value by a weight factor, adds the data values, and then divides that result by the sum of the weight factors. Identify the weight object in the Based On field. |
| Weighted First | The first non-NA data value multiplied by its corresponding weight value. Identify the weight object in the Based On field. |
| Weighted Last | The last non-NA data value multiplied by its corresponding weight value. Identify the weight object in the Based On field. |
| Weighted Sum | Multiplies each data value by a weight factor, then adds the data values. Identify the weight object in the Based On field. |
Based On
When using a weighted or scaled operator, select a measure that contains weight factors. The measure must be dimensioned by the dimension being aggregated, and can optionally be dimensioned by other dimensions in the cube.
Aggregation Hierarchies
Select one or more hierarchies for each dimension being aggregated. If you omit a hierarchy, then no aggregate values are stored for it; they are always calculated in response to a query. Because this will degrade runtime performance, you should omit a hierarchy only if it is seldom used.
Copyright © 2003, 2007, Oracle. All rights reserved.