Repository Reports

The reports under the Repository menu enable you to view changes within a base dictionary over a specified time period, to compare two dictionary versions, and to export an entire dictionary to an XML report.

This section includes:

• Date Comparison Report
  
• Dictionary Comparison Report
  
• Dictionary Export Report
  

Date Comparison Report

The Date Comparison Report displays all the changes to a base dictionary between a user-specified start and end date.

To run the Date Comparison Report:

1. Select Date Comparison from the Repository menu.
2. Fill in the general report specifications. See Setting Parameters.
3. Enter a value for Job Specific parameters:

   • Base Dictionary. Select the dictionary you want to investigate.

   • Start Date. The beginning date of the period you want to investigate.

   • End Date. The end date of the period you want to investigate.

   • Include Global VTAs? If selected, the report will include Global VTA information.

   • Include Domain Primary Links? If selected, the report will include information about Domain Primary Links in this dictionary.

   • Template: Select the template for the report. If your company has created a custom template, it appears in the list of values. The Oracle Template is the default.

4. Submit the job. See Running a Job.

Dictionary Comparison Report

The Dictionary Comparison Report analyzes two versions of the same dictionary, and outputs any differences in their terms and relations. For term records that have been added, deleted, or updated, this report provides all of the term's information from the TMS_DICT_CONTENTS table. For relation records that have been added or deleted, the report pulls relation information from TMS_DICT_RELATIONS.

You can only run this report for two versions of the same dictionary: either a base dictionary and one of its virtual dictionaries, or two virtual dictionaries that share the same base dictionary. Regardless of the order in which you enter the dictionaries, TMS orders the dictionaries by cut-off date, with a base dictionary always appearing as the second dictionary in the report.

The lists of values you use to define the First Dictionary and Second Dictionary in the comparison are not restricted to allow only versions of the same dictionary. If you select virtual dictionaries that are not based on the same base dictionary, this report returns an error.

To run the Dictionary Comparison Report:

1. From the Repository menu, select Dictionary Comparison.
2. Fill in the general report specifications. See Setting Parameters.
3. Enter a value for each of the Job Specific parameters:

   • First Dictionary

   • Second Dictionary

   • Template: Select the template for the report. If your company has created a custom template, it appears in the list of values. The Oracle Template is the default.

   Choose the dictionaries you want to compare from the First Dictionary and Second Dictionary lists. Even though the lists display all of the dictionaries in the database, be sure to choose dictionaries that share the same base dictionary.

4. Submit the job. See Running a Job.

Dictionary Export Report

The Dictionary Export Report generates a rendition of an entire TMS base dictionary or virtual dictionary displaying dictionary contents and relations.

To run the Dictionary Export report:

1. Select Dictionary Export from the Repository menu.
2. Fill in the general report specifications. See Setting Parameters.
3. Fill in the job-specific specifications. All are required except the cut-off date of a base dictionary:

   • First Dictionary. Select the Base dictionary or Virtual dictionary.

   • Include VTAs? If Yes, VTAs will be included in the Dictionary Export Report.

4. Submit the job. See Running a Job.