Analysis Services
ClosingPeriod
Returns the last sibling among the descendants of a member at a specified level.
Syntax
ClosingPeriod([«Level»[, «Member»]])
Remarks
The dimension that contains «Level» is used if «Level» is specified; otherwise, the Time dimension is used. If no «Level» is specified, the level below that of «Member» is used. If no «Level» or «Member» is specified, the default is Time.CurrentMember.
This function is equivalent to BottomCount(Descendants(«Member», «Level»), 1).
The OpeningPeriod function is similar, except that it returns the first sibling instead of the last sibling.
Example
The following example returns [1991].December:
ClosingPeriod(Month, [1991])