AggregationFunction Enumeration
Defines the type of aggregation that can be set for measures or dimensions.
Espace de noms: Microsoft.AnalysisServices
Assembly: Microsoft.AnalysisServices (in microsoft.analysisservices.dll)
Syntaxe
'Déclaration
<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. |
Notes
Nouveau :17 juillet 2006
The following aggregation functions are not supported ByAccount:
None
DistinctCount
Count
Min
Max
Plateformes
Plateformes de développement
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Plateformes cibles
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.