ClosingPeriod (MDX)

Returns the last sibling for the specified level. Optionally member can be specified for the search.


Name Type Cardinality Default value
  level-expression  zero-one   
  member-expression  zero-one   




This function finds the last sibling from descendants of the specified member at the specified level.

1) If no parameters were specified, function will use implicitly time dimension current member and its next level.

2) If only level was specified, function will use default member implicitly.

The same result can be achieved with Tail(Descendants(Member_Expression, Level_Expression), 1) MDX statement.

Function is primary intended to be used with Time dimensions (however it's not a restriction).

See Also

OpeningPeriod FirstChild LastSibling


Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.