Excel - CUBEMEMBERPROPERTY Function
CUBEMEMBERPROPERTY Function
The CUBEMEMBERPROPERTY function retrieves the value of a specific member property. This function can fetch properties like numbers, dates, and detailed descriptions. You may utilize the CUBEMEMBERPROPERTY function to validate the names of the members that reside in the cube.
Compatibility
This advanced excel function is compatible with the following versions of MS-Excel −
- Excel for Microsoft 365
- Excel for Microsoft 365 for Mac
- Excel for the web
- Excel 2021
- Excel 2021 for Mac
- Excel 2019
- Excel 2019 for Mac
- Excel 2016
- Excel for iPad
- Excel Web App
- Excel for iPhone
- Excel for Android tablets
- Excel for Android phones
Syntax
The syntax of CUBEMEMBERPROPERTY function is as follows −
CUBEMEMBERPROPERTY (connection, member_expression, property)
Arguments
You can use the following arguments with the CUBEMEMBERPROPERTY function −
| Argument | Description | Required / Optional |
|---|---|---|
| Connection | A text string representing the connection name. | Required |
| member_expression | A text string represents the MDX for a specific member in a cube. | Required |
| Property | A text string denotes the property's name that will be returned or points to a cell where the specific property name is mentioned. | Required |
Points to Remember
- When you compute the CUBEMEMBERPROPERTY function, a "#GETTING_DATA" message will appear for a few seconds before retrieving the actual result in a cell.
- If the connection name is invalid and the connection is not saved in the workbook, the CUBEMEMBERPROPERTY function will retrieve a #NAME error. If the OLAP server is unavailable, not in workable mode, or receives an error message, then the CUBEMEMBERPROPERTY function will retrieve the same error #NAME.
- If the incorrect syntax of MDX has to be written, or the member does not reside in the cube, then the CUBEMEMBERPROPERTY function will retrieve a #N/A error.
- If you specify a session-based object as an argument in the CUBEMEMBERPROPERTY function, it may return a #N/A error value in a pivot table while sharing a connection.
Example
=CUBEMEMBERPROPERTY ("Sales","[Time].[Fiscal].[2004]",$A$3)
=CUBEMEMBERPROPERTY("Sales","[Store].[MyFavoriteStore]","[Store].[Store Name].[Store Sqft]")
Advertisements