@NEXTSIBLING

The @NEXTSIBLING calculation function for Essbase returns the next sibling (the sibling to the immediate right) of the specified member, as a string.

To pass this function call as a parameter to another function requiring a list of members, you must wrap it within a @MEMBER function call.

Syntax

@NEXTSIBLING (mbrName)

Parameters

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

Notes

You must wrap this function within the @MEMBER function if you are calling it inside a member combination specified using the cross-dimensional operator (->). For example, this is correct usage: @MEMBER(@NEXTSIBLING("FY19"))->"A1".
This function excludes the specified member. If the specified member is the last sibling, Essbase returns an empty string.

Example

All examples are from the Sample.Basic cube.

@NEXTSIBLING("100–20")

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

@NEXTSIBLING("200")

Returns 300 (the next sibling of 200). @NEXTSIBLING and @SHIFTSIBLING ("200",1) 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.