Siblings

Returns a naturally ordered set that contains the siblings of a specified member, including the member itself. For use with an aggregate function, i.e. SUM( MemberExpression, Measure).

Syntax

Member_Expression.Siblings

Input Parameters

Member_Expression (Required): A valid Multidimensional Expressions (MDX) expression that returns a member.

Return Value

Returns a Set of Members

Example

Compute the Product Category's fraction of sales relative to it's sibling categories.

[Measures].[Internet Sales Amount Local] / SUM([Product].[Product Categories].CurrentMember.Siblings, [Measures].[Internet Sales Amount Local])