Multi-dimensional Data Reporting with Dynamic Callout Interfaces

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Stakeholders in a company face difficulties in analyzing multi-dimensional data reports due to differing needs, as existing reporting software requires reconfiguration and reformatted reports, making it time-consuming for various executives to extract relevant information.

Innovation Solution

A multi-dimensional data reporting system with a callout interface that allows users to explore data by selecting cells, generating a callout report model, and presenting it in a graphical interface, enabling changes in dimensionality and chart types, with options to insert or update the original report.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Device complexity

If a single data report is created for multi-dimensional data, then the report structure is simplified, but different stakeholders cannot access their specific data dimensions efficiently

Engineering Contradiction:
Improvereport structureVSAvoiddata access efficiency
Core Design Contradiction:
Device complexityVSEase of operation

Solution Approach 1:

The patent segments the data report into a base report structure and multiple callout interfaces. Each callout interface is associated with a specific cell in the base report and provides drill-down capabilities for that particular cell's data. This allows the base report to remain simple while enabling complex data exploration through the callout interfaces without requiring multiple separate reports.

Inventive Principle:
Principle #1Segmentation

2Adaptability or versatility

If stakeholders reconfigure and reformat reports to extract specific information, then they can access their needed data, but it consumes considerable time

Engineering Contradiction:
Improvedata extraction capabilityVSAvoidtime for report reconfiguration
Core Design Contradiction:
Adaptability or versatilityVSLoss of time

Solution Approach 1:

The patent performs preliminary action by pre-configuring multiple callout interfaces associated with different cells in the base report. Each callout interface is prepared in advance with its specific data dimensions and formatting, so when stakeholders need information, they can directly access pre-prepared callout interfaces without time-consuming reconfiguration. The system anticipates different data exploration needs and prepares the appropriate interfaces beforehand.

Inventive Principle:
Principle #10Preliminary action

3Ease of manufacture

If the report is designed for specific data dimensions, then the report structure is optimized, but it cannot accommodate diverse data exploration needs of different stakeholders

Engineering Contradiction:
Improvereport structure optimizationVSAvoiddata dimension flexibility
Core Design Contradiction:
Ease of manufactureVSAdaptability or versatility

Solution Approach 1:

The patent implements universality by creating a base report structure that serves multiple functions for different stakeholders. The base report can be accessed by anyone, and from any cell in the base report, users can launch callout interfaces that provide drill-down capabilities tailored to their specific needs. This multi-functional design allows the same base report to serve sales executives, marketing executives, and financial executives with their different data dimension requirements without requiring separate reports for each stakeholder group.

Inventive Principle:
Principle #6Universality (Multi-functionality)

Data Source

PatentUS8839089B2Multi-dimensional data manipulation and presentation
Publication Date: 2014.09.16 MICROSOFT TECHNOLOGY LICENSING LLC
  • US8839089B2 patent drawing
  • US8839089B2 patent drawing
  • US8839089B2 patent drawing

AI summary

A multi-dimensional data reporting system presents a data report based on a data model, creates a callout report model based on a cell in the data report, and presents an instance of the callout report model in a callout interface. In one implementation of the multi-dimensional data reporting system, upon receiving a callout control associated with selected cell of the data report, the system retrieves the multi-dimensional data associated with the selected cell, builds the callout report model based on the retrieved multi-dimensional data, and presents an instance of the callout report model in a callout interface. In one implementation, the callout interface provides the capability to change the type and the dimensionality of the instance of the callout report model in the callout interface. The callout interface also allows inserting the instance into the data report and to update the data report based on the instance.