AggregateFunction Element (ASSL)
Defines the type of aggregate function used by a Measure element.
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.
