CUBEVALUE

Definition: CUBEVALUE is a function that returns the value of a measure from an OLAP cube.

Syntax: =CUBEVALUE(connection, [member_expression1], [member_expression2], …, [member_expression_n], [measure_expression])

Situation: This formula is suitable when you need to retrieve the value of a measure from an OLAP cube.

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