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 的硬體和軟體需求>。

請參閱

參考

Microsoft.AnalysisServices Namespace