Patent ID: 6925630

Claim:
A computer-implemented method for generating code for loading a multi-dimensional data warehouse from a plurality of source databases, the method comprising the steps: (a) defining the multi-dimensional data warehouse and the source databases as a set of entity-relationship data models; (b) creating a source file containing instructions for loading the multi-dimensional data warehouse from the plurality of source databases, the instructions including a plurality of high-level directives, said high-level directives including an aggregation directive specifying that data from a specified source table within said source database is to be aggregated into a specified destination table within said data warehouse; (c) automatically pre-processing said aggregation directive by (i) accessing said data models to pull information from said entity-relationship data models about the structures of said source table and said destination table, and (ii) using said information to generate code for aggregating data from the source table into the destination table; and (d) appending said code to an executable destination file.