@RSIBLINGS

The @RSIBLINGS calculation function for Essbase returns the right siblings of the specified member. Right siblings are children that share the same parent as the member and that follow the member in the cube outline.

Syntax

@RSIBLINGS (mbrName)

Parameters

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

Notes

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 right siblings in ascending order. Using Sample Basic as an example, if you specify 200-10 for mbrName, Essbase returns 200-20, 200-30, 200-40 (in that order). This order is important to consider when you use @RSIBLINGS with certain forecasting and statistical functions.

Example

In the Sample Basic cube, the following example returns Connecticut and New Hampshire (in that order). These members appear below Florida in the Sample Basic outline:

@RSIBLINGS(Florida)

The following example returns COGS, because this member appears below Sales in the outline:

@RSIBLINGS(Sales)