AggregationFunction Enumeración
Defines the type of aggregation that can be set for measures or dimensions.
Espacio de nombres: Microsoft.AnalysisServices
Ensamblado: Microsoft.AnalysisServices (en Microsoft.AnalysisServices.dll)
Sintaxis
'Declaración
<GuidAttribute("9CBD8B45-C8F6-4cd3-AAD5-17CF7675AB21")> _
Public Enumeration AggregationFunction
'Uso
Dim instance As AggregationFunction
[GuidAttribute("9CBD8B45-C8F6-4cd3-AAD5-17CF7675AB21")]
public enum AggregationFunction
[GuidAttribute(L"9CBD8B45-C8F6-4cd3-AAD5-17CF7675AB21")]
public enum class AggregationFunction
[<GuidAttribute("9CBD8B45-C8F6-4cd3-AAD5-17CF7675AB21")>]
type AggregationFunction
public enum AggregationFunction
Miembros
| Nombre del miembro | Descripción | |
|---|---|---|
| Sum | Specifies the sum of members. This is the default aggregation function. | |
| Count | Specifies the count of measure members. | |
| Min | Specifies the minimum value of members. | |
| Max | Specifies the maximum value of members. | |
| DistinctCount | Specifies the count of distinct measure 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. | |
| 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. | |
| AverageOfChildren | Specifies average of leaf descendants in time. Average does not count an empty value as 0. | |
| FirstChild | Specifies the first child member along Time dimension. | |
| LastChild | Specifies the last child member along Time dimension. | |
| FirstNonEmpty | Specifies the first non empty child member along Time dimension. | |
| LastNonEmpty | Specifies the last non empty child member along Time dimension. |
Notas
Nuevo: 17 de julio de 2006
The following aggregation functions are not supported ByAccount:
None
DistinctCount
Count
Min
Max