ADVANCED TECHNIQUES FOR SQL GENERATION OF PERFORMANCEPOINT BUSINESS RULES
First Claim
1. A computer-implemented method, comprising:
- receiving a rule defining one or more calculations to be performed on specified data stored in a multidimensional database to yield at least one result;
generating a relational database query seeking the specified data relevant to the rule to be retrieved from the multidimensional database;
creating an intermediary table to accommodate the specified data retrieved from the multidimensional database;
storing the specified data in the intermediary table; and
manipulating the specified data in the intermediary table as specified by the rule to determine the at least one result.
2 Assignments
0 Petitions
Accused Products
Abstract
Computer-implemented methods and computer-readable storage media are disclosed to facilitate the application of business rules. A rule is received, the rule defining one or more calculations to be performed on specified data stored in a multidimensional database to yield at least one result. At least one database query is generated seeking the specified data to be retrieved from the multidimensional database. An intermediary table is created to accommodate the specified data retrieved from the multidimensional database. The specified data is stored in the intermediary table and the specified data is manipulated when the data is retrieved or after the specified data is stored in the intermediary table.
-
Citations
20 Claims
-
1. A computer-implemented method, comprising:
-
receiving a rule defining one or more calculations to be performed on specified data stored in a multidimensional database to yield at least one result; generating a relational database query seeking the specified data relevant to the rule to be retrieved from the multidimensional database; creating an intermediary table to accommodate the specified data retrieved from the multidimensional database; storing the specified data in the intermediary table; and manipulating the specified data in the intermediary table as specified by the rule to determine the at least one result. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A computer-implemented method, comprising:
-
receiving a business rule defining one or more calculations to be performed on specified data stored in a database to yield at least one result; creating at least one intermediary table to accommodate the specified data; generating a plurality of queries for one or more of; retrieving the specified data from the database; and manipulating the specified data by performing a function on the specified data retrieved from the database; storing the specified data in the intermediary table; converting the one or more calculations defined in the business rule into a format adapted to be performed on the specified data as stored in the intermediary table; and performing the one or more calculations on the specified data stored in the intermediary table. - View Dependent Claims (9, 10, 11, 12, 13, 14, 15, 16, 17)
-
-
18. A computer-readable storage media maintaining a plurality of stored computer-executable instructions, the stored instructions comprising instructions for:
-
receiving a business rule defining one or more calculations to be performed on specified data stored in a database to yield at least one result; creating at least one intermediary table to accommodate the specified data; generating a plurality of queries for one or more of; retrieving the specified data from the database; and manipulating the specified data by performing a function on the specified data retrieved from the database; storing the specified data in the intermediary table; and determining the result of the business rule. - View Dependent Claims (19, 20)
-
Specification