HIERARCHY.DIMENSION.NAME
This formula returns the dimension name from a specified hierarchy's unique name.
Syntax
=MDX.GET(Database Alias, Cube, "Hierarchy unique name"&".Dimension.Name")
Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.