Export (0) Print
Expand All
Expand Minimize

Root (MDX)

Returns a tuple that consists of the All members from each attribute hierarchy within the current scope in a cube, dimension, or tuple. For more information about Scope, see SCOPE Statement (MDX).

NoteNote

If an attribute hierarchy does not have an All member, the tuple contains the default member for that hierarchy.


Cube syntax
Root ()
Dimension syntax
Root( Dimension_Name )
Tuple syntax
Root( Tuple_Expression )

Dimension_Name

A valid string expression specifying a dimension name.

Tuple_Expression

A valid Multidimensional Expressions (MDX) expression that returns a tuple.

If neither a dimension name nor a tuple expression is specified, the Root function returns a tuple that contains the All member (or the default member if the All member does not exist) from each attribute hierarchy in the cube. The order of members in the tuple is based on the sequence in which the attribute hierarchies are defined within the cube.

If a dimension name is specified, the Root function returns a tuple that contains the All member (or the default member if the All member does not exist) from each attribute hierarchy in the specified dimension based on the context of the current member. The order of members in the tuple is based on the sequence in which the attribute hierarchies are defined within the dimension.

NoteNote

If a hierarchy name is specified, the Tuple function will pick the dimension name from the hierarchy name specified.

If a tuple expression is specified, the Root function returns a tuple that contains the intersection of the specified tuple and the All members of all other dimension attributes not explicitly included in the specified tuple. The specified tuple must reference only one dimension, or an error occurs.

Examples

The following example returns the tuple containing the All member (or the default if the All member does not exist) from each hierarchy in the Adventure Works cube.

SELECT Root()ON 0
FROM [Adventure Works]

The following example returns the tuple containing the All member (or the default if the All member does not exist) from each hierarchy in the Date dimension in the Adventure Works cube and the value for the specified member of Measures dimension that intersects with these default members.

SELECT Root([Date]) ON 0
FROM [Adventure Works]
WHERE [Measures].[Order Count]

The following example returns the tuple containing specified tuple member (July 1, 2001, along with the All member (or the default if the All member does not exist) from each non-specified hierarchy in the Date dimension Adventure Works cube and the value for the specified member of Measures dimension that intersects with these members.

SELECT Root([Date].[July 1, 2001]) ON 0
FROM [Adventure Works]
WHERE [Measures].[Order Count]
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft