@SIBLINGS

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:

  1. Left siblings of the member (siblings appearing above the member in the database outline) in descending order

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