Report then query capability for a multidimensional database model
First Claim
1. A method for creating an analytical report using a multidimensional data model and a database, wherein a computer system accesses the database to provide returned values responsive to queries specified in a predefined query language, wherein the multidimensional data model includes a plurality of dimensions organizing data as sets of values organized in a multidimensional cube structure, 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:
- presenting to the user a plurality of selections associated with reporting objects;
accepting a user input to select at least one reporting object;
parsing the selected reporting objects into layout information and data definition information;
using the data definition information to deduce a set of data;
creating one or more queries based upon the deduced set of data; and
querying a data source to retrieve data associated with the deduced set of data.
1 Assignment
0 Petitions
Accused Products
Abstract
A system and a method for creating an analytical report on top of a multidimensional data model built on top of a relational or multidimensional database. The database operates in a computer system and provides returned values responsive to queries. Such a query is generated automatically and is deduced from a report definition. According to one embodiment, a report specification is used by the system and method of the present invention is able to defer the initial query of the data source, as is the case with conventional reporting tools and methods, until after the report has been defined. That is, the manner in which a analytic report is defined provides for an automatically generated query. Once the report has been defined, the data to populate such a report is retrieved to build the document.
-
Citations
15 Claims
-
1. A method for creating an analytical report using a multidimensional data model and a database, wherein a computer system accesses the database to provide returned values responsive to queries specified in a predefined query language, wherein the multidimensional data model includes a plurality of dimensions organizing data as sets of values organized in a multidimensional cube structure, 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:
-
presenting to the user a plurality of selections associated with reporting objects;
accepting a user input to select at least one reporting object;
parsing the selected reporting objects into layout information and data definition information;
using the data definition information to deduce a set of data;
creating one or more queries based upon the deduced set of data; and
querying a data source to retrieve data associated with the deduced set of data. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A system for creating an analytical report using a multidimensional data model to access a database, wherein the multidimensional data model includes a plurality of dimensions organizing data as sets of values organized in a multidimensional cube structure, the system comprising:
-
a reporting engine configured to receive a report specification from a client computing device;
a cube configured to receive a data source query from the report engine, where the cube is configured to generate one or more queries; and
a data source configured to receive the one or more queries, wherein the cube generates the query automatically based upon the data source query. - View Dependent Claims (12, 14, 15)
-
-
13. A computer product of the type comprising a computer readable medium that contains a program to create an analytical report 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 multidimensional data model includes a plurality dimensions organizing data as sets of values organized in a multidimensional cube structure, wherein the computer readable medium controls 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 computer product comprising:
-
computer code to present to the user a plurality of selections, where each of the plurality of selections is associated with a reporting object;
computer code to accepting user inputs, where the inputs include a subset of the plurality of selections;
computer code to generate a report specification computer program, where the report specification includes layout information and data definition information; and
computer code to initiate a method of generating an automatic query comprising;
parsing the report specification into layout information and data definition information;
using the data definition information to deduce a set of data;
creating one or more queries based upon the deduced set of data; and
querying a data source to retrieve data associated with the deduced set of data.
-
Specification