Skip to main content
Version: I2024.2.x

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])