User interface for pivot views

A non-transitory machine readable medium storing one or more sequences of instructions for enabling a digital processing system to display pivot views from data stored in base tables, wherein execution of said one or more instructions by one or more processors contained in said digital processing system causes said digital processing system to perform the actions of:

• displaying a pivot chart of said first pivot view;
• enabling a user to modify the axis for the pivot chart;
• and
• sending an updated chart for display, corresponding to the modified axis.

A digital processing system for generating pivot views based on a base table of a relational database, said digital processing system comprising:

• a memory storing instructions;
• a processor to retrieve said instructions from said memory and execute the retrieved instructions, wherein execution of said instructions causes said digital processing system to perform the actions of:
• executing on said relational database, a first query containing a GROUP BY construct of all of a plurality of axis fields defining a first pivot view to identify a first set of rows having unique combinations of axis values for said axis fields in said base table;
• identifying unique values in said first set of rows for each of said plurality of axis fields, wherein each combination of unique values for the respective axis fields defines a corresponding position in said cell set;
• executing on said relational database, a second query containing a GROUPBY on a set of fields, wherein said set of fields contains a respective ROLLUP construct on the axis fields at the lowest level of hierarchy in each dimension and the remaining ones of said plurality of axis fields, wherein execution of said second query generates a corresponding set of aggregate values;
• assigning to each position of said cell set a corresponding aggregated value generated by said second query to form said first pivot view;
• and
• displaying said first pivot view.