AggregationFunction Enum

Definition

Namespace:

Microsoft.AnalysisServices

Assembly:

Microsoft.AnalysisServices.dll

Package:

Microsoft.AnalysisServices v19.88.3

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

C#

[System.Runtime.InteropServices.Guid("9CBD8B45-C8F6-4cd3-AAD5-17CF7675AB21")]
public enum AggregationFunction

Inheritance

Enum

AggregationFunction

Attributes

GuidAttribute

Fields

Name	Value	Description
Sum	0	Specifies the sum of members. This is the default aggregation function.
Count	1	Specifies the count of measure members.
Min	2	Specifies the minimum value of members.
Max	3	Specifies the maximum value of members.
DistinctCount	4	Specifies the count of distinct measure members.
None	5	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.
ByAccount	6	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.
AverageOfChildren	7	Specifies average of leaf descendants in time. Average does not count an empty value as 0.
FirstChild	8	Specifies the first child member along Time dimension.
LastChild	9	Specifies the last child member along Time dimension.
FirstNonEmpty	10	Specifies the first non empty child member along Time dimension.
LastNonEmpty	11	Specifies the last non empty child member along Time dimension.

Remarks

The following aggregation functions are not supported ByAccount: * None * DistinctCount * Count * Min * Max

Applies to