Data Analysis Expressions for Multi-Dimensional Spreadsheet Pivot Tables
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current multi-dimensional data analysis applications require proficiency in complex semantic languages like MDX, making it difficult for business employees without training to perform such analysis, and existing spreadsheet formulae are limited to one-dimensional data aggregation.
Innovation Solution
Data Analysis Expressions (DAX) are introduced, allowing for multi-dimensional data analysis within spreadsheet applications, operating on spreadsheet tables and relational data models, independent of specific cell ranges, and supporting multi-table execution and dynamic re-execution.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If conventional spreadsheet formulae are used for data analysis, then ease of operation is maintained, but manufacturing precision of data analysis capability is insufficient due to one-dimensional aggregation limitations
Solution Approach 1:
The patent extends conventional one-dimensional spreadsheet formulae into multi-dimensional space by introducing virtual pivot tables that can aggregate and analyze data across multiple dimensions (rows, columns, and nested levels). This allows users to perform complex multi-dimensional data analysis while maintaining spreadsheet formula syntax, thus resolving the contradiction between ease of operation and data analysis capability.
2Manufacturing precision
If multi-dimensional data analysis applications are used, then manufacturing precision of data analysis capability is improved, but device complexity increases due to requirement of complex semantic languages
Solution Approach 1:
The patent creates a virtual copy of the pivot table functionality within the spreadsheet environment. By implementing a virtual pivot table that replicates multi-dimensional analysis capabilities using familiar spreadsheet formulae syntax, the system provides complex data analysis functionality without requiring users to learn complex semantic languages like MDX, thus resolving the contradiction between data analysis capability and language complexity.
3Manufacturing precision
If specialized analysts are hired for multi-dimensional data analysis, then manufacturing precision of data analysis capability is improved, but loss of substance increases due to hiring costs
Solution Approach 1:
The patent enables business employees to perform multi-dimensional data analysis themselves by providing them with tools that combine the ease of spreadsheet formulae with the power of pivot table functionality. This self-service capability eliminates the need to hire specialized analysts, thus resolving the contradiction between data analysis capability and hiring cost.
4Manufacturing precision
If employees are trained in complex languages like MDX, then manufacturing precision of data analysis capability is improved, but loss of time increases due to training requirements
Solution Approach 1:
The patent creates a universal data analysis tool that works within the existing spreadsheet environment, combining the familiarity of spreadsheet formulae with the power of multi-dimensional analysis. This multi-functional approach allows the same interface to handle both simple spreadsheet calculations and complex pivot table operations, eliminating the need for separate training in complex languages like MDX and resolving the contradiction between data analysis capability and training time.
Data Source
AI summary
Methods and systems are disclosed for receiving and processing data analysis expressions. A particular method includes receiving a data analysis expression at a pivot table of a spreadsheet. The data analysis expression is executed for a particular cell of the pivot table by determining a context associated with the particular cell, calculating a value of the data analysis expression based on the context, and outputting the calculated value at the particular cell.