The OrdinalPosition property of the Dimension interface contains the ordinal position of the dimension object within its parent object’s Dimensions collection.
Note The ordinal position is zero for all dimension objects in the collection of dimensions for a database. The position of a dimension within the collection is significant only when it is used in a cube, partition, or aggregation.
The OrdinalPosition property for dimensions is different from the OrdinalPosition property for levels. Dimensions are ordered by the time sequence in which you add them to their parent object. The ordinal position of levels, on the other hand, determines the hierarchy of the dimension.
clsAggregationDimension | clsDatabaseDimension |
clsCubeDimension | clsPartitionDimension |
Integer
Read-only
'Assume an object (dsoDim) of ClassType clsDimension exits
If dsoDim.OrdinalPosition = 1 Then
'Code to handle first dimension
Else
'Code to handle other dimensions
End If
About Decision Support Objects | Using Decision Support Objects |
Properties Cross-Reference |