CUBEMEMBER

Definition: CUBEMEMBER is a function that returns a member or tuple from an OLAP cube.

Syntax: =CUBEMEMBER(connection, member_expression)

Situation: This formula is suitable when you need to retrieve a member or tuple from an OLAP cube.

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