Description

Application Information

Displays the name of the component, Console.

Displays current version of Console.

Displays date when this version of Console Was released.

Common Options

Displays the filter Console uses when displaying options in the SOURCE ID list box on the Source page’s Horizontal View and Vertical Views. This filter selects the Source data source as a database that begins with sdb.

Displays the filter Console uses when displaying options in the DATASOURCE ID list box on the Process Area: Object page’s Horizontal View. The default value is dsw% used by Transform databases.

Displays the email address from which dspMigrate™ will send workflow emails.

Description

Field Options

Displays the prefix added to a Source key field during the Transform automation process. These key fields are used to track legacy Source keys during the migration process to the new key value (often generated by the new ERP system). The default is zLegacy.

Displays the prefix added to a cross reference field during the Transform automation process. When using a cross reference rule (on the Field Mappings page in Map by selecting Xref or RuleXref in the ACTION list box) that requires additional or multiple rules to determine a value, Map creates a zField and a zLegacy field on the source table used in Transform. The zLegacy is used to complete client data conversions and the zField is used to complete the value mapping Source to Target check table values. The default is zLegacy.

Displays the default value mapping status for a cross reference Source field for value mapping. When the a field mapping’s Action is set to Xref , the Source field on the Value Mapping page will default to this selection

Displays the option that controls how Map updates the ACTION column for Add Row and Update Row source mappings when the action has not been set (i.e., the ACTION column is blank). The ACTION column displays on the Field Mappings page in Map.

Options include:

• None - The values in the ACTION column for the Add Row and Update Row Sources are not changed in other Sources.
• Primary and Secondary Source - When a mapping is saved in a Add Row and Update Row Source, Map updates the ACTION column for actions that are not set with NotUsed.
• Secondary Source only - When a mapping is saved for an Update Row, the ACTION column for all other Update Row source mappings is set to NotUsed. In this case, if the Add Row source does not have an ACTION set, Map does not update that mapping. The Add Row source’s action remains unchanged.

If checked, when mapping is deleted and added back the mapping is automatically restored to the latest mapping from history.

NOTE: Enabling this option can affect performance and add overhead to the sync process.

If unchecked, when mapping is deleted and added back, the user must use the Restore option on the Field Mapping History page to restore the mapping. Refer to Restore Current Field Mapping From History for more information.

If unchecked, Map builds cross reference rules at the source level for those field mappings with an action of Xref or RuleXref.

If checked, Map builds cross reference rules at the target level for those field mappings with an action of Xref or RuleXref.  By default, the check box is unchecked.

If checked, Map builds Transform Remediation Rule reports to display data audit updates during the Transform Automation process.

NOTE: Enabling this feature may affect performance.

If unchecked, Map generates the remediation rule value to process, but does not build the new view to generate the remediation report.

Displays the action taken when a user clicks the Reset icon for a field mapping on the Field Mappings page n Map or the Automation SQL Field Mappings page in SQL AutoGen.

Options are:

• Reset all Field Mapping Fields – All fields are cleared of values

NOTE: If the mapping is associated with a field group other than the default field group (* or “All”), the Target Relationship ID field is not updated on a reset.

• Reset Status Fields only – All fields retain values except for the Mapping Status and Rule Status, which are set to Pending Review.

Displays the action to take on value mappings for field mappings using the Xref or RuleXref action when the field mappings are reset.

Displays the action to take on Transform rules for field mappings using Copy, Default, Rule, Xref or RuleXref action when the field mappings are reset.

Metric Options

Displays the number of days metrics are saved. The default value is 35.

This daily summary is used to build the Snap Shot metrics.

Displays the number of days metric summary data is saved. The default value is 180.

Rule Options

Displays the priority Map assigns to a Source delete rule when the rule is created. The default value is 19999.

Displays the priority Map assigns to a Source insert rule when the rule is created. The default Value is 20000.

Displays the number used to multiply against the field’s priority on the Target Fields page in Map and the result is the Priority for the Rule in Transform. Source rules will be registered in Transform using this priority, leaving gaps in the priority numbers to be used for manual rules. For example, if the field MEINS is priority 20, and the Source Priority Multiplier is set to 10, then Map would set the Source rule priority to 200 in Transform. The default value is 10.

NOTE: Once a Source rule for a field is registered in Transform, Map will not adjust the priority.

Displays the number used to multiply against the field’s priority on the Target Fields page in Map and the result is the Priority for the Rule in Transform. Target rules will be registered in Transform using this priority, leaving gaps in the priority numbers to be used for manual rules. For example, if the field MEINS is priority 20, and the Source Priority Multiplier is set to 10, then Map would set the Target rule priority to 200 in Transform, The default value is 10.

NOTE: Once a Target rule for a field is registered in Transform, Map will not adjust the priority.

Displays the number used to multiply against the field’s priority on the Target Fields page in Map and the result is the Priority for the Rule in Transform. Target reports will be built and registered in Transform using this priority, leaving gaps in the priority numbers to be used for target reports created manually. For example, if a report is priority 20 and the Target Report Priority Multiplier is set to 10, then Map would set the target priority to 200 in Transform. The default value is 10.

NOTE: Once a Target report is registered in Transform, Map will not adjust the priority.

Displays the number used to multiply against the field’s priority on the Target Fields page in Map and the result is the Priority for the Rule in Transform. Target reports with remediation will be built and registered in Transform using this priority, leaving gaps in the priority numbers to be used for Target reports with remediation created manually. For example, if a report is priority 20, and the Target Report Remediation Priority Multiplier is set to 10, then Map would set the Target report with remediation priority to 200 in Transform. The default value is 10.

NOTE: Once a Target report with remediation is registered in Transform, Map will not adjust the priority.

Description

Directory Paths

Displays the path for the Source directory where Source files (generally package files) that can be imported into Transform are stored.

Displays the path where Transform will create report files. All files are generated to the path:

C:\DSW\Report\<Wave Name>-<Process Area>\<Target Name>

For example, if Transform were generating reports for the target ttMARA in the SouthAmerica Wave, MM Process Area, the reports would be written to:

C:\DSW\Report\SouthAmerica-MM\ttMARA

Displays the path where Transform will create export files. All files are generated to the path:

C:\DSW\Export\<Wave Name>-<Process Area>\<Target Name>

For example, if Transform were generating an export file for the target ttMARA in the SouthAmerica Wave, MM Process Area, the file  would be written to:

C:\DSW\Export\SouthAmerica-MM\ttMARA

Displays the path Transform will look in for package files.

Displays the path where Transform will create documentation files.

Other

Displays the name of the temporary database used by Transform.

If checked, Transform generates audit statistics during processing.

If checked, Transform runs remediation rules. This field should not be checked for production loads.

Displays the mode for file system generation.

Values are:

• Automatic – Both file system files and Report Cache are created.
• Custom – Only file systems file are created
• On Demand – Neither file system files nor Report Cache created.

The counts (i.e., the number of rows returned) on Target/Source/Remediation/Audit Report pages are updated.

If the Report File Generation Mode ID is none, the Report Generation Mode ID is Custom.

NOTE: Report Cache are only created if Publish is enabled.

File system files, sample and segment reports are created in a path on the application server using folder names based on the Object, Target, and Source names used in the report. The path displays in the Report Path field.

The Report Cache is created in the Report Cache Data Source ID for My Reports

When a user clicks the Access Report icon on the My Reports pages a file is written to the file system (note that same location as the file system file above).

If checked, Target Sources are auto-generated with a default status of active in Transform. If unchecked, target sources are auto-generated with a default status of inactive in Transform.

Filters

Displays the delimiter used to separate filter prefixes when more than one filter is defined.

Displays the prefix used to filter Transform procedures.

Displays the prefix used to filter Target tables.

Displays the prefix used to filter Target rules.

Displays the prefix used to filter Target reports.

Displays the prefix used to filter Target exports.

Displays the prefix used to filter Source tables.

Displays the prefix used to filter Source rules.

Displays the prefix used to filter Source reports.

Displays the prefix used to filter import tables.

Report Settings

Displays whether column headings in reports will include field names, a translation of the field names, or both. Field names in a Target system are often abbreviated or, in the case of SAP, are abbreviated in German.

Displays a character to replace the following invalid characters: ? | : * ? “ < > in reports. The default value is ^.

Displays the name of the database that contains the tables storing the results of report views.

NOTE: REPORT CACHE DATA SOURCE ID is required for the execution of the Business Data Transformation and Report Delivery via Transform.

Displays the header that will appear on all reports as defined on the Report Headers/Footers (Setup) page, accessible from Navigation pane in Transform by selecting Configuration > Setup.

Displays the footer that will appear on all reports as defined on the Report Headers/Footers (Setup) page, accessible from Navigation pane in Transform by selecting Configuration > Setup.

If checked, the report is printed in landscape format. If unchecked, the report is printed in portrait format.

If enabled, Transform will generate reports in the Report Path (set in the Report Path field on this page) even when there are no records on the report. If disabled, Transform will only generate a report if the report contains data.

If checked, reports will not contain a record count. If unchecked, the record count is included on all reports.

If checked, Transform outputs Segment By reports to a single directory with the SegmentBy value appended to the report file name. If unchecked, Transform creates one directory per SegmentBy value.

Displays the format for text in reports, either text format or x125.

If checked, IMEX=1 is automatically added to Excel file connections, which instructs CranPort or SSIS packages to read intermixed columns (columns containing a mix of text and numbers) as text columns.

If checked, Transform creates technical documentation files.

Transform generates and saves versions of the Technical, Audit and Recon documents as HTML files every time an object, target or Target Source is processed.

Refer to Generate Documentation for Objects, Targets, and Target Sources for more information.

Displays the maximum number of rows to be generated into an Excel file. If the data contains more than the number of rows indicated by this field, a delimited file is generated instead.

Displays the maximum number of records that can be generated into a file (Excel or delimited).

Displays the delimiter used to separate the report data into columns in the report when the file is generated.

Displays the qualifier used to delineate column data containing spaces or special characters.

Package Properties

Displays the import suffix for CranPort or SSIS packages.

Displays the export suffix for CranPort or SSIS packages.

Displays Connection 1 for import CranPort or SSIS packages and Connection 2 for export CranPort or SSIS packages.

Displays Connection 1 for export CranPort or SSIS packages and Connection 2 for import CranPort or SSIS packages.

Displays the prefix used for temporary CranPort or SSIS packages.

If checked, Transform destroys any temporary CranPort or SSIS packages generated during report file creation. If disabled, the temporary packages are saved on the web server for review.

Description

Client value used in views for filtering.

Description

Displays the text color used in the Field Comparison table when values are equal between the baseline Wave and the child Wave.

The table displays on the Vertical View of the results page for each element (Process Area, object, target and field).

Displays the text color used in the Field Comparison table when values are not equal between the baseline Wave and the child Wave.

The table displays on the Vertical View of the results page for each element (Process Area, Object, Target and field).

Displays the text color used in the Field Comparison table when a value exists in the child Wave, but not in the baseline Wave. The table displays on the Vertical View of the results page for each element (Process Area, Object, Target and field).

Displays the text color used in the Field Comparison table when a value exists in the baseline Wave, but not in the child Wave. The table displays on the Vertical View of the results page for each element (Process Area, Object, Target and field).

If checked, if a value exists in one Wave and not the other, the text is formatted as a strikethrough.