FirstSibling

Returns the first child of the input member's parent.

Syntax

FirstSibling ( member [, hierarchy ])

member.FirstSibling [(hierarchy)]

Notes

If member is the top member of a dimension, then member itself is returned.

Example

Example 1

Year.Firstsibling returns Year.

Qtr3.firstsibling returns Qtr1.

Example 2

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:

See Also

• LastSibling
• FirstChild