CLIAMS:We claim:
1. A business intelligence data testing system, 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.
2. The business intelligence data testing system as claimed in claim 1, wherein the instructions, on execution, further cause the processor to:
generate a data mapping file template;
prompt the user to provide values of parameters in the data mapping file template; and
generate the data mapping file based on the user provided values.

3. The business intelligence data testing system as claimed in claim 1, wherein the instructions, on execution, further cause the processor to create SQL scripts on validating the data transformation mapping file based on at least one of schemas of the source data repository and the target data repository, user input and the data transformation rules.

4. The business intelligence data testing system as claimed in claim 1, wherein the instructions, on execution, further causes the processor to:
generate test cases compare values of the corresponding fields of the source repository and the target repository;
determine at least one data mapping file based on the comparison; and
generate test cases and test scripts based on the at least one data mapping file or direct mapping between the source and target columns.

5. The business intelligence data testing system as claimed in claim 1, wherein the instructions, on execution, further cause the processor to:
analyze a report, which is to be tested, to determine the dimensions of the report, which is to be tested; and
generate an OLAP cube report with dimensions corresponding to the determined dimensions of the report, which is to be tested.
6. A computer implemented method for data repository report testing, over a communication network, the method comprising:
receiving, by a business intelligence data testing system, 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 system, data transformation rules based on the data mapping file;
generating, by the business intelligence data testing system, test cases and test scripts, for execution of the test cases, based on the data transformation rules;
executing, by the business intelligence data testing system, the test scripts on the source data repository and the target data;
generating, by the business intelligence data testing system, a test results report indicative of the outcome of the execution of the test scripts;
receiving, by the business intelligence data testing system, an online analytical processing (OLAP) cube report for the target data repository;
comparing, by the business intelligence data testing system, the OLAP cube report and a report, which is to be tested; and
generating, by the business intelligence data testing system, 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.

7. The method as claimed in claim 6, wherein the method further comprises:
generating, by the business intelligence data testing system, a data mapping file template;
prompting, by the business intelligence data testing system, the user to provide values of parameters in the data mapping file template; and
generating, by the business intelligence data testing system, the data mapping file based on the user provided values.

8. The method as claimed in claim 6, wherein the method further comprises creating, by the business intelligence data testing system, test scripts on validating the data transformation mapping file based on at least one of schemas of the source data repository and the target data repository, user input and the data transformation rules.

9. The method as claimed in claim 6, wherein the analyzing the data transformation specification further comprises:
comparing, by the business intelligence data testing system, values of the corresponding fields of the source repository and the target repository;
determining, by the business intelligence data testing system, at least one data transformation rule based on the comparison; and
generating, by the business intelligence data testing system, test cases and test scripts based on the at least one data transformation rule.

10. The method as claimed in claim 6, wherein the execution of the test cases and the test scripts further comprise:
analyzing, by the business intelligence data testing system, the report, which is to be tested, to determine the dimensions of the report, which is to be tested; and
generating, by the business intelligence data testing system, an OLAP cube report with dimensions corresponding to the determined dimensions of the report, which is to be tested.

11. A non-transitory computer readable medium comprising a set of computer executable instructions, which, when executed on a computing system causes the computing system to perform the steps of:
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.
12. The non-transitory computer readable medium as claimed in claim 11, wherein the set of computer executable instructions, which, when executed on the computing system causes the computing system to further perform the steps of:
generating a data mapping file template;
prompting the user to provide values of parameters in the data mapping file template; and
generating the data mapping file based on the user provided values.

13. The non-transitory computer readable medium as claimed in claim 11, wherein the set of computer executable instructions, which, when executed on the computing system causes the computing system to further perform the steps of creating test scripts on validating the data transformation mapping file based on at least one of schemas of the source data repository and the target data repository, user input and the data transformation rules.

14. The non-transitory computer readable medium as claimed in claim 11, wherein the set of computer executable instructions, which, when executed on the computing system causes the computing system to further perform the steps of:
comparing values of the corresponding fields of the source repository and the target repository;
determining at least one data transformation rule based on the comparison; and
generating test cases and test scripts based on the at least one data transformation rule.
Dated this 25th day of March, 2014

MADHUSUDAN S.T.
OF K & S PARTNERS
ATTORNEY FOR THE APPLICANTS
,TagSPECI:FIELD OF THE INVENTION
The present subject matter is related, in general to data processing and, in particular, but not exclusively to a method and system for testing business intelligence data.