| title | description | ms.date | ms.service | ms.custom | ms.topic | ms.author | ms.reviewer | author |
|---|---|---|---|---|---|---|---|---|
Level Properties - user hierarchies | Microsoft Docs |
Learn about the properties of a level in a user-defined hierarchy. |
05/02/2018 |
analysis-services |
olap |
conceptual |
kfollis |
kfollis |
kfollis |
[!INCLUDEappliesto-sqlas] 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. |