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

Generating a Report

Generating a Report

You can generate a report at the table pair, folder, repository, or user level.
  1. Select the object for which you want to generate a report. You can select multiple of objects of the same type.
  2. Click
    Action
    Generate Report
    .
    The
    Report Parameters
    dialog box appears.
    You can also right-click the object and select Generate Report if you want to generate a report at the table pair or folder level.
  3. Select the report type.
    The following table displays the report options that you can select for each report:
    Report Name
    User
    Recency
    Run Date
    Run Summary
    All Users/Current User/Any User
    All/Latest
    Last 24 hours/Last 30 days/Custom date range
    Table Pair Summary
    All Users/Current User/Any User
    All/Latest
    Last 24 hours/Last 30 days/Custom date range
    Detailed Test Results
    All Users/Current User/Any User
    All/Latest
    Last 24 hours/Last 30 days/Custom date range
    Table Pair Run Summary
    -
    -
    Last 24 hours/Last 30 days/Custom date range
    Last Run Summary
    All Users/Current User/Any User
    -
    Last 24 hours/Last 30 days/Custom date range
    Percentage of Bad Rows
    All Users/Current User/Any User
    All/Latest
    Last 24 hours/Last 30 days/Custom date range
    Percentage of Tests Passed
    All Users/Current User/Any User
    All/Latest
    Last 24 hours/Last 30 days/Custom date range
    Tests Run Vs Tests Passed
    All Users/Current User/Any User
    All/Latest
    Last 24 hours/Last 30 days/Custom date range
    Total Rows Vs Percentage of Bad Rows
    All Users/Current User/Any User
    All/Latest
    Last 24 hours/Last 30 days/Custom date range
    Bad Rows
    -
    All/Latest
    Last 24 hours/Last 30 days/Custom date range
    Most Recent Failed Runs
    All Users/Current User/Any User
    All/Latest
    -
    Failed Runs
    -
    -
    Last 24 hours/Last 30 days/Custom date range
    Failed Tests
    -
    All/Latest
    Last 24 hours/Last 30 days/Custom date range
    Validation Failures
    All Users/Current User/Any User
    All/Latest
    Last 24 hours/Last 30 days/Custom date range
    Table pairs/Tables with External ID
    -
    -
    -
    You can select the user only if you generate the report from the user level.
  4. Optionally, enter the report subtitle.
    You can use the report subtitle to identify a specific report.
  5. To view details of bad records, select
    Show Bad Records Detail
    .
  6. Click
    Run.
    The report appears in the browser.