DE.CHILDNAME
Returns the child of a specified consolidated element.
Syntax
DE.CHILDNAME(Database alias,Dimension,Element,Index)
Dimension is the name of the dimension which contains the consolidated element, Element is the consolidated element and Index is the number of the child you want display.
Example
The All Tires element of the Product dimension on the Best Practices Templates database alias, has five children. This formula returns Car Tires Summer:
=DE.CHILDNAME("Best Practices OLAP","Product","All Tires",2)
The first three arguments may be strings or references to cells containing strings. Strings,must be enclosed in quotes. The last argument must be a number or reference to a cell containing a number.