Versions Compared

Version Old Version 1 New Version Current
Changes made by

Sarabjeet Kaur

Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Description:

This function is used to return the member that is the last sibling among the descendants of a specified member at a specified level.

Syntax:

ClosingPeriod( [ Level_Expression [ ,Member_Expression ] ] )

Return Type:
MEMBER

Parameters:

Parameter

Description

Level_Expression

It is a valid MDX expression that returns a level.

Member_Expression

It is a valid MDX expression that returns a member.

Example:

Code Block
languagejava
SELECT 
 [Measures].[Internet Unit Price]  on 0,
  ClosingPeriod([Customer].[Geography].[Country], 
 [Customer].[Geography].[Country].&[Australia]) ON 1 
FROM [AdventureWorksMF]