Mass Maintenance

Template Role (Finish)

Use this page to:

To access this page:

  1. Click Mass Maintenance > Team on Navigation pane.
  2. Click Templates for a team.
  3. Click Roles for a template.
  4. Click Vertical View for the Post role.
  5. Click the Approve and Finish Settings tab.
  6. Click Finish Tables.

Field

Description

SOURCE

Displays name of the source database registered in Collect where tables are downloaded from.

NOTE: This field is not used when registering a Data Services job.

TARGET

Displays name of the target database registered in Collect where table data is refreshed from the source database.

NOTE: This field is not used when registering a Data Services job.

TABLE NAME

Displays name of table downloaded from the source database when the Finish role is processed for the assigned role.

NOTE: This field is not used when registering a Data Services job.

RUN RULES AFTER DOWNLOAD

This option determines the Collect rules to run on a table after download when a user with the Post role clicks Finish for the request on the Request (Roles) page. Options are:

  • All – Run all of the rules: If multiple rules are registered to the table in Collect, Mass Maintenance will run them on the table after download in the priority order set on the Collect Table (Rule) page.
  • None – Do not run any rules: Though rules are registered to the table in Collect, Mass Maintenance will not run those rules on the downloaded table.
  • NoParametersOnly – Run only Collect rules that do not contain input parameters, such as an Insert rule.
  • ParametersOnly – Run Collect rules that contain input parameters, such as an Update rule.

NOTE: The rule(s) must have already been registered and activated in Collect.

NOTE: This field is not used when registering a Data Services job.

DATA SERVICES DATA SOURCE

Displays the name of the data source that stores the Data Services job.

NOTE: This field is not used when registering tables for download as a Finish Process using Collect.

DATA SERVICES JOB NAME

Displays the name of the job written in Data Services that will be used to pull data from the SAP environment and add it the database dgSAP, the working snapshot of the SAP data.

NOTE: This field is not used when registering tables for download as a Finish Process using Collect.

Source Filter Columns

Click to open the Template Role (Finish-Columns) page to add, edit and delete a list of columns used to form the where clause for selecting values from the source database. If no columns are set up, the entire table is downloaded.

NOTE: This field is not used when registering a Data Services job.

Target Filter Columns

Click to open the Template Role (Finish-Columns) page to add, edit and delete a list of columns used to form the where clause for selecting values to delete from the target database before data is refreshed from the source database. If no columns are set up, the entire table is downloaded.

NOTE: This field is not used when registering a Data Services job.

Global Variables

Click to open the Data Services Global Variables Setup page to add, edit or delete global variables for the Data Services job.

NOTE: The RequestID variable is automatically populated and does not need to be registered.

NOTE: This icon is not used when registering tables for download as a Finish Process using Collect.