Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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)
[GuidAttribute("9CBD8B45-C8F6-4cd3-AAD5-17CF7675AB21")]
public enum AggregationFunction
Member nameDescription
AverageOfChildrenSpecifies average of leaf descendants in time. Average does not count an empty value as 0.
ByAccountSpecifies 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.
CountSpecifies the count of measure members.
DistinctCountSpecifies the count of distinct measure members.
FirstChildSpecifies the first child member along Time dimension.
FirstNonEmptySpecifies the first non empty child member along Time dimension.
LastChildSpecifies the last child member along Time dimension.
LastNonEmptySpecifies the last non empty child member along Time dimension.
MaxSpecifies the maximum value of members.
MinSpecifies the minimum value of members.
NoneNo 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.
SumSpecifies 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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.