SYSTEM AND METHOD FOR BUSINESS INTELLIGENCE DATA TESTING

摘要

Apparatuses, methods, and non-transitory computer readable medium for testing business intelligence data over a communication network include receiving a data mapping file, applicable to a source data repository and a target data repository, and generating data mapping file based on the same. Test cases are generated, based on the data mapping file, and SQL scripts, for execution of the test cases, and executing the SQL scripts on the source data repository and the target data. An online analytical processing (OLAP) cube report for the target data repository is received and the OLAP cube report and a report, which is to be tested, are compared to generate a comparison report. The comparison report is indicative of the fields of the OLAP cube report and the report, which is to be tested, which generated at least one error.

主权项

1. A business intelligence data testing apparatus, for business intelligence data testing, over a communication network, the business intelligence data testing comprising:
a processor; a memory communicatively coupled to the processor, wherein the memory stores processor-executable instructions, which, on execution, cause the processor to:
receive data mapping file, applicable to a source data repository and a target data repository, from the user;generate data mapping file based on the data mapping file template provided by processor;generate test cases and test scripts, for execution of the test cases, based on the data mapping file;execute the SQL scripts on the source data repository and the target data;generate a test results report indicative of the outcome of the execution of the SQL scripts;receive an online analytical processing (OLAP) cube report for the target data repository;compare the OLAP cube report and a report, which is to be tested; andgenerate a comparison report, wherein the comparison report is indicative of the fields of the OLAP cube report and the report, which is to be tested, which generated at least one error.