How to use CUBEMEMBERPROPERTY Function in Excel

The CUBEMEMBERPROPERTY function returns the value of a member property from the cube. Use this Function to validate that a member name exists within the cube and to return the specified property for this member.

Syntax: =CUBEMEMBERPROPERTY(connection, member_expression, property)

The CUBEMEMBERPROPERTY function syntax has the following arguments:

  • Connection    Required. A text string of the name of the connection to the cube.
  • Member_expression    Required. A text string of a multidimensional expression (MDX) of a member within the cube.
  • Property    Required. A text string of the name of the property returned or a reference to a cell that contains the name of the property.

Example: Let’s look at some Excel CUBEMEMBERPROPERTY function examples and explore how to use the CUBEMEMBERPROPERTY function as a worksheet function in Microsoft Excel:

Syntax: 

=CUBEMEMBERPROPERTY(“Sales”,”[Time].[Fiscal].[2004]”,$A$3)

=CUBEMEMBERPROPERTY(“Sales”,”[Store].[MyFavoriteStore]”,”[Store].[Store Name].[Store Sqft]”)

Note:

  • When the CUBEMEMBERPROPERTY function evaluates, it temporarily displays a “#GETTING_DATA…” message in the cell before all of the data is retrieved.
  • If the connection name is not a valid workbook connection stored in the workbook, CUBEMEMBERPROPERTY returns a #NAME? Error value. If the Online Analytical Processing (OLAP) server is not running, not available, or returns an error message, CUBEMEMBERPROPERTY returns a #NAME? Error value.
  • If the member_expression syntax is incorrect or if the member specified by member_expression does not exist in the cube, CUBEMEMBERPROPERTY returns a #N/A error value.
  • CUBEMEMBERPROPERTY may return a #N/A error value if you reference a session-based object, such as a calculated member or named set, in a PivotTable when sharing a connection. The PivotTable is deleted or you can convert the PivotTable to formulas. (On the Options tab, in the Tools group, click OLAP Tools, and then click Convert to Formulas.)
READ:  How to use CUBESET Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *