This function evaluates the number of possible combinations (along with repetitions) for the specified number of items.
CUBESET(connection, set_expression, [caption], [sort_order], [sort_by])
This function has the following arguments:
| Argument | Description |
|---|---|
| connection | Refers to the string data specifying the name of the connection to the cube. |
| set_expression | Refers to the string data specifying the set of members. |
| caption | [Optional] Refers to the string data specifying the text to display in the cell instead of the caption. |
| sort_order | [Optional] Refers to the Enumerated Constants used to sort set_expression. |
| sort_by | [Optional] Refers to the string data specifying the value to sort by. |
This function returns a temporary message "#GETTING_DATA..." in the cell while being evaluated and before all the data in the cell is retrieved.
Accepts only string data.
CUBESET("Product_Sales","[Product].[All Products].Toys","Products",1,"[Measures].[Sales Amount]")
CUBESET("Finance","Order([Product].[Product].[Product Category].Members,[Measures].[Product Unit Sales],ASC)","Products")
This function is available in product version 11.0 or later.