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.

Related Searches

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!