6. A method for data repository report testing, the method comprising: generating, by the business intelligence data testing apparatus, 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; executing, by the business intelligence data testing apparatus, the test scripts on the source data repository and the target data repository; generating and outputting, by a 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, one or more online analytical processing (OLAP) parameters and generating 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; comparing, by the business intelligence data testing apparatus, 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 generating and outputting, by the business intelligence data testing apparatus, 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.
6. A method for data repository report testing, the method comprising: generating, by the business intelligence data testing apparatus, 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; executing, by the business intelligence data testing apparatus, the test scripts on the source data repository and the target data repository; generating and outputting, by a 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, one or more online analytical processing (OLAP) parameters and generating 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; comparing, by the business intelligence data testing apparatus, 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 generating and outputting, by the business intelligence data testing apparatus, 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. 9. The method as claimed in claim 6 , further comprising: comparing, by the business intelligence data testing apparatus, one or more values of one or more corresponding fields of one or more of the source data repository or the target data repository; determining, by the business intelligence data testing apparatus, at least one data transformation rule based on the comparison; and generating, by the business intelligence data testing apparatus, the test cases or test scripts based on the at least one data transformation rule in the data mapping file.