An object of ClassType clsPartitionLevel provides a specific implementation of the Decision Support Objects (DSO) Level interface. It is used to maintain the level objects contained within a partition object.
A clsPartitionLevel object provides collections and properties through the Level interface. There are no methods associated with an object of ClassType clsPartitionLevel.
Levels describe the dimension hierarchy from the highest (most aggregated) level to the lowest (most detailed) level of data. The All level of a dimension is the top level of a dimension that includes all the members of all the levels.
The following table shows an example of level positions of a time dimension in which the most detailed (daily) values are included in the next level (monthly), which are in turn included in the next level (quarterly), and so on.
| Level | Ordinal Position |
|---|---|
| All | 1 |
| Yearly | 2 |
| Quarterly | 3 |
| Monthly | 4 |
| Daily | 5 |
The number of members in any level must always be greater than, or equal to, the number of members in the parent level.
A clsPartitionLevel object plays a unique role in the DSO object model in that its levels actually contain data slices. For more information, see SliceValue.
Use the following code to create a clsPartitionLevel object called myPartLevel:
' Assume an object (dsoPart) of ClassType clsPartition exists
Dim dsoLev As DSO.Level
Set dsoLev = dsoPart.Levels.AddNew("Brand Name")
| About Decision Support Objects | Using Decision Support Objects |