×

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
First Claim
Patent Images

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.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×