<member>.ANCESTORS

This TM1® specific MDX expression returns the ancestors of <member>.

Syntax

For example, assuming the following hierarchy of the Month dimension:

Year
- 1 Quarter
  - Jan
  - Feb
  - Mar

The following expression:

month.month.jan.ANCESTORS

returns the set

{ 1Quarter, Year }.

Note: Where an element has more than one immediate parent, the expression returns the set containing the first parent in the default hierarchy. To see all the ancestors of an element, use ANCESTORSALL instead.