This function returns a member (or tuple) from the cube.
CUBEMEMBER(connection, member_expression, [caption])
This function has the following arguments:
| Argument | Description |
|---|---|
| connection | Refers to the string data specifying the name of the connection to the cube. |
| member_expression | Refers to the string data specifying the multidimensional expression (MDX) text that evaluates to unique member in the cube. |
| caption | [Optional] Refers to the string data specifying the text to display in the cell instead of the caption. |
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.
CUBEMEMBER("Product_Sales",(A1, B4, C4),"SalesIn2017")
CUBEMEMBER("Product_Sales","[Time].[Fiscal].[2017]")
CUBEMEMBER("xlextdat8 WallMart 2017 Sales","([Product].[Food],[Time].[2016])")
This function is available in product version 11.0 or later.