CUBERANKEDMEMBER()

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

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

Arguments

  • 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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial