TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

AggregateFunction Element (ASSL)

 

Applies To: SQL Server 2016 Preview

Defines the type of aggregate function used by a Measure element.

  
<Measure>  
   ...  
   <AggregateFunction>...</AggregateFunction>  
   ...  
</Measure>  

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

The value of this element is limited to one of the strings in the following table.

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.
ByAccountThe measure is aggregated by account.
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 AggregateFunction in the Analysis Management Objects (AMO) object model is AggregationFunction.

Properties (ASSL)

Community Additions

ADD
Show:
© 2016 Microsoft