A cube in Decision Support Objects (DSO) contains these collections: Dimensions and their subordinate Levels collections, Measures, Datasources, Roles, Commands, CustomProperties, and an MDStores collection containing one or more partitions. Cubes contain collections of members as shown in the following figure.
The Dimensions collection in a cube contains the definitions of the dimensions used by the cube. Private dimensions can be defined in the Dimensions collection, but can be modified only in the cube’s parent database Dimensions collection. Shared dimensions defined in the cube’s parent database can also be used in the cube and can be added to the cube’s Dimensions collection. Shared dimensions assigned to a cube refer to the dimension definitions in the parent database and cannot be modified within the context of the cube.
The Measures collection in a cube contains the measures associated with the cube.
The Datasources collection in a cube contains the definition of the default data source used for the cube’s partitions and dimensions. A cube can use only a single data source.
The Roles collection in a cube contains access rights to the cube definition. Only roles that are contained in a cube’s parent database can be assigned to the cube.
The Commands collection in a cube contains MDX expressions that are used to specify the data to be used in the cube.
The CustomProperties collection contains Property objects that you can use to define additional properties for your own purposes.
The MDStores collection in a cube contains one or more partitions of a cube.
| Databases | Partitions |