AggregationFunction Element
TOC
Collapse the table of content
Expand the table of content

AggregationFunction Element (ASSL)

 

Applies To: SQL Server 2016 Preview

Contains the aggregation function to use for the account type.

  
<Account>  
   ...  
   <AggregationFunction>...</AggregationFunction>  
   ...  
</Account>  

CharacteristicDescription
Data type and lengthString (enumeration)
Default valueSum
Cardinality0-1: Optional element that can occur once and only once.
RelationshipElement
Parent elementsAccount
Child elementsNone

The value of this element is limited to one of the following strings:

ValueDescription
SumThe measure is aggregated using the Sum function.
CountThe measure is aggregated using the Count function.
MinThe measure is aggregated using the Min function.
MaxThe measure is aggregated using the Max function.
DistinctCountThe measure is aggregated using the DistinctCount function.
NoneThe measure is not aggregated.
AverageOfChildrenThe measure is aggregated by returning the average of its children.
FirstChildThe measure is aggregated by returning its first child member.
LastChildThe measure is aggregated by returning its last child member.
FirstNonEmptyThe measure is aggregated by returning its first nonempty member.
LastNonEmptyThe 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 AggregationFunction.

Accounts Element (ASSL)
Properties (ASSL)

Community Additions

ADD
Show:
© 2016 Microsoft