@LSIBLINGS

The @LSIBLINGS calculation function for Essbase returns the left siblings of the specified member.

Syntax

@LSIBLINGS(mbrName)

Parameters

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

Notes

This function returns the left siblings of the specified member. Left siblings are children that share the same parent as the member and that precede the member in the database outline. This function excludes the specified member.

This member set function can be used as a parameter of another function, where that parameter is a list of members.

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

@LSIBLINGS(Qtr4)

Returns Qtr3, Qtr2, and Qtr1 (in that order). These members appear above Qtr4 in the Sample Basic outline.

@LSIBLINGS(Utah)

Returns Washington, Oregon, and California (in that order). These members appear above Utah in the Sample Basic outline.