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

Behavior Changes (9.5.2)

Behavior Changes (9.5.2)

This section describes behavior changes in version 9.5.2.

Jasper Reports

Effective in version 9.5.2, Data Validation Option provides new versions of Jasper reports to support multiple versions of JasperReports server and to fix a known limitation. If you upgrade from a previous version of Data Validation option, you must install the latest Jasper reports.
Previously, you may not have been able to drill down on Jasper reports.

Join Views

Effective in version 9.5.2, the following changes occurred:
  • You can change the alias name for a column in a join view.
  • You can change the order of the columns in the join view.
  • You can select a checkbox in the
    Output Fields
    dialog box to indicate which table columns are output fields in the join view.
Previously, you could not change the alias names or order of the columns in the join view. Also, the
Output Fields
dialog box displayed the available fields and output fields differently.

Properties Area

Effective in version 9.5.2, when you select a PowerCenter source or target in the Navigator, the
Properties
area shows the precision and scale of all columns in the source or target.
Previously, the
Properties
area did not show the precision and scale.

Reports

Effective in version 9.5.2, the header of the Tests Run Vs Tests Passed report shows the report name as Tests Run Vs Tests Passed.
Previously, the report header showed the report name as Test Run Vs Test Passed.

SQL Views

Effective in version 9.5.2, the following changes occurred:
  • The
    SQL Statement
    and
    Comment
    sections of the
    SQL View Editor
    dialog box appear in the right pane and the
    Column Definition
    section appears in the left pane.
  • You can select particular columns to add to the SQL view.
  • You can edit the name, datatype, precision, and scale of each column in the SQL view.
  • You have more space to enter an SQL statement.
Previously, each section was in the opposite pane, you had to add all columns to the SQL view, you couldn't change the names, datatypes, precisions, and scales of the columns, and there was less room to enter an SQL statement.