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 Office Excel.
CubeCube & Data Models
What it does
Creates a set of members from the cube for use in other cube functions.
Syntax
CUBESET(connection, set_expression, [caption], [sort_order], [sort_by])
Arguments
connection(text) — Connection name.set_expression(text) — MDX set expression.
Examples
Define Set
Create set of Top 10 products.
FORMULA
=CUBESET("Sales", "[Product].[Top10]")RESULT
(Set)
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | (Set Object) |