Article
05/23/2011

LevelType (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 LevelType property of the Level interface returns an enumeration constant that identifies the specific type of level. It tells client applications that encounter this level what kind of content the level contains.

Applies To:clsAggregationLevel, clsCubeLevel, clsDatabaseLevel, clsPartitionLevel

Data Type

LevelTypes

Access

Access depends on the value of the ClassType property of the object.

Class type	Access
clsDatabaseLevel	R/W*
clsCubeLevel	R
clsPartitionLevel	R
clsAggregationLevel	R

* Read-only for virtual cube levels and for levels with a SubClassType of sbclsParentChild or sbclsMining.

Remarks

The LevelType property can be set to one of the constants enumerated by the LevelTypes enumeration. If the level is part of a relational OLAP (ROLAP) dimension, the first level must be unique and must always be of type levAll. Time levels have their LevelType property set to one of the time level constants, such as levTimeYears or levTimeMonths. Time levels must be created according to the time hierarchy: For example, a level of type levTimeYears must be above a level of type levTimeMonths.

Examples

A. Setting Level Type

Use the following code to set the level type of a level object to days:

LevelObject.LevelType = levTimeDays

B. Setting and Determining Level Type

Use the following code to return the level type of a level object and to determine which level type has been returned:

'Assume an object (dsoLevel) of ClassType clsDatabaseLevel exists
Dim objType As DSO.LevelTypes
objType = dsoLevel.LevelType
Select Case objType
  Case levRegular
    ' Commands for levRegular, a level not time-related
  Case levAll
    ' Commands for levAll, the topmost level
  Case levTimeQuarters
    ' Commands for levTimeQuarters, a calendar quarter level
..Case levCompany
    ' Commands for levCompany, a company information level
..Case levGeoCity
    ' Commands for levGeoCity, a city name level
  Case levProduct
    ' Commands for levProduct, an individual products level
  Case Else
    ' Commands for other LevelTypes
End Select

Share via