CUBERANKEDMEMBER

Syntax:

CUBERANKEDMEMBER ( connection , set-expression , rank [ , caption ] )

Description: Fetches the nth, or ranked, member in a set.

Arguments:

Name

Type

Description

connection

text

The name of the connection to the cube.

set-expression

text

A set expression, such as "{[Item1].children}".

rank

number

Specifies the top value to return, truncated to integer. If 1, the top value is returned; if 2, the second-most top value is returned; and so on.

caption

text

The text displayed in the cell instead of the caption from the cube (assuming it defines such a caption).

Return Type and Value: any – The nth member in the set.

However, if

  • The connection name is not a valid workbook connection stored in the workbook, the return value is unspecified.

  • The OLAP server is not running, not available, or returns an error message, the return value is unspecified. , the return value is unspecified.

  • The syntax of member-expression is incorrect, the return value is unspecified.

  • The set contains at least one member with a different dimension than the other members, the return value is unspecified.

example: