ClosingPeriod

Return to: Calculated Member Builder Function List

Returns the last sibling among the descendants of a member at a level.

Syntax

ClosingPeriod([«Level»[, «Member»]])

Remarks

The dimension containing «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 function OpeningPeriod is similar, the only difference being that it returns the first sibling instead of the last sibling.

Example

ClosingPeriod(Month, [1991])

returns [1991].December.

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.