Translation Reports to Identify Inconsistent Data

TMS uses Translation Derivation Links to associate terms from the global and local dictionaries via the dictionary code. Even though TMS requires that these two dictionaries have the same structure, the system does not validate that the dictionaries' term and relation data match exactly. Thus, for example, when TMS attempts to derive a term in the local dictionary with a matching dictionary content code, the corresponding term might not exist in the linked dictionary, or reside on a different dictionary level, or in a different domain.

TMS provides three reports that display many of these inconsistencies. All three reports are available under the Translation Reports node, which is accessible to all users who can access the Repository Maintenance node (that is, users with the tms_maintain_priv role).

• The Inconsistent Dictionary Codes Report shows the terms with dictionary content codes that exist in one dictionary but not the other, or terms in the two dictionaries with the same dictionary content code that exist in different domains or dictionary levels.

• The Duplicate and Null Dictionary Codes Report shows the dictionary contents for codes that exist more than once in the same domain/dictionary combination. If two or more terms have null codes, the report includes these terms in the report as well.

• The Inconsistent Dictionary Relations Report shows the relations to a term in one dictionary that are different than those relations to the same term in the other dictionary. The report includes differences in the relation's domain, related term, level, or relation type.

You can generate any of these reports in PDF or HTML format, and output in Preview mode, to a file, or to a printer. All three reports are resource-intensive, so run them sparingly.

Choosing Input Dictionaries

Both the Inconsistent Dictionary Codes Report and Inconsistent Dictionary Relations Report require two input dictionaries. For TMS to generate either report properly, the input dictionaries must have a Translation Derivation Link defined. If the input dictionaries are not linked, or if you enter the same dictionary twice, TMS outputs the report with an error message that instructs you to choose two different input dictionaries with a Translation Derivation Link between them.

For more information, see:

• Inconsistent Dictionary Codes Report
  
• Duplicate and Null Dictionary Codes Report
  
• Inconsistent Dictionary Relations Report
  

Inconsistent Dictionary Codes Report

This report compares terms in the two dictionaries that share the same dictionary code. There should be a one-to-one relationship between the code values in these dictionaries, and the terms should reside in the same domain (whether or not the terms are global) and dictionary level. The Inconsistent Dictionary Codes Report thus generates a list of terms in each dictionary whose dictionary codes:

• exist in one dictionary but not the other.

• match, but reside in different domains or levels.

To run the Inconsistent Dictionary Codes Report:

1. Select Inconsistent Dictionary Codes from the Translation Reports menu.
2. Fill in the general report specifications. See Setting Parameters.
3. Enter a value for each Job Specific parameter:
4. Translation DictionarySecond Translation Dictionary
   A Translation Derivation Link must exist between these dictionaries for the report to run correctly.
5. Submit the job. See Running a Job.

Duplicate and Null Dictionary Codes Report

For Translation Derivation to work correctly, dictionary codes should be unique within a dictionary. The Duplicate and Null Dictionary Codes Report examines all of the dictionary content codes in one dictionary, and outputs term information where terms share the same code. If two or more terms have null codes, the report includes those terms in the report as well. For each duplicate dictionary code, the report flags the code, its Dictionary Level, its Domain, and the number of times it appears in the dictionary.

To run the Duplicate and Null Dictionary Codes Report:

1. From the Translation Reports menu, select Duplicate and Null Dictionary Codes.
2. Fill in the general report specifications. See Setting Parameters.
3. Enter a value for each Job Specific parameter:

   • Translation Dictionary

   • Template

4. Submit the job. See Running a Job.

Inconsistent Dictionary Relations Report

Because TMS uses the dictionary hierarchies when deriving translation values, it is important that relations in these dictionaries match exactly. The Inconsistent Dictionary Relations Report shows relations to a term in one dictionary that are different than a relation to the same term in the linked dictionary. The report only considers relations between dictionary terms; VTAs are not included.

Any of the following qualifies two relations as inconsistent:

• The terms in the relation are not the same.

• The relations are in different domains.

• The terms in the relation are the same in both dictionaries, but terms with the same dictionary code reside on different levels in the two dictionaries.

• The relation types are different.

For both dictionaries, the report lists each inconsistent relation's Domain and Relation Type, and the Code, Level, and Term Name for the terms involved.

To run the Inconsistent Dictionary Relations Report:

1. From the Translation Reports menu, select Inconsistent Dictionary Relations.
2. Fill in the general report specifications. See Setting Parameters.
3. Enter a value for each Job Specific parameter:
4. Translation DictionarySecond Translation Dictionary
   A Translation Derivation Link must exist between these dictionaries for the report to run correctly.
5. Submit the job. See Running a Job.