ELEMENT.COUNT.CHILDREN

This function returns the number of child elements of a specified element.

Syntax

=MDX.GET(Database Alias, Cube, "Element Unique Name"&".children.count")

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

Example

This example returns 3:

=MDX.GET("Best Practices OLAP", "ANALYSIS", "[PRODUCT].[All Tires].[Car Tires All Season]"&".children.count")