Returns the last descendant of a layer, or the last child of the Time dimension.
ClosingPeriod ( [ layer [,member ]] )
layer | Layer specification. |
member |
Optional member specification. If omitted, the last child of the Time dimension is assumed (for example, Qtr4 in Sample Basic).
|
The return value of this function varies depending on the input.
Closingperiod(Year.generations(3), Qtr3)
returns Sep
. Closingperiod(Year.generations(3), Sep)
returns Sep
.Closingperiod(Year.generations(3))
returns Dec
.The following query
WITH MEMBER [Measures].[Starting Inventory] AS ' IIF ( IsLeaf (Year.CurrentMember), [Measures].[Opening Inventory], ([Measures].[Opening Inventory], OpeningPeriod ( [Year].Levels(0), [Year].CurrentMember ) ) )' MEMBER [Measures].[Closing Inventory] AS ' IIF ( Isleaf(Year.CurrentMember), [Measures].[Ending Inventory], ([Measures].[Closing Inventory], ClosingPeriod ( [Year].Levels(0), [Year].CurrentMember ) ) )' SELECT CrossJoin ( { [100-10] }, { [Measures].[Starting Inventory], [Measures].[Closing Inventory] } ) ON COLUMNS, Hierarchize ( [Year].Members , POST) ON ROWS FROM Sample.Basic
returns the grid:
100-10 | 100-10 | |
---|---|---|
Starting Inventory | Closing Inventory | |
Jan | 14587 | 14039 |
Feb | 14039 | 13566 |
Mar | 13566 | 13660 |
Qtr1 | 14587 | 13660 |
Apr | 13660 | 14172 |
May | 14172 | 15127 |
Jun | 15127 | 15580 |
Qtr2 | 13660 | 15580 |
Jul | 15580 | 14819 |
Aug | 14819 | 14055 |
Sep | 14055 | 13424 |
Qtr3 | 15580 | 13424 |
Oct | 13424 | 13323 |
Nov | 13323 | 13460 |
Dec | 13460 | 12915 |
Qtr4 | 13424 | 12915 |
Year | 14587 | 12915 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |