Definition. This function returns a calculated set of members by sending a set expression to the cube on the server, which creates the set and then returns that set to Excel. The content of the cell and the actual value of the cell are different.
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 elements 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. ...