DE.ISDESCENDANT

Returns TRUE if the second specified element is a descendant of the first.

Syntax

DE.ISDESCENDANT(Dimension, RootElement, TestedElement)

Dimension is the name of the dimension which contains the specified elements. RootElement is the ancestor element. TestedElement is the descendant element.

Examples

The first two examples return TRUE:

DE.ISDESCENDANT('Period', '2005_Q1', '2005_Q1_01')

DE.ISDESCENDANT('Period', '2005', '2005_Q1_01')

This example returns FALSE:

DE.ISDESCENDANT('Period', '2005_Q2', '2005_Q1_01')

If there are multiple hierarchies, elements with the same name are counted only once.