DE.SIBLING

Returns a sibling of a specified element. The sibling returned is specified by an offset number.

Syntax

DE.SIBLING(Dimension, Element, Offset)

Example

The 2010 element in the PERIOD dimension has these four children: 2010_Q1, 2010_Q2, 2010_Q3 and 2010_Q4 defined in that order.

This example returns 2010_Q4:

DE.SIBLING('Period', '2010_Q2', +2)

This example returns 2010_Q1:

DE.SIBLING('Period', '2010_Q2', -1)