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