Syntax. CUBERANKEDMEMBER(connection,set_expression,rank,caption)

Definition. This function returns the n-th member in a set.


  • connection (required) A string with the name of the workbook connection to the cube. After you enter the first quotation mark, the existing context-sensitive data connections are displayed (see Figure 14-4, shown earlier).

  • set_expression (required) Defines the number of members in the cube based on an MDX. The expression can be entered directly or can be in a cell that is referenced. You can also use tuples in expressions.

  • rank (required) An integer indicating the position of a member in the set.

  • caption (required) A string displayed in the cell instead of the caption of the member in the cube. If ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.