Database report generation

• US 7,970,783 B2
• Filed: 11/02/2007
• Issued: 06/28/2011
• Est. Priority Date: 04/29/2003
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Potter, Charles Michael, Seeds, Glen Michael, Cazemier, Henk
• Primary Examiner(s): Ali; Mohammad
• Assistant Examiner(s): Darno; Patrick A
• Application Number:
  US11/934,442
• Publication Number:
  US 20080126326A1
• Time in Patent Office: 1,334 Days
• Field of Search: 707/760
• US Class Current: 707/760
• CPC Class Codes: G06F 16/2457 with adaptation to user needs
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 9/454 Multi-language systems; Localisation; Internationalisation
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

A system and method of producing a business report from data contained in a computer based business intelligence system, is provided. The method includes defining one or more macro functions, and producing a report layout containing one or more macrotized database language expressions. The macrotized database language expression having at least one of the macro functions. The method includes produce one or more valid database language expressions for a database query by modifying the one or more macrotized database language expressions in dependence upon the return value of the at least one of the macro functions, and applying the one or more valid database language expressions to one or more database to produce the business report.

Claims

1. A method of producing a business report from data contained in a computer based business intelligence system, the method comprising:

defining one or more macro functions to prompt for user inputs and accept the user inputs during execution of the one or more macro functions;

producing a report layout containing one or more macrotized database language expressions, the one or more macrotized database language expressions having at least one of the macro functions and one or more partial expressions;

producing, by a computer, one or more valid database language expressions for a database query by at least modifying the one or more macrotized database language expressions of the report layout, wherein the one or more macrotized database language expressions are modified upon a return value of the at least one of the macro functions, and wherein the return value of the at least one of the macros functions includes at least one of the user inputs accepted during execution of the one or more macro functions; and

applying the one or more valid database language expressions to one or more databases to produce the business report, wherein the business report is based on the report layout.

2. The method of claim 1, further comprising:

defining a parameter map having one or more keys and one or more field names, the one or more keys being associated with the one or more field names;

the at least one of the macro functions being associated with the parameter map.

3. The method of claim 2, wherein producing the report layout comprises:

selecting an entry from the parameter map based on the evaluation of the at least one of the macro functions.

4. The method of claim 1, wherein applying comprises:

retrieving the data from the one or more databases based on the one or more valid database language expressions.

5. The method of claim 1, further comprising:

generating a string based on the at least one of the user inputs accepted during execution of the one or more macro functions, wherein the one or more macrotized database language expressions are modified based upon the return value of the at least one of the macro functions by at least substituting a partial expression included within the one or more macrotized database language expressions with the generated string to produce the one or more valid database language expressions for the database query.

6. The method of claim 1, wherein the user inputs include at least one of a set of user-selected prompt responses, an indication or a language in which to produce a business report, and database connection information.

7. A computer-readable storage medium encoded with instructions for causing one or more programmable processors to:

define one or more macro functions to prompt for user inputs and accept the user inputs during execution of the one or more macro functions;

produce a report layout containing one or more macrotized database language expressions, the one or more macrotized database language expressions having at least one of the macro functions;

produce one or more valid database language expressions for a database query by at least modifying the one or more macrotized database language expressions of the report layout, wherein the one or more macrotized database language expressions are modified based upon a return value of the at least one of the macro functions, and wherein the return value of the at least one of the macro functions includes at least one of the user inputs accepted during execution of the one or more macro functions; and

apply the one or more valid database language expressions to one or more databases to produce the business report, wherein the business report is based on the report layout.

8. The computer-readable storage medium of claim 7, further encoded with instructions that cause the one or more programmable processors to:

define a parameter map having one or more keys and one or more field names, the one or more keys being associated with the one or more field names;

the at least one of the macro functions being associated with the parameter map.

9. The computer-readable storage medium of claim 8, further encoded with instructions that cause the one or more programmable processors to:

select an entry from the parameter map based on the evaluation of the at least one of the macro functions.

10. The computer-readable storage medium of claim 7, further encoded with instructions that cause the one or more programmable processors to:

retrieve the data from the one or more databases based on the one or more valid database language expressions.

11. The computer-readable storage medium of claim 7, further encoded with instructions that cause the one or more programmable processors to:

generate a string based on the at least one of the user inputs accepted during execution of the one or more macro functions, wherein the one or more macrotized database language expressions are modified based upon the return value of the at least one of the macro functions by at least substituting a partial expression included within the one or more macrotized database language expressions with the generated string to produce the one or more valid database language expressions for the database query.

12. The computer-readable storage medium of claim 7, wherein the user inputs include at least one of a set of user-selected prompt responses, an indication of a language in which to produce a business report, and database connection information.

13. A business intelligence system comprising:

a computer;

one or more data sources configured to store business intelligence data;

a metadata model configured to store model objects, wherein the model objects represent the data sources, and wherein the model objects include macrotized database language expressions, the macrotized database language expressions having a set of macro functions, wherein the at least one macro function is defined to prompt for user inputs and accept the user inputs during execution of the one or more macro functions; and

a query engine executable on the computer, wherein the query engine is configured to translate the macrotized database language expressions into a set of valid database language expressions based on a return value of at least a first macro function of the set of macro functions, wherein the return value of the at least one of the macro functions includes at least one of the user inputs accepted during execution of the one or more macro functions.

14. The business intelligence system of claim 13, wherein the metadata model is further configured to store a parameter map having one or more keys and one or more field names, the one or more keys being associated with the one or more field names, and the at least one of the macro functions being associated with the parameter map.

15. The business intelligence system of claim 14, wherein the query engine is further configured to select an entry from the parameter map based on the evaluation of the at least one of the macro functions.

16. The business intelligence system of claim 13, wherein the query engine is further configured to retrieve the data from the one or more data sources based on the one or more valid database language expressions.

17. The business intelligence system of claim 13, wherein the query engine is further configured to generate a string based on the at least one of the user inputs accepted during execution of the one or more macro functions, and wherein the one or more macrotized database language expressions are modified based upon the return value of the at least one of the macro functions by at least substituting a partial expression included within the one or more macrotized database language expressions with the generated string to produce the one or more valid database language expressions for the database query.

18. The business intelligence system of claim 13, wherein the user inputs include at least one of a set of user-selected prompt responses, an indication of a language in which to produce a business report, and database connection information.