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

Community Additions