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 clipboardThis 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