An object of ClassType clsPartition serves as a multidimensional data store, providing a specific implementation of the Decision Support Objects (DSO) MDStore interface. This object provides collections, methods, and properties through the MDStore interface.
Partitions are common to large data warehouses where massive amounts of data must be managed efficiently. They enable you to segment your data in various storage modes and on various servers. You must create a separate partition for each physical partition (that is, each data source) the cube accesses.
Every cube has a default partition. Additional partitions can be defined to store portions of a cube’s data in different locations and with different aggregations. Each partition can have its own data source or inherit the parent cube’s default data source.
For more information about the object model hierarchy, see About Decision Support Objects and Interfaces.
Use the following code to create a clsPartition object:
'Assume an object (dsoCube) of ClassType clsCube exists
Dim dsoPartition As DSO.MDStore
Set dsoPartition = dsoCube.MDStores.AddNew("MyPartition")
| Using Decision Support Objects | MDStore Interface |