CUBEVALUE
The CUBEVALUE function retrieves data from a cube, which is a set of data organized into a multidimensional structure. It is used in Excel with OLAP cubes to extract specific data points based on given criteria.
Syntax 🔗
=CUBEVALUE(connection, member_expression, [tuple])
connection | The connection to the cube data source. |
member_expression | The expression that specifies the cube member or members that define the value to retrieve. |
tuple (Optional) | A tuple that defines a unique intersection within the cube. If omitted, the CUBEVALUE function retrieves the aggregated value based on the specified member_expression. |
About CUBEVALUE 🔗
The CUBEVALUE function in Excel helps you extract data from OLAP cubes, allowing you to analyze information from different perspectives. By specifying the cube connection and member_expression, you can locate the exact data point you need. The optional tuple parameter lets you identify specific intersections within the cube for more detailed analysis. Use CUBEVALUE to explore sales figures, customer trends, or financial datasets, supporting your decision-making with comprehensive multidimensional data.
Examples 🔗
To retrieve the total sales amount for 'Product A' in the 'East' region for 'Q1 2022', in a cube containing sales data with dimensions like Product, Region, and Time, use the following CUBEVALUE formula: =CUBEVALUE("SalesCube","[Product].[Product A],[Region].[East],[Time].[Q1 2022]")
To fetch the budget amount for 'Salary' in 'January 2022' for the 'Best Case' scenario in a finance cube with dimensions like Account, Time, and Scenario, use the CUBEVALUE function as follows: =CUBEVALUE("FinanceCube","[Account].[Salary],[Time].[January 2022],[Scenario].[Best Case]")
Notes 🔗
To use CUBEVALUE, ensure you understand the cube structure and its dimensions. You can use calculated members in the member_expression to retrieve specific calculated data points. Customize the member_expression and tuple parameters to match your cube dataset's structure and requirements.
Questions 🔗
Unlike traditional Excel functions that operate on flat tables, CUBEVALUE is designed specifically for interacting with multidimensional cube data. It enables users to extract values from OLAP cubes based on specific member expressions and tuple intersections, providing a powerful tool for multidimensional data analysis.
Can multiple data points be retrieved simultaneously using the CUBEVALUE function?Yes, by specifying multiple member expressions within the CUBEVALUE function, you can retrieve multiple data points simultaneously from the cube. Each member expression delineates a distinct data point, allowing for versatile data extraction in a single formula.