Learning
Community
Open Exchange
Global Masters
InterSystems IRIS Data Platform 2019.4 / Analytics / InterSystems MDX Reference / MDX Functions / OPENINGPERIOD
Previous section   Next section

OPENINGPERIOD

Returns the first descendent member of the given level, at the same level as the given member. This function is intended primarily for use with time levels.

Returned Type

This function returns a member.

Syntax and Details

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

Previous section   Next section