openingPeriod

Returns the first sibling member among the descendants of a member at "level". This function is typically used with a time dimension.

Syntax

openingPeriod ( level [ , member ] )

Example 1

openingPeriod ( [great_outdoors_company].[Years].[Years].[Month] )

Result

2004/Jan

Example 2

openingPeriod ( [great_outdoors_company].[Years].[Years].[Year] )

Result

2004

Example 3

openingPeriod ( [great_outdoors_company].[Years].[Years].[Month] ,
 [2006 Q 4] )

Result

2006/Oct