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

Dashboard Types

Dashboard Types

You can view the following dashboards in Data Validation Option:
DVO Home Dashboard
Displays the following reports for the past 30 days:
  • Tests Run Vs Tests Passed
  • Total Rows vs Percentage of Bad Rows
  • Percentage of Tests Passed
  • Percentage of Bad Rows
You can click through the Total Rows vs Percentage of Bad Rows report and Percentage of Bad Rows reports to view the Bad Rows report. You can click through Tests Run Vs Tests Passed to view the Validation Failures report.
Repository Dashboard
Displays the Validation Failures for Folders report for the past 24 hours and 30 days in both graphical and tabular formats. The dashboard also displays the Most Recent Failed Runs report for the repository.
You can click through the Validation Failure by Folder report to view the Failed Tests report. You can click through the Most Recent Failed Runs report to view the Most Recent Failed Runs report for a folder and the Detailed Test Result report.
Folder Dashboard
Displays the Bad Rows report and Failed Tests report for the past 24 hours and 30 days in both graphical and tabular formats.
You can click through the Failed Tests report to view the Table Pair/Table report and the Bad Rows report to view the Detailed Test Result report.
Table Dashboard
The Table dashboard displays the following reports for the past 30 days:
  • Tests Passed Vs Test Failed
  • Bad Rows
  • Table Pair/Table Run Summary
You can click through the Bad Rows report to view the contents to view the Detailed Test Result report.