@ISIBLINGS

The @ISIBLINGS calculation function for Essbase returns a member and all its siblings. This function can be used as a parameter of another function, where that parameter is a list of members.

Syntax

@ISIBLINGS (mbrName)

Parameters

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

Notes

Essbase sorts the generated list of members in ascending order. Using Sample Basic as an example, if you specify 200-30 for mbrName, Essbase returns 200-10, 200-20, 200-30, 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:

@ISIBLINGS(California)

returns California, Oregon, Washington, Utah, and Nevada (in that order), because these members are siblings of California.

@ISIBLINGS(Qtr2)

returns Qtr1, Qtr2, Qtr3, and Qtr4 (in that order), because these members are siblings of Qtr2.