Return to: Calculated Member Builder Function List
Returns the first sibling among the descendants of a member at a level.
OpeningPeriod([«Level»[, «Member»]])
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 TopCount(Descendants(«Member», «Level»), 1).
The function ClosingPeriod is similar, the only difference being that it returns the last sibling instead of the first sibling.
OpeningPeriod(Month, [1991])
returns [1991].January.