How to Use Excel's CUBEMEMBER Function

Save

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

Comments

You May Also Like

Related Searches

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