GET.PARENT

This function returns the name of the element which is the parent of an element which you specify.

Syntax

=MDX.GET(Database Alias, Cube, "Element Unique Name"&".Parent.Name")

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

This example returns 'Car Tires All Season':

=MDX.GET("Best Practices OLAP", "ANALYSIS", "[PRODUCT].[All Tires].[Car Tires All Season].[AS800 Touring]"&".Parent.Name")