Value Mappings

This topic is related to the following sections:

• Value Mapping Config

• Check Table Values

About Value Mapping

Within the Migrate > Mappings section of Syniti Migrate, the mapping of fields that contain a check table may require a mapping from old to new values. For Mapping Action of Xref, field contains a Check Table name. The mapping also contains the field Xref Table which stores the Legacy Value, the Target Value, and the Load Value. Each of these fields are important to the translation from legacy to target mappings. The Check Tables require Value Mappings from the Legacy value to the Target value stored within XTVALUEMAP table, and if the target value is complex (which may be a concatenated string of fields) then to the Load value stored in table LIST_TARGET_VALUE table in the MIGRATE database.

Prerequisites for Value Mapping

• The Datasource MIGRATE must be setup properly to point to the MIGRATE Datasource Server. Refer to section Datasource Servers for details of setup for the Datasource MIGRATE.

• The Datasource MIGRATE must be setup within Snapshot Management as a source datasource for SRCCONSTRUCT so that the snapshot of data within tables LIST_TARGET_VALUE and XTVALUEMAP are aligned. Refer to section Add a CONSTRUCT Snapshot Datasource for details of setup and use.

• Once the Dataset fields have been Mapped and the results provide opportunity for Value Mappings (XREF mapping), the object should be setup in the ETL and processed to import from Source to Working table rows of data. The process of inserting from the Working table to XTVALUEMAP table the values for each zXREF field provides the tables and rows of data for use in this process. Either the SAP Data Services XML scripting builds these rules to run in Data Services, or the Syniti Migrate ETL adds rules for this action automatically. Refer to sections within Mapping for details on the ETL process and SAP Data Services XML scripting of rules and cross references.

• Within Administer > Advanced > Value Mapping Config, the check table may be setup for a more complicated translation from legacy to load values by adding an Import Query. Refer to section Value Mapping Config for details of setup and refresh of check tables by Subject Area.

Users & Roles in Value Mappings

The Migration Team Developers and Mappers are responsible for managing Value Mappings as part of the Migration ETL process.

Working with Value Mapping

Access the Value Mappings page from three sections of the Syniti Migrate application -

• Within Migrate > Mappings, through a link from within Mappings while viewing a Mapping for XREF type (Option 1)

• Within Migrate > Mappings, click Options icon stored within the Source table row of Mappings (Option 2)

• Direct access to all Value Mappings tables using pathway - Migrate > Value Mappings. (Option 3)

The user may select to process Value Mappings for a field from within the field mapping page. There are two places for access to this process - from within the XREF Mapping row, or from within the Options menu displayed on each row of the Sources panel.

Option 1 - Access to the Value Mappings page through a link from within Mappings while viewing a the mapping details for action type XREF or Rule Xref as shown below:

Option 2 - Access the Value Mappings page through the Mappings page. The user may work on Value Mappings for each Source system directly within the Migration Application. In the Sources panel, click Options  icon to display options for the selected Datasource Table.

Click on Value Mappings option.

The Value Mappings page displays. The left side contains filter fields to determine the Check table for maintenance. The right side contains the details of the selected Check table.

First, filter to the Check Table by entering values for the Check Table section. The Check Table panel displays the following Column Headers:

Once the Check table is selected, the page loads the values into the right side panel for Value Mappings. The count of total records is stored in the page bottom. This is an active page and rows may be Added, Edited, or Deleted.

The Search  icon may be used to filter data for specific values.

Option 3 - View the following page by navigating to Migrate > Value Mappings from the Syniti Migrate Homepage.

Add Legacy Values for Translation

Legacy Values may be added manually by clicking the Add icon. The save is not active until a Legacy Value (Required field) has been entered.

Once all required fields have been added, the user either clicks SAVE  icon or they may click Cancel to exit without adding.

Edit Check Table Value Mappings

To edit a row of data, click the Target Value cell for the row.

The Value Mappings panel displays the following Column Headers:

The user may select a value from the drop-down list a Target Value for each Legacy Value provided in the list. As each row is manually updated, the row changes to dark gray indicating that this row has been updated.

Once editing of the rows of data is complete, the user either clicks SAVE  icon or they may click RESET  button to remove all of the added changes. The Save icon if clicked produces a window to state that the data was Saved Successfully. Click OK button to proceed.

Note

Records changed to add Target Values and saved update the XTVALUEMAP table stored in the MIGRATE database. The conversion of data points to the SRCCONSTRUCT database to pull and update the target values to the fields in the working table. Make sure to Repopulate the SRCCONSTRUCT.XTVALUEMAP table prior to running the ETL to use the latest values updated in the XTVALUEMAP table.

In Snapshot Management, the view MIG_XTVALUEMAP has been added to the MIGRATE database. This view provides access to the LOAD_VALUE for use by the Xref Update rules. The view can be used as the source for the XTVALUEMAP snapshot from the MIGRATE database to the SRCCONSTRUCT database by updating the Snapshot System Table Name of the XTVALUEMAP snapshot to "MIG_XTVALUEMAP". The update rules can then reference the LOAD_VALUE column from the new XTVALUEMAP table in SRCCONSTRUCT. Refer to Value Mapping Snapshot Data Stored in SRCCONSTRUCT for more information.

In Value Mapping, the value that the Xref Update rule uses as the target value is now derived from the LOAD_VALUE if available, and, if there is no LOAD_VALUE, is derived from the TARGET_VALUE. Use the LOAD_VALUE field in situations where the value in the TARGET_VALUE field must be changed before being posted to the target. For example, the value in the TARGET_VALUE field can contain the value US-MN, but the value to be loaded to the target must be concatenated to MN.

Note

This change applies to XREF Update rules created going forward, and is not applied retroactively. If you want to use the LOAD_VALUE field in existing ETL rules created prior to this release, you must:

• Manually edit the existing Snapshot of the XTVALUEMAP table to reference the new MIG_XTVALUEMAP view in the Snapshot System Table Name field on the Table details page

• Update your existing Xref Update rules to use the new code:
  ZFIELD = ISNULL(LOAD_VALUE, TARGET_VALUE)

Delete Check Table Value Mappings

There are a few ways to delete records no longer needed:

• A single row may be deleted by clicking the Delete icon for the row.

• To remove multiple records, select the row to highlight and click on the Delete Selected Rows icon in the header.

• To remove all records that have no Target Values, click the Delete Empty Values button in the header.

A message displays stating that the delete is successful. The list is updated for the total remaining rows.

Suggested Value

This field is used to supply a value for the Target Value where that Target Value is missing in the drop down list. The Suggested Value field stores the temporary value so that mapping and conversion may proceed until the target system is set with the same value for use as a Target Value

An entry may be added to the Suggested Value field that is set as the Target Value during the Update rule for the XREF mapping. Notice that the Reset and Save icons are present due to the change to a row. Click Save icon to complete.

Once Complete, Save the rows of data as usual. The Suggested Value displays.

Bulk Editing

Should there be a need to update multiple rows of data with the same values, the user may click on the Check box  icon at the Header level to mark all rows as selected.

Note

As a option, the user may also click on multiple check box  icons to select some but not all rows.

They can then update all rows at one time, and save them. 

The modified rows display with updated values for the field edited with Bulk Edit. Click SAVE  icon in window.

Note

The selected count displays at page bottom.

Note

Records changed to add Target Values and saved update the XTVALUEMAP table stored in the MIGRATE database. The conversion of data points to the SRCCONSTRUCT database to pull and update the target values to the fields in the working table. Make sure to Repopulate the SRCCONSTRUCT.XTVALUEMAP table prior to running the ETL to use the latest values updated in the XTVALUEMAP table.

Note

Should the updated and saved values need to be reversed, click the RESET button to revert back to original values.

Reset Button

Once a row of data has been modified, the RESET button displays as active. Should the user make multiple changes and decide they are not necessary, click the RESET button to default back to the saved values.