@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.

This function returns the next sibling as a string. To pass the @NEXTSIBLING function as a parameter of another function, where the function requires a list of members, you must wrap the output of @NEXTSIBLING with the @MEMBER function.

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).

@CHILDREN(@MEMBER(@NEXTSIBLING("East")))

Returns all children of West.