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.