Reporting model generation within a multidimensional enterprise software system
First Claim
1. A computer-implemented system comprising:
- a relational database storing multidimensional data in accordance with a relational database schema;
a model generator that produces a reporting model based on the database schema; and
a reporting tool that outputs a report to present the multidimensional data in accordance with the reporting model.
4 Assignments
0 Petitions
Accused Products
Abstract
Techniques are described for automatically generating a reporting model based on a relational database storing multidimensional data in accordance with a relational database schema. A model generator may, for example, produce a base reporting model from the database schema, and subsequently generate a user reporting model by importing the base reporting model. The model generator updates the user reporting model in response to modifications requested by a user, and maintains an activity log to record the modifications. The model generator regenerates the base reporting model and the user reporting model in the event the database schema changes, and reapplies the modifications from the activity log to the user reporting model to automatically update the user reporting model. The database schema may be a relational star schema as described herein.
94 Citations
26 Claims
-
1. A computer-implemented system comprising:
-
a relational database storing multidimensional data in accordance with a relational database schema;
a model generator that produces a reporting model based on the database schema; and
a reporting tool that outputs a report to present the multidimensional data in accordance with the reporting model. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A computer-implemented method comprising:
-
storing multidimensional data in a relational database in accordance with a relational database schema;
generating a reporting model based on the database schema; and
output a report with a reporting tool to present the multidimensional data in accordance with the reporting model. - View Dependent Claims (14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24)
-
-
25. A computer-readable medium comprising instructions to cause a programmable processor to:
-
generate a base reporting model based on a database schema that stores multidimensional data in a relational database;
generate a user reporting model by importing the base reporting model;
update the user reporting model in response to modifications requested by a user;
maintain an activity log to record the requested modifications to the user reporting model;
regenerate the base reporting model to include new definitions in the event the database schema changes;
synchronizing the user reporting model to use the new definitions from the regenerated base reporting model; and
reapply the modifications from the activity log to the user reporting model to automatically update the user reporting model. - View Dependent Claims (26)
-
Specification