CUBERANKEDMEMBER

Definition: CUBERANKEDMEMBER is a function that returns the nth ranked member or tuple from an OLAP cube, based on a specified measure.

Syntax: =CUBERANKEDMEMBER(connection, set_expression, rank, [measure_expression])

Situation: This formula is suitable when you need to retrieve the nth ranked member or tuple from an OLAP cube, based on a specified measure.

Example: If you have an OLAP cube connected to Excel and want to retrieve the second ranked member from a set based on the “Sales” measure, the formula =CUBERANKEDMEMBER(connection, “Top 10 Customers”, 2, “[Measures].[Sales]”) can be used.