CUBEVALUE

The CUBEVALUE function retrieves data from a cube, which is a set of data arranged and summarized into a multidimensional structure. It is primarily used in Excel in conjunction with OLAP (Online Analytical Processing) cubes to extract specific data points based on specified 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

Ever puzzled over navigating through multidimensional data structures in Excel? Enter CUBEVALUE, the trusted ally for extracting insights from OLAP cubes. This function is a lifesaver for analysts and data enthusiasts needing to access precise data points within the complex layers of a multidimensional cube. OLAP cubes serve as repositories of organized data, enabling users to break down and analyze information from various angles and perspectives. With CUBEVALUE, you can tap into this wealth of data effortlessly by specifying the cube connection and defining the member_expression to pinpoint the exact data point you seek. Furthermore, the optional tuple parameter offers the flexibility to pinpoint specific intersections within the cube, delving deeper into the labyrinth of multidimensional data. Whether it's slicing and dicing sales figures, exploring customer trends, or unraveling intricate financial datasets, CUBEVALUE empowers you to unearth meaningful insights and drive informed decision-making based on comprehensive multidimensional data analysis.

Examples

Assuming you have a cube containing sales data with dimensions like Product, Region, and Time, to retrieve the total sales amount for 'Product A' in the 'East' region for 'Q1 2022', you can use the following CUBEVALUE formula: =CUBEVALUE("SalesCube","[Product].[Product A],[Region].[East],[Time].[Q1 2022]")

In a finance cube with dimensions like Account, Time, and Scenario, to fetch the budget amount for 'Salary' in 'January 2022' for the 'Best Case' scenario, you can employ the CUBEVALUE function as follows: =CUBEVALUE("FinanceCube","[Account].[Salary],[Time].[January 2022],[Scenario].[Best Case]")

Questions

How does the CUBEVALUE function differ from traditional Excel functions?

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.

Related functions

CUBEMEMBER
CUBEMEMBERPROPERTY
CUBERANKEDMEMBER
CUBEWEEKDAY
GETPIVOTDATA