@PREVSIBLING

The @PREVSIBLING calculation function for Essbase returns the previous sibling (the sibling to the immediate left) of the specified member.

This function excludes the specified member. If the specified member is the first sibling, Essbase returns an empty string.

This function returns the next sibling as a string. To pass this function as a parameter of another function, where the function requires a list of members, you must wrap the @PREVSIBLING function call within a @MEMBER function call.

You must also 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".

Syntax

@PREVSIBLING(mbrName)

Parameters

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

Example

All examples are from the Sample.Basic database.

@PREVSIBLING("100–20")

Returns 100-10 (the previous sibling of 100-20). The @PREVSIBLING("100–20") function and the @SHIFTSIBLING("100-20",-1 function return the same results.

Returns 100 (the previous sibling of 200).

@PREVSIBLING("100–10")

Returns an empty list, as 100-10 does not have a previous sibling.

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

Returns an empty list, as there is no previous sibling of East at the same level.