dspCompose

Map Columns from the Template to Columns from the ISA Report

NOTE: Information Steward (IS) is SAP’s software for data profiling and metadata management. The Information Steward Accelerator by Back Office Associates® (ISA) extracts data that failed IS rules, then distributes the data to groups of users via reports.

NOTE: During the request creation process, columns from the ISA report are mapped to columns in the staging table. The template must have already been recorded and generated to map columns. Generate a template on the Vertical View of the Templates page on the General tab.

Once an external request scenario for an Information Steward-initiated request has been created and the staging table has been built, the columns in the template must be mapped to columns in the staging table; staging table columns are the same columns as in the ISA report.

As a result of the mapping, when the ISA report is processed and the request data is moved from the staging table to the table used for the Data Entry role for the request, it is either:

Copied from the staging table to the table used for the Data Entry role for the request or

Replaced by a fixed value

NOTE: If a template uses an external request scenario that creates Information Steward-initiated requests, that template cannot be activated until at least one of the columns in the staging table has been mapped to a template column on the Template (External Request Scenario Column) page.

To map columns in the staging table to template columns:

  1. Select Team in the Navigation pane.
  2. Click Templates for a team.
  3. Click ISA External Request Scenarios for a template.
  4. Click Vertical View for the scenario.

  5. Click Map Columns.

    NOTE: The Map Columns icon is only active after the template has been generated. Generate a template on the Templates page’s Vertical View on the General tab.

    NOTE: See the following two sets of steps for instructions to map a column from the staging table to a column in the template or to map a fixed value to the template column.

To map a column from the staging table to a column in the template:

  1. From the Template (External Request Scenario Column) page, click Edit for a COLUMN NAME.

    View the field descriptions for the Template (External Request Scenario Column) page

  1. The COLUMN NAME is the name of the table’s column in the template.

  2. Select a column from the STAGING COLUMN NAME list box.

    NOTE: The options in the STAGING COLUMN NAME list box are the column names from the ISA report.

  3. Click Save.

To map a column from the staging table to a fixed value:

  1. From the Template (External Request Scenario Column) page, click Edit for a COLUMN NAME.

    View the field descriptions for the Template (External Request Scenario Column) page

    NOTE: The COLUMN NAME is the name of the table’s column in the template.

  2. Click the STAGING COLUMN NAME list box.

  3. Enter the fixed value in the filter field that displays above the options.

    NOTE: A fixed value must be surrounded by single quotation marks (e.g., ‘10’).

  4. Press the Enter key.
  5. Click Save.

When processing data from an ISA report for an Information Steward-initiated request, the request uses the fixed value for this column in the table used for the first Data Entry role for the request.

Refer to Create a Request in dspCompose™ from the ISA Report Data Viewer Page for more information.