Report validation tool

• US 7,636,902 B1
• Filed: 12/15/2006
• Issued: 12/22/2009
• Est. Priority Date: 12/15/2006
• Status: Expired due to Fees

• Current Assignee: T-Mobile Innovations LLC (Deutsche Telekom AG)
• Original Assignee: Sprint Communications Company LP (Deutsche Telekom AG)
• Inventors: Crittenden, Forest V.
• Primary Examiner(s): ROSSOSHEK, YELENA
• Application Number:
  US11/611,735
• Time in Patent Office: 1,103 Days
• Field of Search: 716/1, 716/4, 716/2, 716/3, 716/18, 705/1, 705/2, 705/7, 705/8, 705/10, 705/27, 705/34, 707/2, 707/3, 715/765, 717/124, 717/126, 717/127, 717/135
• US Class Current: 716/104
• CPC Class Codes: G06Q 10/00 Administration; Management
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A computer implemented method for validating reports is provided. A request to validate a report is received. At least one element of the report is mapped to a corresponding template of independently defined logic. At least one corresponding template of independently defined logic is applied to a system of record to generate data. Comparisons of the at least one element against the data are displayed.

Claims

1. A computer implemented method for validating reports, comprising:

Receiving, with a report checker stored as a set of computer executable instructions in a computer readable storage media executable by a processor, a request to validate a report generated from data contained in a system of record;

mapping with the report checker at least one element of the report to a template of independently defined logic;

applying with the report checker the template of independently defined logic to the data contained in the system of record to generate an expected result for the at least one element of the report;

determining with the report checker whether the at least one element of the report differs from the expected result for the at least one element of the report; and

displaying with the report checker comparisons of the at least one element against the expected result when the at least one element of the report differs from the expected result, wherein displaying comparisons includes information identifying a location within the report from which the at least one element corresponds.

2. The computer implemented method of claim 1 wherein the at least one element consists of at least one element selected for validation.

3. The computer implemented method of claim 1 wherein displaying comparisons of the at least one element against the expected result consists of displaying comparisons of the at least one element against the expected result for comparisons that exceed a comparison tolerance.

4. The computer implemented method of claim 1 further comprising offering the corresponding template of independently defined logic to a report manager.

5. The computer implemented method of claim 1 wherein displaying comparisons of the at least one element against the data comprises displaying information used to generate the expected result.

6. The computer implemented method of claim 1 wherein the corresponding template of independently defined logic comprises instructions native to the system of record.

7. The computer implemented method of claim 6 wherein the instructions comprise structured query language.

8. A computer implemented system for validating reports, comprising:

a memory; and

a processor configured to execute report checker software in the memory, where the report checker is configured;

to receive a request to validate a report generated from data contained in a system of record,

map at least one element of the report to a template of independently defined logic,

apply the template of independently defined logic to the data contained in the system of record to generate an expected result for the at least one element of the report;

determine whether the at least one element of the report differs from the expected result for the at least one element of the report; and

display comparisons of the at least one element against the expected result when the at least one element of the report differs from the expected result, wherein displaying comparisons includes information identifying a location within the report from which the at least one element corresponds.

9. The computer implemented system of claim 8 wherein the at least one element consists of at least one element selected for validation.

10. The computer implemented system of claim 8 wherein the data manager only displays comparisons of the at least one element against the expected result for comparisons that exceed a comparison tolerance.

11. The computer implemented system of claim 8 wherein the data manager is further operable to offer the corresponding template of independently defined logic to a report manager.

12. The computer implemented system of claim 8 wherein the data manager is further operable to display information used to generate the expected result.

13. The computer implemented system of claim 8 wherein the corresponding template of independently defined logic comprises instructions native to the system of record.

14. The computer implemented system of claim 13 wherein the independently defined logic comprises pre-defined logic.

15. A computer program product for validating reports, the computer program product comprising:

a computer readable medium having computer readable program code embodied therein;

computer readable program code configured to receive a request to validate a report generated from data contained in a system of record,

computer readable program code configured to map at least one element of the report to a template of independently defined logic,

computer readable program code configured to apply the template of independently defined logic to the data contained in the system of record to generate an expected result for the at least one element of the report;

computer readable program code configured to determine whether the at least one element of the report differs from the expected result for the at least one element of the report; and

computer readable program code configured to display comparisons of the at least one element against the expected result when the at least one element of the report differs from the expected result, wherein displaying comparisons includes information identifying a location within the report from which the at least one element corresponds.

16. The computer program product of claim 15 wherein the computer readable program code configured to display comparisons of the at least one element against the expected result consists of computer readable program code configured to display comparisons of the at least one element against the expected result for comparisons that exceed a comparison tolerance.

17. The computer program product of claim 15 wherein the at least one element consists of at least one element selected for validation.

18. The computer program product of claim 15 further comprising computer readable program code configured to offer the corresponding template of independently defined logic to a report manager.

19. The computer program product of claim 15 wherein the computer readable program code configured to display comparisons of the at least one element against the data consists of computer readable program code configured to display information used to generate the expected result.

20. The computer implemented method of claim 15 wherein the corresponding template of independently defined logic comprises instructions native to the system of record.