Visualizing Overlapping Range-Bands in Multi-Dimensional Tables

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing methods fail to effectively display and visualize the overlap of multiple range-bands in a multi-dimensional table, typically showing only a single default range-band, which limits the user's ability to identify trends and values across row, column, and global dimensions.

Innovation Solution

A computer-implemented method that generates and displays column, row, and global range-bands simultaneously by using a range-banding module to apply visual indicators such as color, texture, or shading to cells, allowing for the intersection and overlap of these bands within a shared cell, with the GUI module displaying the data in a table format.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Loss of information

If multiple range-bands are applied to the same cell, then the information completeness is improved, but the visual clarity deteriorates due to overlapping indicators

Engineering Contradiction:
Improveinformation completenessVSAvoidvisual clarity
Core Design Contradiction:
Loss of informationVSDifficulty of detecting and measuring

Solution Approach 1:

The patent segments the cell into multiple distinct visual regions, with each region displaying a different range-band indicator. This segmentation allows multiple range-bands to be displayed simultaneously without overlapping, maintaining visual clarity while preserving information completeness. Each segment is clearly demarcated, enabling users to distinguish between different range-band applications (row, column, and global) within the same cell.

Inventive Principle:
Principle #1Segmentation

2Difficulty of detecting and measuring

If a single default range-band is selected for display, then the visual clarity is improved, but the information completeness deteriorates

Engineering Contradiction:
Improvevisual clarityVSAvoidinformation completeness
Core Design Contradiction:
Difficulty of detecting and measuringVSLoss of information

Solution Approach 1:

The patent merges multiple range-band indicators into a single cell display by dividing the cell into segments. Each segment contains a different range-band indicator (row, column, or global), allowing all three types of range-bands to be displayed simultaneously. This merging approach preserves information completeness while maintaining visual clarity through systematic organization of multiple indicators within the cell boundaries.

Inventive Principle:
Principle #5Merging (Combining)

Data Source

PatentUS7707489B2Apparatus and method for visualizing overlapping range-bands
Publication Date: 2010.04.27 BUSINESS OBJECTS
  • US7707489B2 patent drawing
  • US7707489B2 patent drawing
  • US7707489B2 patent drawing

AI summary

A computer implemented method includes forming column range-bands, generating row range-bands, and establishing global range-bands in conjunction with the column range-bands and the row range-bands.