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 lengthString (enumeration)
Default valueParentIsBlankSelfOrMissing
Cardinality0-1: Optional element that can occur once and only once
Parent elementDimensionAttribute
Child elementsNone

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.

ParentIsBlankSelfOrMissingOnly members that meet one or more of the conditions described for ParentIsBlank, ParentIsSelf, or ParentIsMissing are treated as root members.
ParentIsBlankOnly 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.
ParentIsSelfOnly members with themselves as parents are treated as root members.
ParentIsMissingOnly 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.

Properties (ASSL)

Community Additions