Export (0) Print
Expand All

OpeningPeriod

SQL Server 2000

OpeningPeriod

Returns the first sibling among the descendants of a specified level, optionally at a specified member.

Syntax

OpeningPeriod([«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 TopCount(Descendants(«Member», «Level»), 1).

The ClosingPeriod function is similar, except that it returns the last sibling instead of the first sibling.

Example

The following example returns [1991].January:

OpeningPeriod(Month, [1991])
Show:
© 2014 Microsoft