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.