Patent ID: 7505888

Claim:
A computer-implemented system comprising: a multidimensional database comprising a data cube storing multidimensional data; a relational database organized in accordance with a relational database schema; a computer-readable medium storing a schema generator, a publish module, a model generator and a reporting tool in the form of software instructions; and a processor executing the schema generator to receive from a user a selection of one or more dimensions from the data cube and, in response, automatically produce the relational database schema for the relational database based on an organization of the multidimensional data within the data cube; wherein the processor executes the publish module to retrieve the multidimensional data from the data cube of the multidimensional database and to store the retrieved multidimensional data within the relational database in accordance with the relational database schema produced by the schema generator, wherein the processor executes the model generator to automatically produce a reporting model based on the relational database schema produced by the schema generator, wherein, for a subsequent publication of the multidimensional data of the multidimensional database, the processor executes the schema generator to update the relational database schema based on the organization of the multidimensional data within the data cube, wherein, in response to undated relational database schema, the processor executes the model generator to regenerate the reporting model, and wherein the processor executes the reporting tool to output a report to present the multidimensional data in accordance with the regenerated reporting model.