dspCompose

Register Tables for Download as a Finish Process using Collect

At the template-role level for a Post role, a Template Administrator can register tables for download as a Finish process. The Finish process starts when a user clicks the Finish button for a Post role on the Request (Roles) page.

Additional configuration settings set on the Template Role (Finish) page and the Template Role (Finish - Columns) page  allow a Template Administrator to set Collect rules to run on table data after the download is finished, and to specify filter columns for both source and target data.

On the Vertical View of the Template (Role) page for the Post role, on the Approve and Finish Settings tab, two settings help to facilitate this functionality: FinishTables and Finish Download in Background.

If the Finish Download In Background check box is enabled, the data downloads in the background after the user clicks the Finish button for a Post role on the Request (Roles) page.

NOTE: If the package type to download data is set to SAP Data Services, it is recommended that the Delete Target Table On Build check box be disabled in Collect on the Target Sources page’s Vertical View on the Advanced tab. In this case, if the check box is enabled, dspCompose™ WILL delete every record in the target table during the Final Finish process (during which data posted in the target ERP system by the request is downloaded to tables).

Click the FinishTables icon to set one or more tables for download when the Post role is finished.

To set a table for download:

  1. Click 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.

  7. Click Add.

    View the field descriptions for the Template Role (Finish) page.

    NOTE:If no records exist, the page displays in add mode. Otherwise, click Add.

  8. Select a Collect source from the SOURCE list box.
  9. Select a Collect target from the TARGET list box.
  10. Select the name of the table to download from the TABLE NAME list box.

  11. Select an option in the RUN RULES AFTER DOWNLOAD list box, if applicable.

    NOTE: 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, dspCompose™ 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, dspCompose™ 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.

  12. Click Save.

The Source Filter Columns and Target Filter Columns icons are then active.

The Source Filter Columns are a list of columns used to form the where clause for selecting values from the source.

The Target Filter Columns are a list of columns used to form the where clause for selecting values to delete from the target before data is refreshed from the source.

NOTE: If no columns are set up, then dspCompose™ downloads the entire table.

The Template Role (Finish – Columns) page displays for both the Source Filter Columns and Target Filter Columns.

Using this page, a user can set a filter column or enter a where clause. Additionally a user can use custom syntax to form the where clause.