AggregationFunction Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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
| 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