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 |