This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
An object of ClassType clsAggregation provides a specific implementation of the Decision Support Objects (DSO) MDStore interface. Each instance of a clsAggregation object represents a unique DSO aggregation. This object provides collections, methods, and properties through the MDStore interface.
Use the following code to list the aggregations contained within a partition:
'Assume an object (dsoServer) of ClassType clsServer exists Dim dsoDB As MDStore Dim dsoCube As MDStore Dim dsoPart As MDStore Dim dsoAgg As MDStore Set dsoDB = dsoServer.MDStores(1) 'Database Set dsoCube = dsoDB.MDStores(1) 'Cube Set dsoPart = dsoCube.MDStores(1) 'Partition 'MDStores collection of a partition object 'contains objects of ClassType clsAggregation Debug.Print " # Aggregations = " & dsoPart.MDStores.Count