fbpx

ClosingPeriod (MDX)

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

Parameters

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

Return

member

Description

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

Examples

Special Examples (errors, null, ...)

XMLA Properties

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