Table of Contents

Search

  1. Preface
  2. Understanding Mapping Analyst for Excel
  3. Standard Mapping Specification Template
  4. Models Worksheet
  5. Packages Worksheet
  6. Domains and Enumerations Worksheets
  7. Mappings Worksheet
  8. Joins, Lookups, and Filters Worksheets
  9. Rules Worksheet
  10. Importing and Exporting Mapping Specifications

Mapping Analyst for Excel Guide

Mapping Analyst for Excel Guide

Validating the Models Worksheet

Validating the Models Worksheet

The Standard mapping specification template includes macros to perform validation of the Models worksheet.
The Models worksheet performs the following validation:
  • Names are defined for all tables and columns.
  • Model type is one of the types supported by Mapping Analyst for Excel.
  • Datatypes are valid for the specified model type.
  1. Save the mapping specification.
  2. On the Models worksheet, click
    Metadata
    Update and Check
    Validate
    .
    The validation displays a dialog box listing the number of errors.
  3. Click
    OK
    .
    The mapping specification displays the first worksheet that contains errors. Cells that contain an error are colored red.
  4. Move the pointer over a red cell to display the error message for the cell.
  5. Correct errors and validate again.

0 COMMENTS

We’d like to hear from you!