@PREVSIBLING

The @PREVSIBLING calculation function for Essbase returns the previous sibling (the sibling to the immediate left) 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

@PREVSIBLING(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(@PREVSIBLING("FY19"))->"A1".
This function excludes the specified member. If the specified member is the first sibling, Essbase returns an empty string.

Example

All examples are from the Sample.Basic cube. The following example returns 100-10 (the previous sibling of 100-20). Note that @SHIFTSIBLING("100-20",-1) function returns the same result:

@PREVSIBLING("100–20")

The following example returns 100 (the previous sibling of 200):

@PREVSIBLING("200")

The following example returns an empty list, as 100-10 does not have a previous sibling:

@PREVSIBLING("100–10")

The following example returns an empty list, as there is no previous sibling of East at the same level:

@CHILDREN(@MEMBER(@PREVSIBLING("East")))