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