1. Calculation and Query Reference for Oracle Essbase
  2. Calculation Functions
  3. Calculation Function List
  4. @SIBLINGS

@SIBLINGS

The @SIBLINGS calculation function for Essbase returns all siblings of the specified member.

Syntax

@SIBLINGS (mbrName)

Parameters

mbrName

Any valid single member name, or a function that returns a single member.

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