DE.DESCENDANTSCOUNT
Returns the recursive number of children of a specified consolidated element.
Syntax
DE.DESCENDANTSCOUNT(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 children, grandchildren,
great-grandchildren, and so on.
Example
This example returns 16 (12 months + 4 quarters):
DE.DESCENDANTSCOUNT('Period', '2006')
The Year
element contains four
quarters, each containing three months. The quarters and months are all descendants of the
Year
element.
If there are multiple hierarchies, elements with the same name are counted only once.