Returns all siblings of the specified member.
Syntax
@SIBLINGS (mbrName)
Parameter | Description |
---|---|
mbrName | Any valid single member name or member combination, or a function that returns a single member or member combination. |
Notes
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.
Essbase sorts the generated list of members as follows:
Left siblings of the member (siblings appearing above the member in the database outline) in descending order
Right siblings of the member (siblings appearing below the member in the database outline) in ascending order
Using Sample Basic as an example, if you specify 200-30 for mbrName, Essbase 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.
Example
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).
See Also