Configuring Level Properties

The following table lists and describes the properties of a level in a user-defined hierarchy.

Property Description

Description

Contains the description of the level.

HideMemberIf

Indicates whether and when a member in a level should be hidden from client applications. This property can have the following values:

Never

Members are never hidden. This is the default value.

OnlyChildWithNoName

A member is hidden when the member is the only child of its parent and the member's name is empty.

OnlyChildWithParentName

A member is hidden when the member is the only child of its parent and the member's name is identical to that of its parent.

NoName

A member is hidden when the member's name is empty.

ParentName

A member is hidden when the member's name is identical to that of its parent.

ID

Contains the unique identifier (ID) of the level.

Name

Contains the friendly name of the level. By default, the name of a level is the same as the name of the source attribute.

SourceAttribute

Contains the name of the source attribute on which the level is based.

See Also

Concepts

Configuring User-Defined Hierarchy Properties

Help and Information

Getting SQL Server 2005 Assistance