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. end note]

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:

CUBEMEMBERPROPERTY("Sales","[Time].[Fiscal].[2004]",$A$3)
CUBEMEMBERPROPERTY("Sales","[Store].[MyFavoriteStore]",
"[Store].[Store Name].[Store Sqft]")

end example]