FirstSibling

Syntax

Member_Expression.FirstSibling

Input Parameters

Member_Expression
A valid Multidimensional Expression (MDX) that returns a member.

Return Value

Returns the first child of the parent of a member, otherwise known as the member's first sibling. The ordering is determined by the attribute's OrderBy configuration.

Example

Return the Sales Amount for the date dimension currentMember's first sibling.

([DateCustom].[Retail445].CurrentMember.FirstSibling, [Measures].[Internet Sales Amount Local])