Patent ID: 6831668
Filing Date: 2004-12-14
Classification: G06F,Y10S

Abstract:
A method for performing analytical reporting on top of a multidimensional data model built on top of a relational or multidimensional database, wherein the database operates in a computer system and provides returned values responsive to queries specified in a predefined query language, wherein the database supports the use of functions and operators to perform operations on values within the database, wherein the multidimensional data model includes a plurality dimensions organizing data as sets of values organized in a hypercube, wherein the method includes a user interface executing on a computer system operated by a human user, wherein the computer system executing the user interface includes a processor coupled to a memory, wherein the processor is further coupled to the user interface, data model, and the database, the method comprising the following acts:displaying a reporting object that displays values selected by one or more axes of the multidimensional data model; displaying a hierarchical view of at least a part of a hypercube in the multidimensional data model showing dimensions and dimension members of the hypercube; using the user interface to associate a first dimension object with the reporting object; and displaying a set of reporting objects, each corresponding to a member of the dimension, where the reporting object displays values of measures of the corresponding dimension member including multiple blocks synchronized along a common axis, nested sections, and breaks.