Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

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])
 

See Also

OpeningPeriod