Collections, MDStore Interface
Note
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.
The MDStore interface supports the following collections.
| Collection | Description |
|---|---|
The collection of user-defined commands or sequence of commands |
|
The collection of user-defined properties |
|
The collection of objects specifying a data provider |
|
The collection that holds the dimension definitions for an object |
|
The collection that holds MDStore objects |
|
The collection that holds the measures |
|
The collection of data mining models contained within a database |
|
The collection that holds the user role definitions for a database |
The following table shows the class types of the objects that each collection can contain.
| Collection | Class type of contained objects |
|---|---|
Commands |
|
CustomProperties |
|
DataSources |
|
Dimensions |
clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension |
MDStores |
|
Measures |
|
MiningModels |
|
Roles |
Access Cross-Reference
The following table shows whether a collection is read/write (R/W), read-only (R), or not applicable (n/a) for each of the MDStore objects.
| Collection | clsDatabase | clsCube | clsPartition | clsAggregation |
|---|---|---|---|---|
R/W |
R/W |
n/a |
n/a |
|
R/W |
R/W |
R/W |
R/W |
|
R/W |
R/W* |
R/W |
n/a |
|
R/W |
R/W |
R |
R |
|
R/W |
R/W |
R/W |
R |
|
n/a |
R/W |
R |
R |
|
R/W |
n/a |
n/a |
n/a |
|
R/W |
R/W |
n/a |
n/a |
*This property is not applicable (n/a) for virtual cubes (that is, those of SubClassType sbclsVirtual).