System and method for validating the technical correctness of an OLAP reporting project

摘要

A system, method and computer program product for validating the technical correctness of an On-Line Analytical Processing (OLAP) reporting project is provided such that the likelihood of errors is systematically reduced. The method and computer program product is a proactive, repeatable methodology to prove or disprove the “correctness” of any OLAP reporting project. The present invention helps assure the correctness of the OLAP reporting project by reducing the likelihood that major design and data components within the OLAP application environment are not synchronized. That is, the present invention identifies discrepancies among the OLAP tool, the OLAP project schema, the data warehouse metadata and the data warehouse data, thus identifying potential errors which could occur as a result of those discrepancies.