Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Ascendants (MDX)

Returns the set of the ascendants of a specified member, including the member itself.



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

The Ascendants function returns all of the ancestors of a member from the member itself up to the top of the member’s hierarchy; more specifically, it performs a post-order traversal of the hierarchy for the specified member, and then returns all ascendant members related to the member, including itself, in a set. This is in contrast to the Ancestor function, which returns a specific ascendant member, or ancestor, at a specific level.

The following example returns the count of reseller orders for the [Sales Territory].[Northwest] member and all the ascendants of that member from the Adventure Works cube. The Ascendants function constructs the set that includes the [Sales Territory].[Northwest] member and its ascendants for the ROWS axis.

   Measures.[Reseller Order Count] ON COLUMNS,
         [Sales Territory].[Northwest]
   ) ON ROWS
   [Adventure Works]
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft