ClosingPeriod (MDX)

Returns the last member of members descendants at the specified level.

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

Query

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

Result

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

Assertion : MDX Equals

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

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

function behaves as ClosingPeriod([Time].[Calendar].[Month],[Time].[Calendar].[Year].defaultmember)

Query

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

Result

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

Assertion : MDX Equals

ClosingPeriod([Time].[Calendar].[Month], [Time].[Calendar].defaultmember)

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

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

Query

WITH
    member ClosingName as ClosingPeriod().NAME
SELECT
    ClosingName on 0, [Time].[Calendar].[Year].members on 1
FROM
    Sales

Result

Assertion : MDX Equals

WITH
    member ClosingName as ClosingPeriod([Time].[Calendar].CurrentMember.firstChild.level,[Time].[Calendar].CurrentMember).NAME
SELECT
    ClosingName on 0, [Time].[Calendar].[Year].members on 1
FROM
    Sales

ClosingPeriod can be applied not only for Time data. In general it returns last sibling among descendants of the specified member for the specified level.

Query

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

Result

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

Assertion : MDX Equals

[Geography].[Geo].[Spain].LastChild

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

Query

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

Result

NULL

Query

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

Result

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

Query

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

Result

NULL

Query

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

Result

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