@SIBLINGS

The @SIBLINGS() 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.

@SIBLINGS (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 as follows:
1. left siblings of the member (that is, siblings appearing above the member in the database outline) in descending order,
2. right siblings of the member (that is, 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, Hyperion 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.

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).