Report then query capability for a multidimensional database model
View Patent ↗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.
1. A computer implemented method for creating a report using a multidimensional data model and 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 method comprising:
presenting to the user a plurality of reporting objects and metadata objects;
accepting a user input to select at least one reporting object and one metadata object;
parsing a selected reporting objects into layout information and a selected metadata object into data definition information;
using the data definition information to form a deduced set of data;
creating one or more queries based upon the deduced set of data; and
querying a data source with the one or more queries to secure retrieved data associated with the deduced set of data; and
presenting a report based upon the retrieved data and the layout information.
2. The method of claim 1 ,
wherein each reporting object specifies at least one presentation object selected from a vertical table, a horizontal table, a cross table, a graph, a section, a page header, a page footer, and a cross-tab.
3. The method of claim 1 , wherein accepting a user inputs includes dragging and dropping graphical representation of a reporting object in a position relative to one or more other graphically represented reporting objects, where the relative positions between graphically represented reporting objects determines layout information.
4. The method of claim 1 , wherein accepting a user input includes entering instructions into a text editor.
5. The method of claim 1 , wherein accepting a user inputs further comprises generating a report specification, wherein the report specification includes a set of computer program instructions.
6. The method of claim 5 , wherein the set of computer program instructions include XML tags.
7. The method of claim 1 , wherein using the data definition information to form a deduced data set further comprises deducing a physical cube structure.
8. The method of claim 7 , further comprising creating a query based upon the physical cube structure using RDBMS query techniques.
9. The method of claim 7 , further comprising creating a query based upon the physical cube structure using OLAP query techniques.
10. A computer readable storage medium including executable instructions to:
present to a user a plurality of reporting objects and metadata objects;
accept a user input to select at least one reporting object and one metadata object;
parse a selected reporting object into layout information and a selected metadata object into data definition information;
use the data definition information to form a deduced set of data;
create one or more queries based upon the deduced set of data; and
query a data source with the one or more queries to secure retrieved data associated with the deduced set of data; and
present a report based upon the retrieved data and the layout information.
11. The computer readable medium of claim 10 wherein each reporting object specifies at least one presentation object selected from a vertical table, a horizontal table, a cross table, a graph, a section, a page header, a page footer, and a cross-tab.
12. The computer readable medium of claim 10 wherein the executable instructions to use the data definition information include executable instructions to deduce a physical cube structure.
13. The computer readable medium of claim 12 further comprising executable instructions to create a query based upon the physical cube structure.