Analytical reporting on top of multidimensional data model
First Claim
1. 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.
2 Assignments
0 Petitions
Accused Products
Abstract
An analytical reporting functionality provides full-fledged dynamic reporting capabilities on top of a multidimensional data model. A GUI facilitates replicating the same reporting data for various elements of a dimension. Additionally, direct interaction with the report to perform OLAP-style is enabled.
54 Citations
6 Claims
-
1. 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. - View Dependent Claims (4, 5)
-
-
2. The method of claim further comprising the acts of:
-
displaying an analysis user interface;
selecting a cell of said reporting object; and
utilizing a GUI tool to select an OLAP analysis action to be performed on the cell. - View Dependent Claims (3)
-
-
6. A computer program product 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:
a computer readable medium having program code embodied therein, said program code further comprising;
program code executed by the processor for displaying a reporting object the displays values selected by one or more axes of the multidimensional data model;
program code executed by the processor for 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;
program code executed by the processor for enabling using the user interface to associate a first dimension object with the reporting object; and
program code executed by the processor for 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.
Specification