The AggregateFunction property of the Measure interface contains a value that corresponds to the type of aggregation function used to calculate the aggregated value of the measure.
| clsAggregationMeasure | clsPartitionMeasure |
| clsCubeMeasure |
AggregatesTypes (an enumeration)
AggregateType is set to one of the following:
To create more sophisticated measures (for example, ratios or statistical functions), use the command objects. For more information, see clsCubeCommand and clsDatabaseCommand.
The access type depends on the measure object class.
| Class | Access |
|---|---|
| clsCubeMeasure | R/W |
| clsCubeMeasure (virtual) | R |
| clsPartitionMeasure | R |
| clsAggregationMeasure | R |
Use the following code to specify an aggregation COUNT function for a cube measure object:
'Assume an object (dsoAggMea) of ClassType clsAggregationMeasure exists
dsoAggMea.AggregateFunction = aggCount
...
Dim AggType As AggregatesTypes
AggType = dsoAggMea.AggregateFunction
Select Case AggType
Case aggSum
'commands for aggregation summation
Case aggCount
'commands for aggregation counts
Case aggMin
'commands for aggregation min
Case aggMax
'commands for aggregation max
End Select
| About Decision Support Objects | Using Decision Support Objects |
| AggregatesTypes |