CUBEMEMBERPROPERTY

Syntax:

CUBEMEMBERPROPERTY ( connection , member-expression , property )

Description: Fetches a property of a member in the OLAP cube on an SQL Server.

Note: : Use this function o validate that a member name exists within the cube and to return the specified property for this member.

Arguments:

Name	Type	Description
connection	text	The name of the connection to the cube.
member-expression	text	A multidimensional expression (MDX) that evaluates to a unique member in the cube.
property	text	The name of the property returned or a reference to a cell that contains the name of the property.

Return Type and Value: any – A property of a member in the OLAP cube.

However, if

The connection name is not a valid workbook connection stored in the workbook, the return value is unspecified.
The OLAP server is not running, not available, or returns an error message, the return value is unspecified.
The syntax of member-expression is incorrect, the return value is unspecified.
The member specified by member-expression doesn’t exist in the cube, the return value is unspecified.

example: