How to Use Excel's CUBEVALUE Function

Save

Excel's CUBEVALUE function returns an aggregate value based on the specified member expressions and might typically be used to calculate a sales total from a given year. This function requires a data source. The following steps will show how to use Excel's CUBEVALUE function.

  • Learn the syntax for CUBEVALUE. It's CUBEVALUE(connection_name,member_expression_1[,member_expression_2]...
    [,member_expression_n)
    where connection_name is the name of the connection to the data source and a member_expression is an expression that defines a set of members in the cube. A member_expression may be defined by the CUBESET function.

  • Expect CUBEVALUE to display the text "#GETTING_DATA..." in the cell while the data is being retrieved from the data source. CUBEVALUE will return the #NAME? error value if connection_name is not a valid connection or is unavailable.

  • Interpret the most likely cause of a #VALUE error value to be caused by an invalid member of the defined set.

  • Examine possible causes of a #N/A error value. This can be the result of incorrect syntax in a member_expression, a member_expression that references a non-existent member, an empty return set or a return set that has a member with a different dimension from the other members. A #N/A error value can also occur when CUBEVALUE references a session based object that is no longer available.

  • Look at some examples of CUBEVALUE. =CUBEVALUE("Sales","[Measures].[Profit]","[Time].
    [2004]","[AllProduct].[Beverages]")
    will select records for the profits on beverages for 2004 from the Sales cube.
    =CUBEVALUE("Sales",$A$1,$B$2,$C$3) will return the member set formed by the intersection of the expressions contained by the cells A1, B2 and C3.

Promoted By Zergnet

Comments

Resources

You May Also Like

  • How to Do a Cube Root in Excel

    The cubic root is the mathematical operation that is reverse raising a number to the power of 3. For example, the cubic...

  • How to Use Excel's YEAR Function

    Excel's YEAR function returns the year of a given date. The returned year will be an integer between 1900 and 9999 inclusive....

  • How to Use Excel's Choose Function

    Excel's Choose function returns a value from a list of arguments based on the specified index number. For example, this might be...

  • How to Use Excel's Combin Function

    Excel's Combin function returns the number of ways that the specified number of items can be combined. It may be used to...

  • 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...

  • How to Use Excel's GETPIVOTDATA Function

    A pivot table is a useful tool that can sort and total information contained in cells. To use Microsoft Excel's GETPIVOTDATA function,...

  • Excel Cube Functions

    The industry term "cube" refers to a method of analyzing the contents of a database for purposes of learning more about your...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

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