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 |
|---|---|
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 Sales Amount] ON COLUMNS,
ClosingPeriod([Date].[Calendar].[Month], [Date].[Calendar].[Calendar Year].[2012]) ON ROWS
FROM [AdventureWorksMF_ValueBased]