Essbase @ILSIBLINGS

Returns the specified member and its left siblings.

Syntax

@ILSIBLINGS (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 the specified member and all of the left siblings
of the member. Left siblings are children that share the same parent as the
member and that precede the member in the database outline.

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 members starting
with the left siblings of the member (that is, siblings appearing above 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-10, 200-20, 200-30 (in that order). This
order is important to consider when you use the @ILSIBLINGS member set function
with certain forecasting and statistical functions.

Example

In the Sample Basic database:

@ILSIBLINGS(Florida)

Returns New York, Massachusetts,
and Florida (in that order). New York and Massachusetts appear above Florida
in the Sample Basic outline.

@ILSIBLINGS(Qtr3)

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

See Also

  • @LSIBLINGS