AggregateFunction Element (ASSL)
Defines the type of aggregate function used by a Measure element.
Syntax
<Measure>
...
<AggregateFunction>...</AggregateFunction>
...
</Measure>
Element Characteristics
Characteristic |
Description |
|---|---|
Data type and length |
String (enumeration) |
Default value |
Sum |
Cardinality |
0-1: Optional element that can occur once and only once. |
Remarks
The value of this element is limited to one of the strings in the following table.
Value |
Description |
|---|---|
Sum |
The measure is aggregated using the Sum function. |
Count |
The measure is aggregated using the Count function. |
Min |
The measure is aggregated using the Min function. |
Max |
The measure is aggregated using the Max function. |
DistinctCount |
The measure is aggregated using the DistinctCount function. |
None |
The measure is not aggregated. |
ByAccount |
The measure is aggregated by account. |
AverageOfChildren |
The measure is aggregated by returning the average of its children. |
FirstChild |
The measure is aggregated by returning its first child member. |
LastChild |
The measure is aggregated by returning its last child member. |
FirstNonEmpty |
The measure is aggregated by returning its first nonempty member. |
LastNonEmpty |
The measure is aggregated by returning its last nonempty member. |
The enumeration that corresponds to the allowed values for AggregateFunction in the Analysis Management Objects (AMO) object model is AggregationFunction.