AggregateFunction Element (ASSL)
APPLIES TO:SQL Server Analysis ServicesAzure Analysis Services
Defines the type of aggregate function used by a Measure element.
<Measure> ... <AggregateFunction>...</AggregateFunction> ... </Measure>
|Data type and length||String (enumeration)|
|Cardinality||0-1: Optional element that can occur once and only once.|
The value of this element is limited to one of the strings in the following table.
|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.