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.