Dataset Reports

Within Migrate > Mappings for a Dataset, the target table reports are maintained. Click Reports button for the selected Dataset to view all target reports associated to that specific dataset.

Note
Only Roles of Developer, Validator, Administrator, and Functional Lead can access Target Reports as this allows for maintenance of the reports. The Mapper role cannot access the Target Reports section of Mappings.

Mappings: Targets Reports in the Dataset grid

Mappings: All Target Reports for a selected Dataset

Details Relevant to Dataset Reports list page

The reports on this page all have indexing so that the user may determine the order of the reports. The Priority column provides selection for Critical, Major, Info. Only the reports with record counts displays the View and Download icons as Active. The Status of the report is provided on the right side and the details of all errors are provided in the Report Details page - double-click a report to open to display.

Other options are available for the user such as displaying history, refreshing the report, viewing the report, or download to local drive. See the details for these icons below:

Icon	Name	Use
	History	The History icon displays a grid of history for each run of the report with count and date.
	Refresh	The Refresh icon updates the report and runs for current counts.
	Segment	Displays the list of Segmented reports. Refer to Segment By section for more information.
	Show/Hide	The Show/Hide icon displays the report on page.
	Download	The Download icon saves the current report to the user's local drive. Note This icon is disabled for some users as per their role-based security settings. To enable this icon, contact your Migrate Administrator.
	Open in SQL Editor	This icon opens SQL Editor with the report’s DDL for debugging the code. Refer to SQL Editor for more information. If the icon is disabled, the report is either based on a mapping rule or lacks a DDL statement.

To edit a target report, refer to the Maintain Target Reports for more information.

The Dataset Reports page displays the following fields for all target reports in the selected dataset:

Field	Description
Options	This column contains four icons (History, Refresh, Segment, View, and Download). Each icon produces the outcome indicated in their name.
Priority	Allows reports to be filtered into groups as Critical, Major, Moderate, Minor, or Info.
Index	Sequence of the Reports. Value increases by factor of 10 for each new entry.
Table	Name of the target table in the target database.
Target Table	Name of the target staging table in the working database.
Name	Name of the Target Report.
Type	The Report Type categorizes each report and setup for flagging in the All Errors report for errors produced.
Description	The detailed description of the report.
Active	Toggle to set status of the Dataset for future-state design mapping and migration. Note Defaults as Active.
Publish	Toggle to mark relevant to Publish or not publish the report within the Validate pages.
Record Count History	These are spark lines that show the progression of counts for the report in a graph.
Last Run	Date this report was run last.
Records	Count of records processed successfully.
Duration	The time in seconds that it took this report to run.
Limit	The quantity of records that defaults as output to prevent excessively large reports. Note The default value of 1000 at the time of save may be changed after saving. If no Limit value is set, you can view all available records by scrolling down the report page. The max limit for download is up to the Limit value.
Remediated	The field that is updated by remediation based upon a Dynamic view added to the report. See Target Report Remediation for details.
Sample	Check Box to show if report is using a random sample of data within the output of this report. This field works with Limit field. Note The check box is selected within Edit Details.
Security	Provides icon to indicate that this report contains sensitive data that only a list of users may view.
Status Indicator	This icon shows the status of the report. Success: Error: Unknown: