GET.DEFAULTELEMENT
This formula returns the name of the default element of a hierarchy which you specify.
Syntax
=MDX.GET(Database Alias, Cube, "Hierarchy unique name"&".DefaultMember.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 'All Tires':
=MDX.GET("Best Practices OLAP", "ANALYSIS", "[PRODUCT]"&".DefaultMember.Name")