Database report generation
First Claim
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.
4 Assignments
0 Petitions
Accused Products
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.
-
Citations
18 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. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
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. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
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. - View Dependent Claims (14, 15, 16, 17, 18)
-
Specification