Patent ID: 7203671

Claim:
A method for validating a reporting project of an On-Line Analytical Processing (OLAP) tool, the method comprising the steps of: storing an OLAP project schema definition, the OLAP project schema reflecting data and metadata contained in a data warehouse; storing search code generator code which reflects a set of tests to determine whether a SQL generation engine of the OLAP tool, the OLAP project schema, the data warehouse metadata, and the data warehouse data are valid; querying the OLAP project schema, utilizing the search code generator code, to return query results; generating validation code using the query results, the validation code configured to create a validation report by querying the data warehouse metadata and the data warehouse data; creating the validation report, using the validation code, identifying discrepancies among the SQL generation engine of the OLAP tool, the OLAP project schema, the data warehouse metadata, and the data warehouse data; and outputting the validation report.