This function returns the property of a member from the cube. Use CUBEMEMBERPROPERTY() to validate that a member exists within the cube and to return the property for this member as a value.
Syntax
CUBEMEMBERPROPERTY(connection; member_expression; property)
Arguments
- connection (required): A string representing the name of the workbook connection to the cube. After you type the first quotation mark, existing context-sensitive data connections are displayed.
- member_expression (required): Defines the position of a member in the cube based on a Multidimensional Expression (MDX). The expression can be entered directly or referenced from a cell. Tuples can also be used in expressions.
- property (required): The name of the property for which you want to return the value.
Background
In the example in this section, the stores have the « Group » property with possible values of « North » or « South ».
While the data is being queried, the message #GETTING_DATA temporarily appears in the cell containing the function.
Error values and messages provide information about incorrect or missing entries:
- If the connection name is not a valid workbook connection, the CUBEMEMBERPROPERTY() function returns the #NAME? error.
- If the OLAP server (or the offline cube) is unavailable, an error message will appear, but the content of the affected cell will not change.
- If the member_expression syntax is incorrect, or if the member specified by member_expression does not exist in the cube, the CUBEMEMBERPROPERTY() function returns the #N/A error.
- CUBEMEMBERPROPERTY() might also return the #N/A error when the connection to the data source is interrupted and cannot be re-established.
Example
As previously mentioned, the stores in the PivotTable have the « Group » properties « North » and « South. »
The formula =CUBEMEMBERPROPERTY(« offline », »[Stores].[Store Name].[All].[NorthEast] », »group Name ») returns North.
The formula =CUBEMEMBERPROPERTY(« offline », »[Stores].[Store].&[3] », »group ») returns South.
This example uses the position number of the store in the list instead of the store name.
