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. Datatype Reference
  22. Reporting Views
  23. Metadata Import Syntax
  24. Jasper Reports
  25. Glossary

Data Validation Option User Guide

Data Validation Option User Guide

Adding an Aggregate View

Adding an Aggregate View

You can add an aggregate view to create a view on multiple tables in the same database.
  1. Click
    File
    New
    Aggregate View
    .
    The
    Aggregate View Editor
    dialog box appears.
  2. Enter a description for the aggregate view.
  3. Click
    Browse
    in the
    Select Table
    field.
    The
    Choose Data Source
    dialog box appears. This dialog box displays the sources available in the repositories. You can sort information in this dialog box by clicking the column headers. You can reduce the number of items to select by typing one or more letters of the table, file, or view name in the Search field.
  4. Select a table and click
    Select
    .
    To filter the available tables, enter a search string in the
    Search
    field.
  5. Select a connection to the source that contains the tables included in the aggregate view.
    If you select file source, select the source directory, file name, and file type in the
    Select Connection for Table
    area.
  6. Select a group name if you use an XML, a PowerExchange for IMS, COBOL, or VSAM data source.
    Only child elements of the XML group are available for use in the column definition of the aggregate view clause, table join field, and tests.
  7. Specify an expression in the WHERE clause to filter the records. Filter the records to increase test performance.
    If the data source is relational, Salesforce, SAP, or SAS, enable
    Execute Where Clause in DB
    if you want the data source to process the WHERE clause.
  8. Specify the optimization level.
    By default, Data Validation Option uses
    Default
    optimization, which sorts the source data.
  9. To add columns from the tables to the aggregate view, click
    Select Columns
    in the
    Column Definition
    area.
    The
    Output Fields
    dialog box appears.
  10. Add the columns in the
    Available Fields
    pane to the
    Selected Fields
    pane.
  11. Click
    OK
    .
    The columns appear in the
    Column Definition
    area of the
    Aggregate View Editor
    dialog box.
  12. To create a column, select a column
    Column Definition
    area, and click
    New Column
    .
    The
    Aggregate View Column Definition Editor
    dialog box appears.
  13. Enter the name, datatype, precision, scale, and expression for the column and click
    Save
    .
    The column appears in the
    Column Definition
    area of the
    Aggregate View Editor
    dialog box.
  14. Select
    Group By
    to specify columns for groupings.
  15. To change the order of the columns, select a column and click
    Move Up
    or
    Move Down
    .
  16. Click
    Save
    .