Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. Repositories
  4. XML Data Source
  5. Tests for XML Data Sources
  6. Connections
  7. Expressions
  8. Table Pairs
  9. Tests for Table Pairs
  10. Single-Table Constraints
  11. Tests for Single-Table Constraints
  12. Examples of Tests from Spreadsheets
  13. SQL Views
  14. Lookup Views
  15. Join Views
  16. Aggregate Views
  17. Business Intelligence and Reporting Tools Reports
  18. Dashboards
  19. DVOCmd Command Line Program
  20. Troubleshooting
  21. Appendix A: Datatype Reference
  22. Appendix B: Reporting Views
  23. Appendix C: Metadata Import Syntax
  24. Appendix D: Jasper Reports
  25. Appendix E: Glossary

Data Validation Option User Guide

Data Validation Option User Guide

Jasper Report Types

Jasper Report Types

You can generate different Jasper reports in Data Validation Option.
You can generate the following Jasper reports in Data Validation Option:
Summary of Tests Run
Summary of Testing Activities report displays the number of table pairs or single tables, the number of tests for each table pair or single table, and the overall test results.
Table Pair/Table Summary
Lists each table pair or single table with the associated tests. Data Validation Option displays each table pair or single table on a separate page. The report includes a brief description of each test and result.
Detailed Test Result
Displays each test on a separate page with a detailed description of the test definition and results. If one of the test sources is a SQL, join, or a lookup view, the report also displays the view definition.
The following information is available in the Detailed Test Result report:
  • Test details
  • Table pair/single table details
  • Run-time information
  • Bad row details, including information about what causes the bad rows
If the first row of the bad records is null, the Difference and % Difference columns do not appear.
Table Pair/Table Run Summary
Displays the summary of all the tests run for a table pair or single table for a given time period. You can click on the date in the report to view the Detailed Test Results report.
Last Run Summary
Displays the details of the last run of tests at the table pair or single table, folder, or user level. Reports lists the last test runs for the objects in the given time period.
If you generate the report at the user level, the report displays the folder summary. You can click on the folder to view the Last Run Summary report for that folder.
If you generate the report at the folder level or table pair/single table level, you can view the last run for all the table pairs or single tables for the given time period. You can click on a table pair or single table to view the Detailed Test Results report.
Percentage of Bad Rows
Displays the aggregate percentage of bad rows in comparison with all the rows processed over a period of time. You can generate the report at the table pair or single table, folder, or user level. You can click on a bar for a particular date on the graph to view the Bad Rows report.
The bars on the graph appear for the days on which you ran the tests.
Percentage of Tests Passed
Displays the percentage of passed tests in comparison with total number of tests over a period of time. You can generate the report at the table pair or single table, folder, or user level.
The bars on the graph appear for the days on which you ran the tests.
Tests Run Vs Tests Passed
Displays the total number of tests run over a period of time as a bar chart. The number of tests passed is plotted across the bar chart. You can generate the report at the table pair or single table, folder, or user level. You can click on the test passed points on the graph to view the Validation Failure by Day report.
The bars on the graph appear for the days on which you ran the tests.
Total Rows Vs Percentage of Bad Rows
Displays the total number of rows tested over a period of time as a bar chart. The percentage of bad rows is plotted across the bar chart. You can generate the report at the table pair or single table, folder, or user level. You can click on the percentage of bad rows points on the graph to view the Bad Rows report.
The bars on the graph appear for the days on which you ran the tests.
Bad Rows
Displays the number of bad rows across test runs over a period of time in the form of a bar chart. You can click on a bar to view the Table Pair/Table Run Summary report. You can generate the Bad Rows report at the folder level or the table pair/single table level.
Most Recent Failed Runs
Displays the top ten most recent failed runs. You can run the Most Recent Failed Runs report at the folder or user level.
If you run the report at the user level, the report displays the top ten failed runs across all the folders in the Data Validation Option repository in the given time period. If you click on a folder, you can view the Most Recent Failed Runs report for the folder. You can also click on the table pair or single table to view the Detailed Test Result report.
If you run the report at the folder level, the report displays the top ten failed runs for that particular folder in the given time period. You can click on the table pair or single table to view the Detailed Test Result report.
Select the recency as latest if you want to get the most recent state of the table pair or single table.
Failed Runs
Displays the number of failed runs for each table pair or single table over a period of time in the form of a bar chart. Each bar represents the number of failed runs for a table pair or single table. You can click on a bar to view the Table Pair/Table Run Summary report. You can run the Failed Runs report at the folder level.
Failed Tests
Displays the number of failed tests across test runs over a period of time in the form of a bar chart. Each bar represents the number of failed tests for a table pair or single table. If you click the Table hyperlink, you can view the report in a tabular format. You can click on a bar or the table pair/single table name to view the Detailed Test Result report. You can run the Failed Tests report at the folder level.
Validation Failure by Folder
Displays the number of failed table pairs or single table as a bar chart for a given time period. Each bar represents the folder in which the failure occurred. If you click the Table hyperlink, you can view the report in a tabular format. You can click on a bar or the folder name to view the Failed Tests report available as bar chart and tabular format. You can run the Validation Failure by Folder report at the user or folder level.
External IDs Used In Table Pairs
Displays the list of table pairs or single tables with external IDs across all users. You can run the External IDs Used In Table Pairs report at the user, folder, or table pair level.
Sources Used In Table Pairs/Tables/Views
Displays the list of table pairs, single tables, and views in which a data source is used. Right-click on the PowerCenter repository, a repository folder, or a data source in the repository and select Get Source Usage In Table Pairs/Tables/Views to generate this report. You cannot generate a report at the repository folder level or repository level if there are more than 100 sources.
Views Used In Table Pairs/Tables/Views
Displays the list of table pairs and single tables in which a view is used. Right-click on the view and select Get View Usage In Table Pairs/Tables/Views to generate this report.
Data Validation Option reports might display the details of table pairs or single tables that you previously deleted from the Data Validation Client. If you generate a report after you modify the description of a table pair or a single table, the reports might display two entries for the object with the object ID appended to the new and old description with same object ID or in the annotations of the bar chart.