OpeningPeriod (MDX)

Returns the first member of the descendants of the specified member at the specified level.

In our example the first month of [2010] year.

Query

OpeningPeriod([Time].[Calendar].[Month],[Time].[Calendar].[Year].[2010])

Result

{ 
  [Time].[Calendar].[Month].[Jan 2010]
}

Assertion : MDX Equals

Head(Descendants([Time].[Calendar].[Year].[2010], [Time].[Calendar].[Month]), 1)

Returns the first member of the default member of level's hierarchy at the specified level.

The function behaves as OpeningPeriod([Time].[Calendar].[Month],[Time].[Calendar].[Year].defaultMember)

Query

OpeningPeriod([Time].[Calendar].[Month])

Result

{ 
  [Time].[Calendar].[Month].[Jan 2010]
}

Assertion : MDX Equals

Head(Descendants([Time].[Calendar].[Year].[2010], [Time].[Calendar].[Month]), 1)

If no parameter is specified:
- the member is the current member of the time dimension.
- the level is the level of the former member + 1

The function behaves as OpeningPeriod([Time].[Calendar].DefaultMember.level,[Time].[Calendar].DefaultMember)

Query

WITH
    MEMBER OpeningName as OpeningPeriod().NAME
SELECT
    OpeningName on 0, [Time].[Calendar].[Year].members on 1
FROM
    Sales

Result

Assertion : MDX Equals

WITH
    MEMBER OpeningName as OpeningPeriod([Time].[Calendar].CurrentMember.firstChild.level,[Time].[Calendar].CurrentMember).NAME
SELECT
    OpeningName on 0, [Time].[Calendar].[Year].members on 1
FROM
    Sales

OpeningPeriod can be applied to non-time dimensions. It returns the last sibling among the descendants of the specified member for the specified level.

Query

OpeningPeriod([Geography].[Geo].[City],[Geography].[Geo].[Spain])

Result

{ 
  [Geography].[Geo].[City].[Barcelona]
}

Assertion : MDX Equals

[Geography].[Geo].[Spain].FirstChild

Returns NULL if the level is of lower depth than the member.

Query

OpeningPeriod( [Geography].[Geo].[Continent], [Geography].[Geo].[Spain] )

Result

NULL

The level cannot be null.

Query

OpeningPeriod(NULL,[Time].[Calendar].[Year].[2011])

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : OpeningPeriod() : argument (0) type mismatch: expected:'level', got:'NULL'

NULL has no opening period.

Query

OpeningPeriod([Time].[Calendar].[Month],NULL)

Result

NULL

Applied to different hierarchies generates an error.

Query

OpeningPeriod([Time].[Calendar].[Month],[Geography].[Geo].[Paris])

Result

Error Code    : OLAP_DIFFERENT_HIERARCHIES
Error Message : unexpected hierarchy (expected:'[Time].[Calendar]') (actual:'[Geography].[Geo]')