HIERARCHY.COUNT.ELEMENTS

This formula returns the number of elements in a specified hierarchy.

Syntax

=MDX.GET(Database Alias, Cube, "Hierarchy"&".AllMembers.Count")

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

Example

This formula returns the total number of elements in the Product hierarchy:

=MDX.GET("Best Practices OLAP", "ANALYSIS", "[PRODUCT]"&".AllMembers.Count")

Parent topic: MDX.GET and Predefined MDX.GET formulas