How to Use Excel's CUBEMEMBER Function


Excel's CUBEMEMBER function returns a unique member from a cube that matches the specified expression. It is used primarily to determine the existence of that member within the cube. This function requires a connection to a data source.

  • Learn the syntax for CUBEMEMBER. It's CUBEMEMBER(connection_name,member_expression[,text])
    where connection_name is the name of the connection to the data source, member_expression is an expression that evaluates to a unique member and text is an optional string to display in the cell.

  • Restrict member_expression to less than 256 characters when entering it directly into the argument list. Longer text strings may be entered into a cell and the reference to that cell may be used in the argument list for CUBEMEMBER.

  • Expect CUBEMEMBER to temporarily display the text "#GETTING_DATA..." in the cell while the data is being retrieved from the data source. CUBEMEMBER will return the #NAME? error value if the Online Analytical Processing server is not available.

  • Interpret the error values that may be returned by CUBEMEMBER. The #N/A error value will be returned when a unique member in the cube cannot be identified such as when member_expression uses incorrect syntax, there is no matching member in the cube or not all members in the set have the same dimension.

  • Look at some examples of CUBEMEMBER. =CUBEMEMBER("Sales",[Time],[Fiscal],[2007]) would return the member containing the data for fiscal 2007 from the Sales data source. =CUBEMEMBER($A$1,D$12) would return the member from the data source specified in cell A1 that match the expression contained in cell D12.

Promoted By Zergnet


You May Also Like

Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!