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 Tests for a Table Pair from a Spreadsheet

Generating Tests for a Table Pair from a Spreadsheet

Data Validation Option can generate table-pair tests based on test definitions in a spreadsheet. To generate the tests, export the existing tests, add tests to the spreadsheet, and then import the tests from the spreadsheet into Data Validation Option.
  1. In the Navigator, right-click the table pair and select
    Export Tests to Spreadsheet
    .
    The
    Save As
    dialog box appears.
  2. Save the spreadsheet to a location that the Data Validation Client can access.
  3. Open the spreadsheet.
    The spreadsheet shows the existing table-pair test definitions if tests exist.
    The Excel spreadsheet shows tests defined for the table pair. The spreadsheet shows the following test properties: test function, fields, expressions, datatypes, precisions, scales, and operator.
  4. Add tests for the table pair.
    Verify that the content in the spreadsheet meets the spreadsheet requirements.
  5. Save and close the spreadsheet file.
  6. In the Navigator, right-click the table pair, and click
    Generate Tests from Spreadsheet
    .
    The
    Generate Tests
    dialog box appears.
  7. Click
    Browse
    and select the spreadsheet.
    The
    Generate Tests
    dialog box previews the tests to be generated and shows any errors. A red circle icon indicates that the row has an error. A yellow triangle icon next to a cell indicates that the value of the cell has an error.
  8. If a test has an error, select the test row with the error to preview the error.
    The error appears at the bottom of the
    Generate Tests
    dialog box.
    The dialog box shows the name and location of the spreadsheet file, test definitions, and an error.
  9. Resolve the error or remove the test.
  10. To change a test property, select the property in the
    Generate Tests
    dialog box and then make the change.
  11. To remove a test, select the test row and click
    Remove
    .
  12. To add a test, click
    Add
    and enter the test properties.
  13. Click
    Save
    to import the tests.