AggregationFunction Enumeration
Defines the type of aggregation that can be set for measures or dimensions.
命名空间: Microsoft.AnalysisServices
程序集: Microsoft.AnalysisServices (in microsoft.analysisservices.dll)
语法
声明
<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
Members
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. |
备注
新增日期:2006 年 7 月 17 日
The following aggregation functions are not supported ByAccount:
None
DistinctCount
Count
Min
Max
平台
开发平台
有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。
目标平台
有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。