Reports

Click Tools > Reports to generate either of the following reports:

• Schema Definition Report

  The schema definition report will be generated automatically when you package the project.

  This report details the schema structure in your project. You can use the following parameters to view details:

  • Destination tables :By default, all destination tables will be displayed in the report. To view selected tables, clear the All selection and select the required tables from the drop-down list or browse for specific tables.
  • Mapping Status: By default, both mapped and unmapped tables will be displayed. To view only mapped or only unmapped tables, clear the All selection and select the required option.
  • Report Type: Schema Definition report will run in two modes:
    • Developer mode: This mode is selected by default. In this mode all schema and corresponding mappings will be displayed. Objects and columns that are set as hidden will also be displayed.
    • Customer mode: This mode will generate the report with only objects and columns that are set to display. Hidden objects and columns will not be displayed in the report.
  Note: When you export the Schema Definition report to an Excel format, you must add an entry in the Registry. Else, a warning message is displayed.
• Project Summary Report

  This is an informative report and displays details about the project history and any comments that were added through Project > Properties.

  Note: The following two reports are displayed only for projects that have been created using the previous versions of Studio. If you have created a project using Studio 10.0, these reports will not be displayed.

The following two reports are available only when CDM projects are imported:

• Lookup Definition Report

  This report displays the lookup categories and their destination values and description as well as the source values and description. In case of SAP projects, the report can be filtered by Lookup Category. To do this, clear the All check box and select the required lookup category and then click Launch Report.

  Note: Filter selection is optional; by default, all lookup categories are displayed.
• Lookup Association Report
  This report shows for each lookup category, the destination table and column that it is mapped to and the source tables and columns from which the data is fetched.  The report can be filtered by Lookup Category. To do this, clear the All check box and select the required lookup category and then click Launch Report.

  Note: Filter selection is optional; by default, all lookup categories are displayed.