Essbase @NEXTSIBLING

Returns the next sibling (the sibling to the immediate right) of the
specified member. This function excludes the specified member. If the specified
member is the last sibling, Essbase returns an empty string.

You can use the @NEXTSIBLING function as a parameter of another function,
where the function requires a list of members.

Syntax

@NEXTSIBLING (mbrName)
Parameter Description
mbrName Valid member name or member-name combination or a function that returns
one member or member combination.

Example

All examples are from the Sample.Basic database.

@NEXTSIBLING(“100–20”)

Returns 100-30 (the next
sibling of 100-20).

@NEXTSIBLING(“200”)

Returns 300 (the next sibling
of 200). The @NEXTSIBLING and the @SHIFTSIBLING (“200”,1) function
return the same results.

@MEMBER(@NEXTSIBLING(“100-20”))

Returns 100-30 (the next sibling of 100-20).

See Also

  • @PREVSIBLING
  • @SHIFTSIBLING