This function calculates an aggregated value from the cube.
CUBESET(connection, [member_expression1], [member_expression2])
This function has the following arguments:
| Argument | Description |
|---|---|
| connection | Refers to the string data specifying the name of the connection to the cube. |
| member_expression1, member_expression2 | [Optional] Refers to the string data specifying the multidimensional expression (MDX) text that evaluates to unique member in the cube. |
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.
CUBEVALUE($B$1,"[Measures].[Profit]",C$12,$A23)
CUBEVALUE("Product_Sales",$B$7,D$12,$A23)
CUBEVALUE("Product_Sales","[Measures].[Profit]","[Time].[2017]","[All Products].[Soft Drinks]")
This function is available in product version 11.0 or later.