User Hierarchy Properties


Applies To: SQL Server 2016 Preview

The following table describes the properties of a user-defined hierarchy.

AllMemberNameContains the caption in the default language for the All member of the hierarchy.
AllowDuplicateNamesDetermines whether duplicate names are allowed in the hierarchy. Values are True and False. Default value is True.
DescriptionContains the description of the hierarchy.
DisplayFolderSpecifies the folder in which to list the hierarchy for users.
IDContains the unique identifier (ID) of the hierarchy.
MemberNamesUniqueDetermines whether member names in the hierarchy must be unique. Values are True and False. Default value is False.
NameContains the name of the hierarchy.

User Hierarchies
Level Properties - user hierarchies

Community Additions