Automated relational schema generation within a multidimensional enterprise software system

摘要

Techniques are described for publishing multidimensional data from an enterprise software system. A relational database schema is automatically created for storing the multidimensional data. The database schema may be a relational star schema as described herein. The techniques may include processes for automatically producing the database schema based on the organization of the multidimensional data cube, and for populating the database schema with data from the data cube. The database schema may be used for reporting the multidimensional enterprise data, or may serve as a staging area to move the enterprise data toward a data warehouse within an enterprise software system. The reporting schema may support heterogeneous data types and heterogeneous formats. The reporting schema may also contain metadata that describes the schema, allowing for enhanced interpretation of the database schema. Also described is a process for automatically generating a reporting model from the database schema.