OPENINGPERIOD(ancestor_level,member_expression)
Where:
Given a level and a member, this function returns the first member that is a descendent of the given level and that is at the same level as member.
Example
The following query displays the opening quarter for the year that includes Q3 2003:
SELECT MEASURES.[%COUNT] ON 0, OPENINGPERIOD(birthd.year,birthd.[Q3 2003]) ON 1 FROM patients
Patient Count
Q1 2003 35
In contrast, the following query displays the opening quarter for the decade that includes Q3 2003:
SELECT MEASURES.[%COUNT] ON 0, OPENINGPERIOD(birthd.decade,birthd.[Q3 2003]) ON 1 FROM patients
Patient Count
Q1 2000 33
See Also