Patent ID: 7631005
Filing Date: 2009-12-08
Classification: G06F,Y10S

Abstract:
1. A method for displaying source data in a two-dimensional grid in a user interface, the source data having four or more dimensions, the method comprising: for each column of a plurality of columns of a table that contains the source data, retrieving a count of distinct values; selecting a set of columns, from said plurality of columns, that have a medium count of distinct values; generating one or more orthogonality indices by performing the following steps for each column in the set of columns: using said one or more orthogonality indices to determine zones of orthogonality; receiving a selection for axes of the grid, said selection for axes including a range of values for each of two of said four or more dimensions; receiving a selection for a cell view of the grid, said selection for said cell view including one of said four or more dimensions not chosen in said selection for axes; receiving a selection for slicer views of the grid, said selection for slicer views including a range of values for one or more of said four or more dimensions not chosen in said selection for axes or said selection for said cell view; determining rows and columns of the grid suitable for displaying as cell views based, at least in part, on a density level corresponding to each of the zones of orthogonality; displaying values of said selection for a cell view contained in said source data for values of said selection for axes of the grid corresponding to said cell, wherein said values are filtered based upon said range of values in said selection for slicer views.