CUBEMEMBERPROPERTY

CUBEMEMBERPROPERTY(connection, member_expression, property)

Returns the value of a member property from a cube.

connectionThe name of the connection.
member_expressionThe MDX expression you want to evaluate.
propertyThe name of the property to return.

REMARKS
* This function will always be single threaded.
* While the data is being retrieved #GETTING_DATA is displayed in the cell.
* You can use the CUBEKPIMEMBER function to return the name of a key performance indicator.
* You can use the CUBEMEMBER function to return the member or tuple from a cube.
* You can use the CUBERANKEDMEMBER function to return the nth or ranked member in a set from a cube.
* You can use the CUBESET function to return the calculated members returned from a cube.
* You can use the CUBESETCOUNT function to return the number of items in a set.
* You can use the CUBEVALUE function to return the aggregated value from a cube.
* This function was added in Excel 2007.
* For the Microsoft documentation refer to support.microsoft.com

 AB
1=CUBEMEMBERPROPERTY("Forecasts",[Time].[2016],"property")??


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