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

You can use the @PREVSIBLING function as a parameter of another function,
where the function requires a list of members.

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.

See Also

  • @NEXTSIBLING
  • @SHIFTSIBLING