Returns the first child of the input member's parent.
member.FirstSibling
OR
FirstSibling ( member )
| member | A member specification. |
If member is the top member of a dimension, then member itself is returned.
Year.Firstsibling returns Year.
Qtr3.firstsibling returns Qtr1.
For every month, the following query displays the change in inventory level since the beginning of the quarter.
WITH MEMBER
[Measures].[Inventory Level since beginning of Quarter]
AS
'[Ending Inventory] - ([Opening Inventory], [Year].CurrentMember.FirstSibling)'
SELECT
{[Measures].[Inventory Level since beginning of Quarter]}
ON COLUMNS,
Year.Levels(0).Members ON ROWS
FROM Sample.Basic
This query returns the grid:
| Inventory Level Since Beginning of Quarter | |
|---|---|
| Jan | -971 |
| Feb | -1847 |
| Mar | 1738 |
| Apr | 6740 |
| May | 17002 |
| Jun | 24315 |
| Jul | -871 |
| Aug | -1243 |
| Sep | -1608 |
| Oct | 2000 |
| Nov | 5308 |
| Dec | 4474 |
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |