ELEMENT.HIERARCHY.NAME

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

Syntax

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

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