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:

CUBERANKEDMEMBER("Sales",$D$4,1,"Top Month")
CUBERANKEDMEMBER("Sales",CUBESET("Sales","Summer","[2004].[June]",
"[2004].[July]","[2004].[August]"),3,"Top Month")

end example]