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: