Syntax:

=CUBERANKEDMEMBER(connection, set_expression, rank, )

Parameter:

• The following parameters are passed to the CUBERANKEDMEMBER function syntax:
• An internet connection is required. A text string containing the name of the cube connector.
• Set expression must be used. A text string containing a predefined formula, such as “[Item1].children”.
• Set expression can either be the CUBESET function or a cell reference containing the CUBESET function.
• A rank is required. An integer number indicating the highest value to return.
• If rank is 1, the top value is returned; if rank is 2, the second most top value is returned; and so on To return the top 5 values, use CUBERANKEDMEMBER five times, specifying a different rank, 1 through 5, each time.
• Optional caption. A text string from the cube is shown in the cell instead of the caption, if one is defined.