Skip to main content
Previous sectionNext section

ANCESTOR

Returns the ancestor of the given member, within the given level.

Returned Type

This function returns a member.

Syntax and Details

ANCESTOR(member_expression,ancestor_level)

Where:

  • member_expression is an expression that returns a member.

    This expression cannot refer to a measure.

  • ancestor_level is an expression that returns a level. For example:

    [dimension_name].[hierarchy_name].[level_name]
    Copy code to clipboard

    This level must be the parent level of member_expression or an ancestor of that member.

This function returns the ancestor of the given member, within the given level.

Example

The following query displays the year that is the ancestor of March 24, 1943:

SELECT MEASURES.[%COUNT] ON 0, ANCESTOR(birthd.[Mar 24 1943],birthd.year) ON 1 FROM patients
 
                             Patient Count
1943                                     76
Copy code to clipboard

In contrast, the following query displays the period that is the ancestor of March 24, 1943:

SELECT MEASURES.[%COUNT] ON 0, ANCESTOR(birthd.[Mar 24 1943],birthd.period) ON 1 FROM patients
 
                             Patient Count
Mar-1943                                  5
Copy code to clipboard

See Also