Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

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]

    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

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

See Also

Feedback