fbpx

OpeningPeriod (MDX)

Returns the first sibling for the specified level. Optionally, a 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 first sibling from descendants of the specified member at the specified level.

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

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

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

The function is primary intended to be used with time dimensions but is not limited to time dimensions.

See Also

ClosingPeriod

Examples

Special Examples (errors, null, ...)

XMLA Properties

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