1. A business intelligence data testing apparatus comprising: a processor; and a memory communicatively coupled to the processor, wherein the memory comprises processor-executable instructions stored in the memory, which, on execution by the processor, cause the processor to: generate one or more test cases and one or more test scripts, for execution of the test cases, based on a data mapping file associated with a source data repository and a target data repository; execute the test scripts on the source data repository and the target data repository; generate and output a test results report indicative of the outcome of the execution of the test scripts; receive one or more online analytical processing (OLAP) parameters and generate an OLAP cube report for the target data repository based on the parameters, wherein the OLAP cube report is summarized across one or more dimensions based on contents of the target data repository; compare the OLAP cube report and another report, which is to be tested, based on the test cases to determine when one or more fields in the OLAP cube report do not match one or more corresponding fields in the another report; and generate and output a comparison report based on the comparison, wherein the comparison report indicates the one or more fields of the OLAP cube report, when the determining indicates that the one or more fields in the OLAP cube report do not match the one or more corresponding fields in the another report.
1. A business intelligence data testing apparatus comprising: a processor; and a memory communicatively coupled to the processor, wherein the memory comprises processor-executable instructions stored in the memory, which, on execution by the processor, cause the processor to: generate one or more test cases and one or more test scripts, for execution of the test cases, based on a data mapping file associated with a source data repository and a target data repository; execute the test scripts on the source data repository and the target data repository; generate and output a test results report indicative of the outcome of the execution of the test scripts; receive one or more online analytical processing (OLAP) parameters and generate an OLAP cube report for the target data repository based on the parameters, wherein the OLAP cube report is summarized across one or more dimensions based on contents of the target data repository; compare the OLAP cube report and another report, which is to be tested, based on the test cases to determine when one or more fields in the OLAP cube report do not match one or more corresponding fields in the another report; and generate and output a comparison report based on the comparison, wherein the comparison report indicates the one or more fields of the OLAP cube report, when the determining indicates that the one or more fields in the OLAP cube report do not match the one or more corresponding fields in the another report. 5. The apparatus as claimed in claim 1 , wherein the instructions, on execution by the processor, further cause the processor to: analyze the another report to determine the dimensions of the another report; and generate the OLAP cube report with dimensions corresponding to the determined dimensions of the another report.