CUBEVALUE(connection [,member_expression1])

Returns the aggregated value from a cube.

connectionThe name of the connection.
member_expression1The MDX expression you want to evaluate.

Remarks

* Added in Excel 2007.
* If "connection" is not valid, then #NAME? is returned.
* If the OLAP server if not running, then #NAME? is returned.
* While the data is being retrieved #GETTING_DATA is displayed in the cell.
* For the Microsoft documentation refer to support.office.com

 AB
1=CUBEVALUE("Forecasts","[Measures].[Sales]")??


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top