OPENINGPERIOD
Description:
This function is used to return the first sibling among the descendants of a specified level, optionally at a specified member.
Syntax:
OpeningPeriod( [ Level_Expression [ , Member_Expression ] ] )
Return Type:
MEMBER
Parameters:
Parameter | Description |
|---|---|
Level_Expression | It is a valid MDX expression that returns a level. |
Member_Expression | It is a valid MDX expression that returns a member. |
Example:
SELECT
[Measures].[Internet Order Quanlity] on 0,
OpeningPeriod([Date].[Calendar].[Calendar Year]) ON 1
FROM [AdventureWorksMF]