Level Object (ADO MD)

Contains a set of members, each of which has the same rank within a hierarchy.

Remarks

With the collections and properties of a Level object, you can do the following:

  • Identify the Level with the Name and UniqueName properties.

  • Return a string to use when displaying the Level with the Caption property.

  • Return a meaningful string that describes the Level with the Description property.

  • Return the Member objects that make up the Level with the Members collection.

  • Return the number of levels from the root of the Level with the Depth property.

  • Use the standard ADO Properties collection to obtain additional information about the Level object.

The Properties collection contains provider-supplied properties. The following table lists properties that might be available. The actual property list may differ depending upon the implementation of the provider. See the documentation for your provider for a more complete list of available properties.

Name Description
CatalogName The name of the catalog to which this cube belongs.
CubeName The name of the cube.
Description A meaningful description of the level.
DimensionUniqueName The unambiguous name of the dimension.
HierarchyUniqueName The unambiguous name of the hierarchy.
LevelCaption A label or caption associated with the level.
LevelCardinality The number of members in the level.
LevelGUID The GUID of the level.
LevelName Name of the level.
LevelNumber The distance between the level and the root of the hierarchy.
LevelType The type of level.
LevelUniqueName The unambiguous name of the level.
SchemaName The name of the schema to which this cube belongs.

This section contains the following topic.

See Also

CubeDef Example (VBScript)
Hierarchy Object (ADO MD)
Levels Collection (ADO MD)
Members Collection (ADO MD)
Properties Collection (ADO)