A database in the Decision Support Objects (DSO) contains these collections: Dimensions and their subordinate Levels collections, Datasources, Roles, Commands, and CustomProperties. Databases also contain an MDStores collection of cubes and virtual cubes. Databases are contained in an MDStores collection under the server object. Objects in this collection are identified by their ClassType property, which has a value of clsDatabase. These database objects contain collections as shown in the following figure.
The Dimensions collection in a database contains shared and private dimensions and their subordinate levels. Shared dimensions can be used in multiple cubes; private dimensions can be used only in the cube to which they apply. Both shared and private dimensions can be modified only in the Dimensions collection of a Database object.
The Datasources collection in a database contains the data sources applicable to all subordinate objects in the database.
The Roles collection in a database contains Role objects that specify access rights for authorized users. Roles can be applied to elements such as databases and cubes.
The Commands collection in a database is reserved for future use.
The CustomProperties collection contains Property objects that you can use to define additional properties for your own purposes.
The MDStores collection in a database can contain cubes and virtual cubes.
| Cubes | Virtual cubes |