SYSTEM AND METHOD FOR BUSINESS INTELLIGENCE DATA TESTING
First Claim
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; and
generate 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.
1 Assignment
0 Petitions
Accused Products
Abstract
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.
-
Citations
14 Claims
-
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; and generate 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. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A method for data repository report testing, over a communication network, the method comprising:
-
receiving, by a business intelligence data testing apparatus, a data mapping file, applicable to a source data repository and a target data repository, from the user; generating, by the business intelligence data testing apparatus, data transformation rules based on the data mapping file; generating, by the business intelligence data testing apparatus, test cases and test scripts, for execution of the test cases, based on the data transformation rules; executing, by the business intelligence data testing apparatus, the test scripts on the source data repository and the target data; generating, by the business intelligence data testing apparatus, a test results report indicative of the outcome of the execution of the test scripts; receiving, by the business intelligence data testing apparatus, an online analytical processing (OLAP) cube report for the target data repository; comparing, by the business intelligence data testing apparatus, the OLAP cube report and a report, which is to be tested; and generating, by the business intelligence data testing apparatus, 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. - View Dependent Claims (7, 8, 9, 10)
-
-
11. A non-transitory computer readable medium comprising a set of computer executable instructions, which, when executed by a processor causes the processor to perform steps comprising:
-
receiving a data mapping file, applicable to a source data repository and a target data repository, from the user; generating test cases and SQL scripts, for execution of the test cases, based on the data mapping file; executing the test scripts on the source data repository and the target data; generating a test results report indicative of the outcome of the execution of the test scripts; generating an online analytical processing (OLAP) cube report for the target data repository; comparing the OLAP cube report and the report, which is to be tested; and generating 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. - View Dependent Claims (12, 13, 14)
-
Specification