Returns all siblings of the specified member.
|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.
Essbase sorts the generated list of members as
- 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
In the Sample Basic database:
Returns Oregon, California,
Utah, and Nevada (in that order).
Returns West, South, and
Central (in that order).