Returns the first sibling among the descendants of a specified level, optionally at a specified member.
OpeningPeriod ( [ layer [,member ]] )A layer specification. If omitted, the first descendant of member is used. If member is omitted, the first child of the Time dimension is assumed.
Optional. A member specification. If omitted, the first child of the Time dimension is assumed (for example, Qtr1 in Sample Basic).
select
{ (OpeningPeriod(
Calendar.month,
Calendar.[ALL].[2021].Q3
)) } on 10,
{ (measure.[sales amount]) } on SECTIONS
from [Online Store] ;
| sales amount | |
| M7 | 7238 |