ELEMENT.ATTRIBUTE

This formula returns the value of a specified attribute of a specified element.

Syntax

=MDX.GET(Database Alias, Cube, "Element unique name"&".properties("""&"Attribute 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 'Ganzjahresreisen', the value of the Att2_German attribute of All Season Tires in the Best Practices sample database:

=MDX.GET("Best Practices OLAP", "ANALYSIS", "[PRODUCT].[All Tires].[Car Tires All Season]"&".properties("""&"Att2_German"&""")")