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

  • Excel Cube Functions

    Excel's CUBEKPIMEMBER function returns a property for a Key Performance Indicator and displays its name in a cell. ... How to Use...

  • How to Use Excel's CUBEMEMBER Function

    This function requires a connection to a data source. tech section. Computers. Desktops; Laptops ... How to Use Excel's CUBEVALUE Function. Learn...

  • How to Use Excel's Choose Function

    Note that Choose returns A3 in this example, which is then used as part of a range reference for Sum. Related Searches....

  • How to Use Excel's GETPIVOTDATA Function

    Understand the syntax of the GETPIVOTDATA function. The formula is =GETPIVOTDATA(pivot_table, name). ... How to Use Excel's CUBEVALUE Function; Comments

  • How to Do a Cube Root in Excel

    How to Do a Cube Root in Excel. ... Read the cubic root value calculated in cell "A2." In this example, the...

  • How to Use Excel's YEAR Function

    How to Use Excel's MONTH Function. Example 1: =MONTH(A2) will return 4 because April is the fourth month of the year. ......

  • 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. ... How to Use Excel's...

Related Searches

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