DE.LEAFDESCENDANTSCOUNT

Returns the recursive number of base descendant elements of the specified consolidated element.

Syntax

DE.LEAFDESCENDANTSCOUNT(Dimension, Element)

Dimension is the name of the dimension which contains the consolidated element. Element is the element of which you want to determine the number of base descendants.

Example

This example returns 12:

DE.LEAFDESCENDANTSCOUNT('Period', '2005')

The 2005 element contains four quarters, each containing three months. All are descendants of the 2005 element. But only the months are base elements so the quarters are not included.

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