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