Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

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])