Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

AggregationFunction Enumeration

 

Applies To: SQL Server 2016 Preview

Defines the type of aggregation that can be set for measures or dimensions.

Namespace:   Microsoft.AnalysisServices
Assembly:  Microsoft.AnalysisServices (in Microsoft.AnalysisServices.dll)

[GuidAttribute("9CBD8B45-C8F6-4cd3-AAD5-17CF7675AB21")]
public enum AggregationFunction

Member nameDescription
AverageOfChildren

Specifies average of leaf descendants in time. Average does not count an empty value as 0.

ByAccount

Specifies that the aggregation used will be determined for each CurrentMember of the Account dimension according to its account type. Unmapped account types aggregate as SUM.

Count

Specifies the count of measure members.

DistinctCount

Specifies the count of distinct measure members.

FirstChild

Specifies the first child member along Time dimension.

FirstNonEmpty

Specifies the first non empty child member along Time dimension.

LastChild

Specifies the last child member along Time dimension.

LastNonEmpty

Specifies the last non empty child member along Time dimension.

Max

Specifies the maximum value of members.

Min

Specifies the minimum value of members.

None

No aggregations are performed on any dimension – data is only available on the leaf cells. If no value from the fact table has been read in for a member, then the cell value for the member is considered to be Null.

Sum

Specifies the sum of members. This is the default aggregation function.

New: 17 July 2006

The following aggregation functions are not supported ByAccount:

  • None

  • DistinctCount

  • Count

  • Min

  • Max

Return to top

Community Additions

Show:
© 2015 Microsoft