DE.CHILDRENCOUNT

Returns the number of children of a specified consolidated element.

Syntax

DE.CHILDRENCOUNT(Database alias,Dimension,Element)

This formula returns 5:

=DE.CHILDRENCOUNT("Best Practices OLAP","Product","All Tires")

Dimension is the name of the dimension which contains the consolidated element and Element is the consolidated element.

Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.

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