Excel Function : CUBEMEMBERPROPERTY
Category
Cube
Description
Returns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member.
Microsoft Excel Reference Page
Syntax and Description of the CUBEMEMBERPROPERTY Excel Function
I'm trying to use CUBEMEMBERPROPERTY function in Excel and cannot figure out how to use it. I have made a connection to a cube in Excel 2013 and can display data from the cube. Now I would like to get more information about the cube members. I have been reading the following link and it seems to be the closest I can get to the information I'm looking for: https://support.office.com/en-za/article/CUBEMEMBERPROPERTY-function-c00d22e5-5b5f-4dcd-a3d5-f6cbd53e1f5d My question is specifically about the
About CUBEMEMBERPROPERTY Excel Function
CUBEMEMBERPROPERTY returns the value of a specified property for a given member of a cube. Syntax: CUBEMEMBERPROPERTY(cube_name, member_name, property_name) Arguments: cube_name - The name of the cube. member_name - The member of the cube. property_name - The name of the property. Returns: The value of the property for the given member. Remarks: The property_name argument can be one of the following: ALL - Returns all the properties and their values for the given member. CAPTION