Export (0) Print
Expand All

Ascendants

SQL Server 2000

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])
Show:
© 2015 Microsoft