Analysis Services
Ascendants
Returns the set of the ascendants of a specified member.
Syntax
Ascendants(«Member»)
Remarks
Unlike the Ancestor function, which returns a specific ascendant member, or ancestor, at a specific level, the Ascendants function performs a post-order traversal of the member hierarchy, returning all of the ascendant members related to the given member, including itself, in a set.
Example
The following example returns the set { LA, California, USA, [All Locations] }:
Ascendants([Los Angeles])