Jaa


OrdinalPosition (Level Interface)

Note

  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

The OrdinalPosition property of the Level interface contains the ordinal position of the level in the Levels collection.

Applies To:clsAggregationLevel, clsCubeLevel, clsDatabaseLevel, clsPartitionLevel

Data Type

Integer

Access

Read-only

Remarks

The OrdinalPosition property for a level determines the relative position of the level in the dimension hierarchy: A value of 1 defines the most aggregated level, and the maximum value defines the most detailed level. Decision Support Objects (DSO) sets the value of this property when you add the level to a dimension.

The following table shows an example of relative ordinal positions.

Level Ordinal position

All

1

Yearly

2

Quarterly

3

Weekly

4

Daily

5

Example

Use the following code to return the ordinal position of a level object:

' Assume an object (dsoLev) of ClassType clsLevel exists
If dsoLev.OrdinalPosition = 1 Then
  'Code to handle top level
Else
  'Code to handle remaining levels
End If

See Also

Reference

Level Interface

Help and Information

Getting SQL Server 2005 Assistance