Siblings

Returns the siblings of the input member.

Syntax

Siblings ( member )

OR

member.Siblings

member The member for which to return siblings.

Notes

Example

Siblings(Year) returns {Year}.

The following query

SELECT
CrossJoin (
         Union (
            Siblings ([Old Fashioned]),
            {([Root Beer]), ([Cream Soda])}
         ),
         {(Budget), ([Variance])}
      )
ON COLUMNS
from Sample.Basic

returns the grid:

Old Fashioned Diet Root Beer Sasparilla Birch Beer Root Beer Cream Soda
Budget Variance Budget Variance Budget Variance Budget Variance Budget Variance Budget Variance
11640 -4439 14730 -2705 5050 -414 4530 -438 35950 -7996 29360 -3561

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com