DE.SIBLING

Returns a sibling of a specified element. The sibling returned is specified by an offset number. That is, the number of elements which separate the siblings in the hierarchy.

Syntax

DE.SIBLING(Database alias,Dimension,Element,Offset)

Dimension is the name of the dimension which contains the element in question and Element is the element. Offset is the offset of the sibling you want to display.

Example

The All Tires element in the Product dimension of the Best Practices database has five children. They are:

Car Tires All Season
Car Tires Summer
Car Tires Winter
Commercial (Van Tires)
SUV (4x4)

This formula returns Commercial (Van Tires) (the second element away from its sibling, Car Tires Summer):

DE.SIBLING("Best Practices OLAP","Product","Car Tires Summer",2)

You can use negative offsets. For example, this returns Car Tires Summer:

DE.SIBLING("Best Practices OLAP","Product","Commercial (Van Tires)",-2)

The first three arguments to this function can be strings or references to cells containing strings. If strings, they must be enclosed in quotes. The last argument must be a number or reference to a cell containing a number.

If an element does not exist or is not a member of Dimension, the function returns a #Value error.