Essbase @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

  • @ISIBLINGS
  • @ISISIBLING
  • @ISSIBLING
  • @LSIBLINGS
  • @RSIBLINGS
  • @SHIFTSIBLING
  • @NEXTSIBLING
  • @PREVSIBLING