closingPeriod
Returns the last sibling member among the descendants of a member at "level". This function is typically used with a time dimension.
Syntax
closingPeriod ( level [ , member ] )Example 1
closingPeriod ( [great_outdoors_company].[Years].[Years].[Month] )Result
2006/Dec
Example 2
closingPeriod ( [great_outdoors_company].[Years].[Years].[Year] )Result
2006
Example 3
closingPeriod ( [great_outdoors_company].[Years].[Years].[Month] ,
[2006 Q 4] )Result
2006/Dec