REPORT THEN QUERY CAPABILITY FOR A MULTIDIMENSIONAL DATABASE MODEL

• US 20070088689A1
• Filed: 11/27/2006
• Published: 04/19/2007
• Est. Priority Date: 04/03/2000
• Status: Active Grant

• Current Assignee: Business Objects Incorporated (SAP SE)
• Original Assignee: Business Objects SA (SAP SE)
• Inventors: POLO-MALOUVIER, Ricardo, BIESTRO, Henri, CRAS, Jean-Yves
• Granted Patent: US 7,945,597 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: Y10S 707/917 Text
• CPC Class Codes: Y10S 707/957 Multidimensional
• CPC Class Codes: Y10S 707/958 Data cubes
• CPC Class Codes: Y10S 707/96 Object-relational
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

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.

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.

2-15. -15. (canceled)