AggregationFunction Enum

Definition

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

[System.Runtime.InteropServices.Guid("9CBD8B45-C8F6-4cd3-AAD5-17CF7675AB21")]
public enum AggregationFunction
[<System.Runtime.InteropServices.Guid("9CBD8B45-C8F6-4cd3-AAD5-17CF7675AB21")>]
type AggregationFunction = 
Public Enum AggregationFunction
Inheritance
AggregationFunction
Attributes

Fields

AverageOfChildren 7

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

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.

Count 1

Specifies the count of measure members.

DistinctCount 4

Specifies the count of distinct measure members.

FirstChild 8

Specifies the first child member along Time dimension.

FirstNonEmpty 10

Specifies the first non empty child member along Time dimension.

LastChild 9

Specifies the last child member along Time dimension.

LastNonEmpty 11

Specifies the last non empty child member along Time dimension.

Max 3

Specifies the maximum value of members.

Min 2

Specifies the minimum value of 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.

Sum 0

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

Remarks

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

Applies to