CUBEMEMBER function in Excel, returns elements or sets from blocks

CUBEMEMBER function in Excel, returns elements or sets from blocks. To learn more about the CUBEMEMBER function, function syntax and usage. Readers refer to the following article of

In addition to the CUBEMEMBER function in Excel, which returns elements or sets from blocks, you can refer to some other articles on to learn more about the ISERR function, CUBEMEMBERPROPERTY function in Excel ..

Description of the CUBEMEMBER function in Excel

The CUBEMEMBER function in Excel returns an element or set from a block. The function used to validate an element or set exists in a block.

CUBEMEMBER function syntax in Excel, returns the element or block word set

CUBEMEMBER function in Excel has the syntax as below:

CUBEMEMBER (connection, member_expression, )


– Argument Connection is required. Text string name of the connection to the block.

– Argument Member_expression is required. Multi-dimensional expression text string (MDX) evaluates the unique element in a block. In other words, member_expression can be a set defined as a range of cells or an array constant.

– Argument Caption is optional. The text string displayed in the cell instead of the comment, if any comment is defined from the block. When a set is returned, the comment used is the comment for the last element in the set.

Note with the CUBEMEMBER function in Excel, returns the element or block word set

– When CUBEMEMBER evaluates, it will temporarily display the message “#GETTING_DATA …” in the cell before all data is retrieved.

– When using CUBEMEMBER as an argument to another CUBE function, the MDX expression identifies the elements or sets used by that CUBE function, not the value displayed in the cell of the CUBEMEMBER function.

– If the connection name is not a valid connection stored in the workbook, CUBEMEMBER will return the #NAME ?. If the Online Analytical Processing (OLAP) server is not running, is unavailable, or returns an error message, CUBEMEMBER will return the #NAME ?.

– If at least one element in the set is invalid, CUBEMEMBER will return the #VALUE! Error.

– If member_expression is longer than 255 characters, the limit for the function argument, CUBEMEMBER will return the #VALUE! Error. To use a text string longer than 255 characters, enter the text string in the cell (32,767 characters limit), then use the cell reference as an argument.

– CUBEMEMBER function returns the # N / A error when:

+ Member_expression syntax is incorrect.

+ The element specified by the MDX text string does not exist in the block.

+ The set is invalid because there is no intersection for the specified values. (This can happen to many components of the same hierarchy.)

+ The set contains at least one element with a different size than the other elements.

– The CUBEMEMBER function may return a # N / A error if you reference a session-based object, such as a calculated element or set name in a PivotTable when connection sharing and a PivotTable are deleted or you convert PivotTable into formula. (in Options tab, in groups Tools, click OLAP Tools then select Convert to Formulas).

CUBEMEMBER function in Excel, for example, returns an element or a set from a block

Here are some examples of CUBEMEMBER functions in Excel, returning elements or sets from blocks:

= CUBEMEMBER (“Sales”, “[Time].[Fiscal].[2004]”)

= CUBEMEMBER ($ A $ 1, D $ 12)

= CUBEMEMBER (“Sales”, (B4, C6, D5), “SalesFor2004”)

= CUBEMEMBER (“xlextdat8 FoodMart 2000 Sales”, “([Product].[Food],[Time].[1997]) “)

= CUBEMEMBER ($ A $ 1, C $ 12: D $ 12)

The above article has just introduced you to CUBEMEMBER function in Excel, returning elements or sets from blocks. In addition to learn some other common Excel functions such as CUBEVALUE, CODE, AVERAGE function in Excel, readers can refer to some other articles on
In Excel, there are many different functions, there are independent functions, but there are also many functions when combined together that will help you solve the problem much faster, can link to the Indext function and the Match function, to know the syntax. method when combining the Indext and Match functions, you refer to the article sharing combinations Indext and Match functions here.


Add a Comment

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