LEVEL.HIERARCHY.NAME

This formula returns the name of the hierarchy to which a specified hierarchy level belongs.

Syntax

=MDX.GET(Database Alias, Cube, "Hierarchy level"&".Dimension.Name")

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 'Product', the name of the hierarchy to which the Tire level belongs: =MDX.GET("Best Practices OLAP", "ANALYSIS", "[PRODUCT].[Tire]"&".Dimension.Name")

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