AggregationFunction Enumeration

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

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

Syntax

'Declaration
<GuidAttribute("9CBD8B45-C8F6-4cd3-AAD5-17CF7675AB21")> _
Public Enumeration AggregationFunction

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

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

/** @attribute GuidAttribute("9CBD8B45-C8F6-4cd3-AAD5-17CF7675AB21") */ 
public enum AggregationFunction

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

Member name	Description
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: