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.