LEVEL.NAME.PER.ID

The levels of a hierarchy are identified by numbers. This formula returns the name of a level from its ID number.

Syntax

=MDX.GET(Database Alias, Cube, "Hierarchy unique name"&".Levels("&n&").Name")

where 'n' represents a level of the hierarchy.

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

Example

This levels of the Product hierarchy of the Best Practices sample database are All, Product Group, Tire and Size. Their IDs are 0 to 3 respectively. This formula returns 'Product Group':

=MDX.GET("Best Practices OLAP", "ANALYSIS", "[PRODUCT]"&".Levels("&1&").Name")