Returns the siblings of the input member.
Siblings ( member )
OR
member.Siblings
| member | The member for which to return siblings. |
Children(member.parent).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 |