Worksheet Overview Area for BI Crosstab Navigation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Business Intelligence (BI) tools face challenges in providing an efficient overview of large dimensional crosstabs and charts, as existing interfaces consume significant screen real estate and are confusing, making it difficult for users to navigate and manipulate filter criteria.
Innovation Solution
A system comprising an item information handler, overview element handler, overview area handler, and synchronizer that creates a compact overview area displaying summary information of a worksheet, allowing users to interact with and manipulate data elements without directly accessing the crosstab, and synchronizing changes between the overview area and the worksheet.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If a traditional dimension line or menu is used to show all dimensions at the highest level, then users can access filter criteria, but the interface consumes significant screen real estate and becomes confusing
Solution Approach 1:
The patent segments the dimension line into hierarchical levels (dimension level, category level, member level) and allows users to expand or collapse each level. This segmentation enables the interface to show only relevant information at each level, reducing screen real estate consumption while maintaining accessibility to filter criteria through progressive disclosure.
Solution Approach 2:
The patent implements a nested structure where categories are contained within dimensions, and members are contained within categories. This nesting allows the interface to organize information hierarchically, enabling users to access filter criteria through a compact, tree-like structure that consumes less screen real estate while maintaining full functionality.
2Quantity of substance
If all dimensions are shown at the highest level in the dimension line, then users can see all available filters, but it becomes difficult to locate a desired dimension and the interface is confusing
Solution Approach 1:
The patent segments the dimension line into hierarchical levels (dimension level, category level, member level) and allows users to expand or collapse each level. This segmentation enables the interface to show only relevant information at each level, reducing screen real estate consumption while maintaining accessibility to filter criteria through progressive disclosure.
Solution Approach 2:
The patent applies different display qualities to different levels of the dimension line. Higher-level dimensions can be collapsed to show only summary information, while lower-level categories and members can be expanded when needed. This local quality approach allows the interface to adapt its detail level based on user needs, making it easier to locate desired dimensions without displaying all information at once.
3Loss of information
If a separate container for overall filters is placed above or below the crosstab, then filter information can be displayed, but the interface requires large screen real estate and lacks coherence
Solution Approach 1:
The patent merges the dimension line with the crosstab interface, integrating filter criteria directly into the worksheet structure. This integration eliminates the need for separate containers above or below the crosstab, reducing screen real estate requirements while maintaining coherent layout. The filter criteria are displayed as part of the dimension line, which is already a familiar element of the crosstab interface.
4Adaptability or versatility
If the dimension line shows detailed filter options, then users can manipulate filter criteria, but the interface consumes excessive screen real estate
Solution Approach 1:
The patent makes the dimension line dynamic by allowing users to expand or collapse categories and members based on their needs. The interface can adapt its level of detail in real-time, showing only the necessary filter options when expanded and hiding them when collapsed. This dynamic behavior reduces screen real estate consumption while maintaining full filter manipulation capability when needed.
Solution Approach 2:
The patent segments the dimension line into hierarchical levels (dimension level, category level, member level) and allows users to expand or collapse each level. This segmentation enables the interface to show only relevant information at each level, reducing screen real estate consumption while maintaining accessibility to filter criteria through progressive disclosure.
Data Source
AI summary
A worksheet overview system comprises an item information handler, an overview element handler, an overview area handler, and an overview synchronizer. The item information handler obtains item information relating to items of a worksheet. The overview element handler manages overview elements based on the item information. Each overview element represents item information of a corresponding item of the worksheet. The overview area handler provides an overview area for containing the overview elements to make the overview elements contained in the overview area accessible by a user. The overview synchronizer synchronizes between each overview element in the overview area and its corresponding item of the worksheet.