User interface method and apparatus for data from data cubes and pivot tables

Abstract

Systems, methods, and computer readable media provide space-efficient user interfaces to data cubes and pivot table information. Because the user interfaces are more efficient in usage of display area, smaller displays can be used more effectively in reviewing such data. The user interfaces provide a multi-dimensional navigation approach among dimensions represented in the data, which allows users to more easily maintain context when reviewing large pivot table reports, and the like. Other user interface features that ease review of such reports on smaller devices also are disclosed.

Description

CROSS-REFERENCE TO RELATED APPLICATIONS[0001]This application is a continuation of U.S. patent application Ser. No. 12 / 197,893, entitled “USER INTERFACE METHOD AND APPARATUS FOR DATA FROM DATA CUBES AND PIVOT TABLES,” filed Aug. 25, 2008, which claims the benefit of U.S. Provisional Application No. 61 / 023,058, entitled “CUBE NAVIGATOR,” filed Jan. 23, 2008, each of which is incorporated herein by reference in its entirety.BACKGROUND OF THE INVENTION[0002]1. Field of the Invention[0003]The invention in general relates to user interfaces for electronic devices, and more particularly to user interfaces for reviewing summarizations of tabular data on electronic devices with smaller displays.[0004]2. Description of the Related Art[0005]A common example of tabular data is a spreadsheet having a plurality of columns, each with a column title indicative of a different data dimension that respectively can have multiple values. Selections of the values are provided in rows, and often a respec...

AI Technical Summary

Problems solved by technology

Because tabular data can have a number of different dimensions associated with many individual entries, it can be difficult to extract meaning and higher-level conclusions from the data.

So without a way to produce summaries of the data for higher-level geographic regions and time spans, it may be difficult to make higher-level conclusions from such data.

Thus, a pivot table can be extremely large.

However, even with all of that extra detail hidden, not much of the pivot table can be viewed at one time, and it is apparent, for example, that data values even for the first year 2006 would not be visible at the same time as the Territory values to which those data values correspond.

In a larger pivot table, all of the above behaviors would become even more problematic for viewing such information on a small display, such as that of a smart phone.

Images