An object of ClassType clsPartitionMeasure provides a specific implementation of the Decision Support Objects (DSO) Measure interface. This object is used to maintain the measure objects contained within a partition object.
A clsPartitionMeasure object provides collections and properties through the Measure interface. There are no methods associated with an object of ClassType clsPartitionMeasure.
Measures are the quantitative, numerical columns from the fact table of a cube. When a cube is processed, the measures are aggregated across the dimensions in the cube. For example, a database contains the following tables:
The following diagram illustrates the relationships of these tables.
The Sales_Facts table is the cube fact table and the related tables are the cube dimensions. The Sales_Quantity, Unit_Price, and Unit_Cost fields are measures that can be aggregated across dimensions such as Store, Customer, or Product.
Use the following code to create an object of ClassType clsPartitionMeasure.
'Assume an object (dsoPartition) of ClassType clsPartition exists
Dim dsoPartMeasure As DSO.Measure
Set dsoPartMeasure = dsoPartition.Measures.AddNew("MyPartMeasure")
| About Decision Support Objects | Using Decision Support Objects |