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 |