다음을 통해 공유


AggregateFunction Element (ASSL)

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

구문

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

Element Characteristics

Characteristic Description

Data type and length

String (enumeration)

Default value

Sum

Cardinality

0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element

Parent elements

Measure

Child elements

None

주의

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.

참고 항목

참조

Properties (ASSL)

도움말 및 정보

SQL Server 2005 지원 받기