Artikel
03/30/2012

AggregateFunction (Measure Interface)

Hinweis
Diese Funktion wird in der nächsten Version von Microsoft SQL Server entfernt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie so bald wie möglich das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

The AggregateFunction property of the Measure interface contains an enumeration constant that corresponds to the type of aggregate function used to generate the precalculated value of the measure.

Applies To:clsAggregationMeasure, clsCubeMeasure, clsPartitionMeasure

Data Type

AggregatesTypes

Access

Access depends on the value of the ClassType property of the object.

Class type	Access
clsAggregationMeasure	R
clsCubeMeasure	R/W*
clsPartitionMeasure	R

* Read-only for virtual cube measures and measures in fully-created linked cubes.

Hinweise

To create more sophisticated measures (for example, ratios or statistical functions), use the command object to create a calculated member. For more information, see clsCubeCommand and clsDatabaseCommand.

Hinweis
Because the DISTINCT COUNT aggregation function does not support custom aggregations, the use of this aggregation function in combination with the CustomRollupExression and CustomRollupColumn properties is not supported. If a cube uses the DISTINCT COUNT aggregation function and any of the dimensions in that cube use either the CustomRollupExpression property or the CustomRollupColumn property, including data mining dimensions, the cube is invalid. Processing such a cube raises a validation error.

Because the DISTINCT COUNT aggregation function does not support custom aggregations, the use of this aggregation function in combination with the CustomRollupExression and CustomRollupColumn properties is not supported. If a cube uses the DISTINCT COUNT aggregation function and any of the dimensions in that cube use either the CustomRollupExpression property or the CustomRollupColumn property, including data mining dimensions, the cube is invalid. Processing such a cube raises a validation error.

Examples

Reading the AggregateFunction Property of a Measure Object

Use the following code to read the value of the AggregateFunction property of a measure object:

'Assume an object (dsoAggMea) of ClassType clsAggregationMeasure exists
Dim AggType As DSO.AggregatesTypes
AggType = dsoAggMea.AggregateFunction
Select Case AggType
    Case aggSum
       ' Insert code for aggregation summation.
    Case aggCount
       ' Insert code for aggregation counts.
    Case aggMin
       ' Insert code for aggregation min.
    Case aggMax
       ' Insert code for aggregation max.
    Case aggDistinctCount
       ' Insert for aggregation distinct counts.
End Select

Siehe auch

Verweis

AggregatesTypes

Measure Interface

CustomRollupColumn (Level Interface)

CustomRollupExpression (Level Interface)

Freigeben über