Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. New Features and Behavior Changes
  4. Repositories
  5. XML Data Source
  6. Tests for XML Data Sources
  7. Connections
  8. Expressions
  9. Table Pairs
  10. Tests for Table Pairs
  11. Single-Table Constraints
  12. Tests for Single-Table Constraints
  13. Examples of Tests from Spreadsheets
  14. SQL Views
  15. Lookup Views
  16. Join Views
  17. Aggregate Views
  18. Business Intelligence and Reporting Tools Reports
  19. Dashboards
  20. DVOCmd Command Line Program
  21. Troubleshooting
  22. Datatype Reference
  23. Reporting Views
  24. Metadata Import Syntax
  25. Jasper Reports
  26. 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.