RootMemberIf Element (ASSL)
Applies To: SQL Server 2016 Preview
Determines how the root member or members of a parent attribute are identified.
|Data type and length||String (enumeration)|
|Cardinality||0-1: Optional element that can occur once and only once|
The value of the RootMemberIf element is used only by parent attributes (in other words, the value of the Usage element of the DimensionAttribute parent element is set to Parent) to determine the root (topmost) members of a parent-child hierarchy.
The value of this element is limited to one of the strings listed in the following table.
|ParentIsBlankSelfOrMissing||Only members that meet one or more of the conditions described for ParentIsBlank, ParentIsSelf, or ParentIsMissing are treated as root members.|
|ParentIsBlank||Only members with a null, a zero, or an empty string in the key columns represented by the KeyColumns collection of DimensionAttribute are treated as root members.|
|ParentIsSelf||Only members with themselves as parents are treated as root members.|
|ParentIsMissing||Only members with parents that cannot be found are treated as root members.|
The enumeration that corresponds to the allowed values for RootMemberIf in the Analysis Management Objects (AMO) object model is RootIfValue.