Returns all siblings of the specified member.
@SIBLINGS (mbrName)
mbrName | Any valid single member name or member combination, or a function that returns a single member or member combination. |
This function returns all siblings of the specified member. This function excludes the specified member.
This function can be used as a parameter of another function, where that parameter is a list of members.
Analytic Services sorts the generated list of members as follows:
Using Sample Basic as an example, if you specify 200-30 for mbrName, Analytic Services returns 200-20, 200-10, 200-40 (in that order). This order is important to consider when you use the @SIBLINGS member set function with certain forecasting and statistical functions.
In the Sample Basic database:
@SIBLINGS (Washington)
Returns Oregon, California, Utah, and Nevada (in that order).
@SIBLINGS(East)
Returns West, South, and Central (in that order).
@ISIBLINGS, which includes the specified member.
@ISISIBLING
@ISSIBLING
@LSIBLINGS
@RSIBLINGS
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |