The CUBEMEMBERPROPERTY function in Excel is a powerful tool for extracting detailed information from data cubes. By providing the capability to query specific member properties, this function is essential for validating member names within the cube and obtaining relevant property values, enhancing data analysis effectiveness.

Syntax

CUBEMEMBERPROPERTY(connection, member_expression, property)  
 
connection: A string that represents the name of the cube data connection.
 
member_expression: The specific member whose property you want to retrieve.
 
property: The name of the property you wish to obtain for the specified member.
 
 

Example #1

CUBEMEMBERPROPERTY("SalesCube", "[Products].[Bikes]", "Color")

This function call retrieves the color of the member “Bikes” from the “SalesCube”. Result: “Red”.

Example #2

CUBEMEMBERPROPERTY("FinanceCube", "[Accounts].[Expenses]", "AccountID")

Here, the function fetches the AccountID for the member “Expenses” from the “FinanceCube”. Result: “EXP001”.

Example #3

CUBEMEMBERPROPERTY("HRDB", "[Employees].[John Doe]", "Department")

This example returns the department name for “John Doe” in the “HRDB”. Result: “Human Resources”.

Error handling

• N/A: This error occurs when the specified member does not exist in the cube.
• VALUE: This indicates that the member expression or property name is invalid.
• REF: The connection name provided does not refer to a valid cube connection.

Conclusion

The CUBEMEMBERPROPERTY function is indispensable for analysts who require precise control over data extraction from cubes. By enabling users to specify member properties, it aids in improving data accuracy and enhances the overall analytical capabilities within Excel.