Menu
EXCEL CUBEMEMBERPROPERTY FUNCTION
Excel CUBEMEMBERPROPERTY Function Introduction
The CUBEMEMBERPROPERTY function, one of Excel’s Cube functions, returns the value of a cube’s member property. It may be used to verify if a member name exists within the cube and to return the requested property for that member.
Description of Excel CUBEMEMBERPROPERTY Function
Syntax:
=CUBEMEMBERPROPERTY(connection, member_expression, property)
Parameter:
- The syntax of the CUBEMEMBERPROPERTY function is as follows:
- An internet connection is required. A text string containing the name of the cube connection.
- Member expression must be present. A text string containing a multidimensional MDX) of a cube member.
- It is necessary to have property. A text string containing the name of the property or a reference to a cell containing the name of the property is returned.
Step By Step Guide of CUBEMEMBERPROPERTY Function
Example :
=CUBEMEMBERPROPERTY(“Sales”,”[Time].[Fiscal].[2014]”,$A$3)
=CUBEMEMBERPROPERTY(“Sales”,”[Store].[MyFavoriteStore]”,”[Store].[Store Name].[Store Sqft]”)
Key Points
- When the CUBEMEMBERPROPERTY function evaluates, it shows a “#GETTING DATA…” message in the cell before retrieving all of the data.
- CUBEMEMBERPROPERTY returns a null value if the member expression syntax is wrong or if the member given by member expression does not exist in the cube a #N/A error value.
- CUBEMEMBERPROPERTY returns a #NAME? error value if indeed the relationship name is not a legitimate worksheet relation stored in the workbook.
- CUBEMEMBERPROPERTY delivers a #NAME? error value if the Online Analytical Processing (OLAP) server is not functioning, is unavailable, or sends an error message.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
