SYSTEM AND METHOD FOR BUSINESS INTELLIGENCE DATA TESTING

• US 20150278393A1
• Filed: 05/07/2014
• Published: 10/01/2015
• Est. Priority Date: 03/25/2014
• Status: Active Grant

• Current Assignee: Wipro Limited
• Original Assignee: Wipro Limited
• Inventors: Das, Prabhakar, Ganesh, Lakshmi
• Granted Patent: US 9,710,528 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 11/3684 for test design, e.g. generating new test cases
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06Q 10/00 Administration; Management
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/06395 Quality analysis or management

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.

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.

2. The apparatus 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 apparatus 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 apparatus 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 apparatus 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 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.

7. The method as claimed in claim 6, wherein the method further comprises:

generating, by the business intelligence data testing apparatus, a data mapping file template;

prompting, by the business intelligence data testing apparatus, the user to provide values of parameters in the data mapping file template; and

generating, by the business intelligence data testing apparatus, 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 apparatus, 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 apparatus, values of the corresponding fields of the source repository and the target 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, 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 apparatus, 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 apparatus, 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 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.

12. The non-transitory computer readable medium as claimed in claim 11, further comprising:

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, further comprising 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, further comprising:

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.