This function returns the specified ranked member in the set.
CUBERANKEDMEMBER(connection, set_expression, rank, [caption])
This function has the following arguments:
| Argument | Description |
|---|---|
| connection | Refers to the string data specifying the name of the connection to the cube. |
| set_expression | Refers to the string data specifying the set expression. |
| rank | Refers to integer value specifying the value to return. |
| caption | [Optional] Refers to the string data specifying the text to display in the cell instead of the caption. |
This function returns a temporary message "#GETTING_DATA..." in the cell while being evaluated and before all the data in the cell is retrieved.
Accepts string data for all arguments, except for rank argument. The rank argument accepts numeric data.
CUBERANKEDMEMBER("Product_Sales",$A$2,1,"Top Selling Product")
This function is available in product version 11.0 or later.