User Hierarchies - Level Properties

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium

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