@PREVSIBLING

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 the @PREVSIBLING function as a parameter of another function, where the function requires a list of members, you must wrap the output of @PREVSIBLING with the @MEMBER function.

Syntax

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

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

See Also