HIERARCHY.COUNT.LEVELS

This function returns the number of levels of a specified hierarchy.

Syntax

=MDX.GET(Database Alias, Cube, "Hierarchy"&".Levels.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 the number of levels in the POS hierarchy:

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

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