2.1.2 Adding a Source Data to Attribute Mapping

Use this configuration to manage the mapping between source and attribute dimensions
  1. Login to STSA.
    The Workspace Summary page is displayed.
  2. In the Workspace Summary page, click the Sandbox tab, launch the required workspace.
  3. Click the Context Menu representing the user name and then click Configuration Manager.
  4. Click Configure in the Business Attribute Configuration section.
    The Business Attribute Configuration page is displayed.
  5. Click Configure in the Source Data to Attribute Mapping section.
    The Source Data to Attribute Mapping page is displayed.
  6. Click Create New.
    The Source to Attribute Mapping Definition page is displayed.
  7. In the Source Table section, click the drop-down menu for Source Table Name and select the required Source Table.
  8. Click Auto Generate Mapping for <Table Name>.
    The Auto-Generated Source to Target Mappings for <Table Name> page is displayed.
  9. Select the required MIS Date Mapping.
  10. Select the required Field Mappings.
  11. Click Apply.
    The selected mappings are saved and displayed on the Source to Attribute Mapping Definition page.
  12. If there are no auto-generated mappings found for the table source you selected, follow these steps:
    1. Under the Reporting Date Mapping section, do the following:
      1. Click the drop-down menu for Source Column Name and select the relevant mis date column.
      2. Click the drop-down menu for Attribute Table Name and select the desired attribute table.
      3. Click the drop-down menu for Attribute Column Name and select the attribute column.
      4. Click the drop-down menu for Attribute Name and select the attribute name.
      5. Click the Done icon to add the Mis Date Mapping.
    2. Under the Source to Attribute Mapping section, do the following:
      1. Click the drop-down menu for Source Column Name and select the relevant source data column.
      2. Click the drop-down menu for Attribute Table Name and select the desired attribute table.
      3. Click the drop-down menu for Attribute Column Name and select the attribute column.
      4. Click the drop-down menu for Attribute Name and select the attribute name.
      5. Click the Add Row icon to add the field mappings.
      6. Repeat steps a through d for each new mapping. Ensure that the attribute name, glossary term, or logical reference selected for the mapping exists on the OM side so that synchronization occurs correctly.
  13. Save the Mapping. Do either of the following:
    • Click Save to save the new source data to attribute mapping and exit.
    • Click Save And Create New to save the current mapping and immediately open a new blank screen to define another mapping.