The @ISIBLINGS() function returns the specified member and all siblings of that member. This member set function can be used as a parameter of another function, where that parameter is a list of members.
@ISIBLINGS(mbrName)
| mbrName | Any valid single member name or member combination, or a function that returns a single member or member combination. |
Hyperion Essbase sorts the generated list of members in ascending order.
Using Sample Basic as an example, if you specify 200-30 for mbrName, Hyperion Essbase returns 200-10, 200-20, 200-30, 200-40 (in that order). This order is important to consider when you use the @ISIBLINGS member set function with certain forecasting and statistical functions.
In the Sample Basic database:
@ISIBLINGS(California)returns California, Oregon, Washington, Utah, and Nevada (in that order), because these members are siblings of California.
@ISIBLINGS(Qtr2)returns Qtr1, Qtr2, Qtr3, and Qtr4 (in that order), because these members are siblings of Qtr2.
@SIBLINGS, which excludes the specified member.
Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.
