CUBEMEMBERPROPERTY

Definition: CUBEMEMBERPROPERTY is a function that returns the value of a specified property for a member or tuple from an OLAP cube.

Syntax: =CUBEMEMBERPROPERTY(connection, member_expression, property_name)

Situation: This formula is suitable when you need to retrieve the value of a specified property for a member or tuple from an OLAP cube.

Example: If you have an OLAP cube connected to Excel and want to retrieve the color property for a member named “Product A”, the formula =CUBEMEMBERPROPERTY(connection, “[Product].[Product A]”, “Color”) can be used.