CUBESET
Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Excel
Syntax
CUBESET(connection, set_expression, [caption], [sort_order], [sort_by])
Parameters
- connection: Required. A text string of the name of the connection to the cube
- set_expression: Required. A text string of a set expression that results in a set of members or tuples
- caption: Optional. A text string displayed in the cell instead of the caption from the cube
- sort_order: Optional. The type of sort to perform (0=default, 1=ascending, 2=descending, 3=alpha ascending, 4=alpha descending, 5=natural ascending, 6=natural descending)
- sort_by: Optional. A text string of the value to sort by
Example
=CUBESET("Sales", "{[Product].[Bikes], [Product].[Accessories]}")