title | description | ms.date | ms.service | ms.custom | ms.topic | ms.author | ms.reviewer | author |
---|---|---|---|---|---|---|---|---|
AggregationFunction Element (ASSL) | Microsoft Docs |
Learn about the AggregationFunction property element in the Analysis Services Scripting Language (ASSL) schema. |
10/31/2023 |
analysis-services |
assl |
reference |
kfollis |
kfollis |
kfollis |
Contains the aggregation function to use for the account type.
<Account>
...
<AggregationFunction>...</AggregationFunction>
...
</Account>
Characteristic | Description |
---|---|
Data type and length | String (enumeration) |
Default value | Sum |
Cardinality | 0-1: Optional element that can occur once and only once. |
Relationship | Element |
---|---|
Parent elements | Account |
Child elements | None |
The value of this element is limited to one of the following strings:
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. |
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 AggregationFunction in the Analysis Management Objects (AMO) object model is xref:Microsoft.AnalysisServices.AggregationFunction.