Cubing — FirstSibling dot function (MDX)

The FirstSibling dot function returns the first child of the parent of a given member.

Returns: A member.

Syntax


>>---MemberExpression----.--FirstSibling-----------------------><

Parameters

MemberExpression: Specifies the member whose first sibling is to be returned.

Description

If the member has no parent, the function returns the first member at the same level. The first sibling of the All member or the root member is itself.

Example

The following uses the FirstSibling function to return the sales amount for the first sibling of the second quarter in the year 2002, which is quarter 1 of year 2002.

Query

SELECT {[Price Analysis].[Measures].[Sales Amount]} ON AXIS(0),

       {[Price Analysis].[Time].[All Time (Calendar)].[2002].[2].FirstSibling} 

ON AXIS(1)

FROM [Price Analysis]

Result

Time	Sales amount
1	314832.92

Related functions

You can use the Siblings function to return a set of all of the siblings of a member, and the LastSibling function to return only the last sibling of a member.

You can reference other hierarchical relationships by using one of these syntactically similar functions: Children, FirstChild, and LastChild.