CLOSINGPERIOD

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

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:

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

Kyvos 2025.2

CLOSINGPERIOD

Analytics

Related content