Tuning the Trillium Quality Project for SAP - trillium_quality - 17.1

Trillium Quality for SAP Reference Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality
Title
Trillium Quality for SAP Reference Guide
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

The project template is pre-tuned for SAP best practices. However, some processes require further configuration before you can run the project. These processes are:

  • Initial Transformer (optional)

  • Global Data Router

  • Country-specific Transformers

  • Country-specific Window Key Generator (for Fuzzy Search projects only)

  • Country-specific Transformer Data Reconstruction (optional)

Note: Tuning procedures for all the processes are described in detail in the Trillium online help. The following procedures summarize some specific steps you that you need to complete to run your SAP project.

To review or modify the parser input settings

  1. Double-click the Initial Transformer process.

  2. Select the Parser Inputs tab.

  3. Review the input settings and make any desired modifications.

  4. Click Finish.

To tune the Global Data Router

  1. Double-click the Global Data Router process. The Global Data Router editor opens.

  2. Click Options. The Define Global Data Router Inputs window opens.

    Figure 1. Define Global Data Router Inputs Window
    Define Global Data Router Inputs Window

     

  3. Select the Country attribute from the Input Attributes list and click > to add it to the Global Data Router Inputs list.

  4. Click Advanced on the right side of the window. The Advanced Settings window opens.

    Figure 2. Global Data Router Advanced Settings Window
    Global Data Router Advanced Settings Window

     

  5. If a country code attribute exists in the input, select the name of the attribute from the Country Code Attribute list box.  

  6. If a postcode attribute exists in the input, select the name of the attribute from the Postcode Attribute list box. Specifying the postcode attribute helps the Global Data Router identify the country of origin.

  7. When the input has been defined, click Back, and then click Finish.

  8.    In the Project View, right-click sap Initial Transformer, and select Apply Schema Changes to update any schema changes.

    The Server Action window opens.

  9. Click OK to apply outstanding schema changes.

To tune the country-specific Transformer

  1. Right-click the country-specific Transformer process for the first country in the project.

  2. Select Edit process from the menu.

  3. Click Parser Inputs.

    The Define Parser Input Address Lines window opens.

    Figure 3. Define Parser Input Address Lines Window
    Define Parser Input Address Lines Window

  4. Make any country-specific modifications to the address lines window.

    For example, the U.S. street address format is house number + street name + street type; it is defined as:

        Line 4:  Houseno, Streetaddress, AptNo

    For Germany, the street address line format is street name + street type + house number; it is defined as:

         Line 4:  Streetaddress, Houseno, Aptno

  5. Click Finish.

  6. Repeat the procedure for any other country-specific transformers that have unique address line formats.

To tune the country-specific Transformer Data Reconstruction

  1. Right-click the Transformer Address Reconstruction process for the  country you are tuning.

  2. Select Edit process from the menu.

  3. Click Output Conditionals.

Note: For more information about the Transformer Address Reconstruction process, see Country-Specific Transformer Data Reconstruction. For detailed information on defining conditionals, see the Trillium online help.

To tune the country-specific Window Key Generator

Note: This procedure applies only to Window Key Generators that are part of Duplicate Check/Fuzzy Search workflows.
  1. Right-click the Window Key Generator process.

  2. Select Edit process from the menu.

  3. Click Advanced.

    The Advanced Rules window opens.

  4. Check Fuzzy matching.  

    When the Fuzzy matching option is enabled, the Window Key Generator behaves as follows:

    • If any input attribute(s) used to generate a window key is blank, blank out the window key.

    • If the resulting string of any input attribute(s) is blank, blank out the window key. For example, if street_name is "A" and the window key rule says to build using first three consonants of street_name, then the window key will be blank.

  5. Click Finish.

    Figure 4. Window Key Generator Edit Process
    Window Key Generator Edit Process

To run the project

  1. Right-click sap Initial Transformer and select Run.

    A prompt alerting you to apply the schema changes appears.

  2. Click Yes.

    The Execute Process window opens.

    Figure 5. Execute Process Window
    Execute Process Window
  3. (Optional) Check the Include dependent processes box if you want to include its dependent processes.

  4. Leave the Use pipes box unchecked.

  5. Click Run.

  6. After the processes have successfully completed, view the results at end of each process.

Note: You can further tune the business rules to meet your requirements. See the Trillium online help for detailed information.