dq sap users guide 11 6

BusinessObjects™ Data Quality XI for SAP® Solutions

User’s Guide

BusinessObjects Data Quality XI for SAP Solutions 11.6.0.0

June 2007

��

�� For customer care, contact us on the Web at http://www.firstlogic.com/customer

If you find any problem with this documentation, please report it to Business Objects in writing at [email protected].

�� Copyright © 2007 Business Objects. All rights reserved.

�� Business Objects owns the following U.S. patents, which may cover products that are offered and sold by Business Objects: 5,555,403, 6,247,008 B1, 6,578,027 B2, 6,490,593 and 6,289,352.

�� Business Objects, the Business Objects logo, Crystal Reports, and Crystal Enterprise are trademarks or registered trademarks of Business Objects SA or its affiliated companies in the United States and other countries. All other names mentioned herein may be trademarks of their respective owners.

�� Business Objects products in this release may contain redistributions of software licensed from third-party contributors. Some of these individual components may also be available under alternative licenses. A partial listing of third-party contributors that have requested or permitted acknowledgments, as well as required notices, can be found at: http://www.businessobjects.com/thirdparty

� ��

http://www.firstlogic.com/customer

mailto:[email protected]

��

Preface ............................................................................................................ 7About this guide.........................................................................................7Don’t miss emails from us .........................................................................7Access the latest documentation................................................................7Conventions ...............................................................................................7Assumed audience .....................................................................................8

Chapter 1:Overview ........................................................................................................ 9Data quality overview ....................................................................................10

What is data quality? ...............................................................................10What steps are involved in data quality? .................................................10The results of data quality........................................................................11

What is Data Quality for SAP Solutions? ......................................................12Three components of Data Quality for SAP Solutions............................12Who updates Data Quality for SAP Solutions?.......................................12Postal validation engine...........................................................................12Match engine ...........................................................................................12

Introduction to Data Quality ..........................................................................13Hub of data quality needs ........................................................................13Data Quality scenario ..............................................................................13More information about Data Quality .....................................................14Data Quality documentation descriptions................................................14Access Data Quality documentation on Windows ..................................15Access Data Quality documentation on UNIX........................................15

Chapter 2:Installing Data Quality for SAP Solutions ................................................ 17System requirements ......................................................................................18

Requirements for the BAdIs ....................................................................18Required OSS Notes for your SAP system..............................................18Requirements for the RFC Server............................................................18RFC Server space requirements...............................................................19

The installation process..................................................................................20Data Quality installation notes and procedures..............................................21

Install Data Quality..................................................................................21After installing Data Quality ...................................................................21

Installing the RFC Server...............................................................................23Install a dedicated RFC Server for batch duplicate search ......................23Install the RFC Server on Windows ........................................................23Install the RFC Server on UNIX .............................................................24Start the RFC Server................................................................................25Stop the RFC Server ................................................................................26

Installing the Data Quality for SAP Solutions BAdIs....................................27Step 1: Import the Data Quality package on client 000...........................27Step 2: Insert the Data Quality IMG structure on client 000...................30

��

Step 3: Activate the Business Configuration Sets on each target client.. 33SAP handshake with RFC server................................................................... 34

Purpose of the activity............................................................................. 34Define the RFC destination ..................................................................... 34

Load supported country codes ....................................................................... 37Running the transaction and report ......................................................... 37

Activate duplicate check index pools ............................................................ 38Activate the index pools.......................................................................... 38

Quarterly Adjustment Reports ....................................................................... 40Report RSADRQU1................................................................................ 40Report /FLDQ/RSADRQU2 ................................................................... 41Report RSADRQU3................................................................................ 42Quarterly Adjustment custom error report .............................................. 43

Run the initial setup program......................................................................... 44Purpose of initial setup............................................................................ 44Run the initial setup................................................................................. 44

Install and configure Data Quality into the IC WebClient ............................ 45Requirements for running Data Quality for SAP Solutions in an IC WebClient profile .................................................................................... 45Considerations for postal validation with the IC WebClient .................. 45Summary of configuration tasks ............................................................. 45Activate the BSP BC Sets ....................................................................... 45Configure IC WebClients to use Data Quality for SAP Solutions views and controllers................................................................................................ 46Activate the /FLDQ/BSP_DQ service..................................................... 46Add postal validation functionality to other IC WebClient views .......... 47Disable the Postal Validation BAdI for the IC WebClient ..................... 48Creating new address records.................................................................. 48

Chapter 3:Configuring through the IMG................................................................... 49Locating the Data Quality IMG activities...................................................... 50SAP handshake with RFC server................................................................... 51Maintain Supported Countries ....................................................................... 52

Remove the country codes ...................................................................... 52Maintain exception table of transaction codes............................................... 53

Add a transaction code to the exception table......................................... 53Maintain table to activate SAP postal code check before postal validation .. 55

Add a country to the table ....................................................................... 55Maintain fields for address reviewer ............................................................. 56

Fields and order for standard street addresses......................................... 56Fields and order for P.O. Box addresses ................................................. 56Make changes to the fields for the address reviewer .............................. 56

Maintain fields for duplicate hit list display .................................................. 58Fields and order for error tolerant search and duplicate search .............. 58Make changes to the fields for the duplicate hit list display ................... 59

Maintain operating parameters ...................................................................... 60Operating parameters .............................................................................. 60Modify the parameters ............................................................................ 61

Map address types for Quarterly Adjustment ................................................ 62Defining mappings .................................................................................. 62Predefined mappings ............................................................................... 62Add a mapping for an Address Type Code ............................................. 62

��

Chapter 4:Configuring the RFC Server ...................................................................... 65Configuring through flrfcsrv.xml...................................................................66

Location of flrfcsrv.xml ...........................................................................66Editing flrfcsrv.xml..................................................................................66SAP settings and Data Quality settings ...................................................66File settings..............................................................................................66General settings .......................................................................................67Dataflows.................................................................................................68Overrides..................................................................................................68

Chapter 5:Postal address validation ............................................................................ 69Interactive cleansing with Data Quality for SAP Solutions...........................70

Using interactive cleansing......................................................................70Multiple suggestions................................................................................71

Batch cleansing with Quarterly Adjustment Reports .....................................72

Chapter 6:Duplicate check and error tolerant search ............................................... 73Understanding duplicate check and error tolerant search ..............................74

Duplicate check .......................................................................................74Error tolerant search ................................................................................74Break Keys...............................................................................................74

Understanding break keys and data fields......................................................75How Data Quality determines a break key ..............................................75Configure the break key settings .............................................................75Match on name data.................................................................................76

Using duplicate check ....................................................................................77The hit list ................................................................................................77Fields displayed .......................................................................................78

Using error tolerant search .............................................................................79The hit list ................................................................................................79Fields displayed .......................................................................................80

Chapter 7:Tips and troubleshooting ............................................................................ 81Installation troubleshooting............................................................................82

Checking the RFC server(s) connected ...................................................82Connection to the RFC Server closed......................................................82Troubleshooting Unicode issues..............................................................82

Postal validation and duplicate check/error tolerant search troubleshooting.84Inability to save addresses for which the postal code cannot be completed.................................................................................................84Records created without break keys due to downtime of RFC Server ....84Records not stored in pending update table when search disabled..........84Understanding regions .............................................................................85Newfoundland region code for R/3 4.60 and 4.70...................................85RSMTCCODE program error message ...................................................85Include records with empty break keys ...................................................86Duplicate hit list not appearing as expected ............................................86Threshold values for duplicates ...............................................................86Addresses do not validate/Error T528 .....................................................87

��

Data Quality Troubleshooting........................................................................ 88Installing directories and file permissions on UNIX............................... 88Threads allowed per process on UNIX ................................................... 88

RFC Server Troubleshooting ......................................................................... 89Output manifest information ................................................................... 89

Appendix A:Data Quality Dataflows and Transforms................................................... 91

Data Quality dataflows............................................................................ 91Enable and disable country engines ........................................................ 92Combine House Num and PMB transform ............................................. 93Data Quality Global Address Cleanse Base transform ........................... 94

Appendix B:Error Codes .................................................................................................. 97

Technical error codes .............................................................................. 97Postal validation error codes ................................................................. 100Duplicate check error code.................................................................... 100

Index........................................................................................................... 103

� ��

��

�� This guide provides a general overview of BusinessObjects Data Quality XI for SAP Solutions as well as specific information for installing and integrating this product into your SAP environment.

��

Email messages concerning this product come from a different address now. Ever since Business Objects purchased Firstlogic, Inc. in April 2006, email messages from us have come from a businessobjects.com email address. Make sure that your email system does not unintentionally filter these messages to a spam, trash, or quarantine area where you might miss them. We don’t want any important news about your product to not reach you.

��

You can access product documentation in several places:

�� On your installation CD. Release notes, manuals, and other documents for Data Quality for SAP Solutions are available on the CDs that you use to install this product.

�� On the Customer Portal. Go to www.firstlogic.com/customer, and then click the Documentation link to access all the latest product documentation. You can view the PDFs online or save them to your computer for viewing or printing.

�� This document follows these conventions:

��

Bold We use bold type for file names, paths, emphasis, and text that you should type exactly as shown. For example, “Type cd\ dirs.”

Italics We use italics for emphasis and text for which you should substitute your own data or values. For example, “Type a name for your file, and the .txt extension (testfile.txt).”

Menu commands We indicate commands that you choose from menus in the following format: Menu Name > Command Name. For example, “Choose File > New.”

!We use this symbol to alert you to important information and poten-tial problems.

We use this symbol to point out special cases that you should know about.

We use this symbol to draw your attention to tips that may be useful to you.

��

http://www.firstlogic.com/customer

�� This guide assumes that the people responsible for integrating and using Data Quality for SAP Solutions are experienced administrators and users of SAP R/3® and SAP Customer Relationship Management (SAP CRM) solutions. If you are implementing the IC WebClient postal validation and search capabilities, this guide also assumes that you are aware of any settings and customizations you have made to your IC WebClient configuration before installing this product.

This guide does not explain basic operation of the SAP environment. For questions about the SAP environment, consult the appropriate SAP documentation or SAP technical support.

This guide also does not explain the operation of the Data Quality server or Project Architect. For specific questions about Data Quality, consult the Data Quality documentation that is included in this package.

��

In previous releases of this software, this product was called the Global Data Quality Connector for SAP Solutions.

BusinessObjects Data Quality XI Release 2 was formerly called IQ8. Throughout this Guide, BusinessObjects Data Quality XI Release 2 is referred to by the shorthand name Data Quality.

In some earlier releases, the RFC Server was called the Data Quality Server. This changed name better uses standard SAP terminology and avoids confusion with a component of BusinessObjects Data Quality XI Release 2 that is called the Data Quality Server.

" ��

��$��%&�' �� (

Before using BusinessObjects Data Quality XI for SAP Solutions, you should understand some of concepts of data quality. A basic familiarity with these concepts helps you to understand what Data Quality for SAP Solutions does, how it works with your existing SAP environment, and why your organization benefits from data quality.

�� !"��#��#��$ #

��*��+�� (

,��*��+- Data quality is a process of arranging customer information in a standardized, validated, and consistent order. The process also helps you to avoid duplicate data entries and adds value by creating a single and accurate view of your customers.

,��$�� *��+-

Generally, data quality requires four main steps:

�� parsing

�� correction

�� standardization

�� duplicate matching

�� Parsing�involves checking the structure and content of each field of a contact’s information. During parsing, checks ensure that data appears where it belongs; an address does not appear in a name field, for example. Some of the more common elements to search for in a record during parsing include first and last name, street number and name, region, and postal code.

�� In order to correct data, Data Quality for SAP Solutions uses secondary data sources, such as the U.S. Postal Service’s National Directory or an international postal directory, to check and validate address information. Using these secondary sources, Data Quality for SAP Solutions can check, for example, whether La Crosse, Wisconsin is associated with the ZIP Code 54601, whether Harbor Plaza is actually a valid street name in La Crosse, and whether 100 is a valid address for that street.

%) ��

� �� After correcting the data, Data Quality for SAP Solutions can standardize the data. Standardization works in conjunction with correction and parsing as it arranges customer information in a consistent and preferred format. Examples of standardization include removal of dashes from a phone number or Social Security number, use of a common abbreviation such as DEPT for department number, or common representations of title such as Mr., Ms., Mrs., and Jr. It also includes the application of standard address elements such as converting Street to St and converting South West to SW.

�� Once a standardized customer record exists, matching should become part of the data quality analysis to eliminate redundancies. During the matching step, the software searches existing customer data records in real time using specific business-defined criteria to look for similar records. If no match is found, the data quality process is complete. If a match is found, however, then the user is offered the opportunity to determine whether the newly entered record matches the suggested existing record.

Duplicate matching technology even allows the user to search for records based on partial information.

.��*��+

These data quality concepts provide a foundation that helps a business to develop a clear picture of the customer, which can improve both efficiency and effectiveness. Because there are so many touch points for customer data in an organization, this activity has far-reaching implications in how you conduct business on a day-to-day basis.

�� !"��#��#��$ %%

,��/��+��0��0��-

Data Quality for SAP Solutions is software that enhances parts of your SAP installation. SAP can stand alone without having Data Quality for SAP Solutions installed, but without Data Quality for SAP Solutions you would not attain the benefits of data quality. Data Quality for SAP Solutions takes care of the correction, standardization, and duplicate matching steps in the data quality process.

.��$��/��+��0��0��

Data Quality for SAP Solutions consists of these components:

� Three Business Add-Ins (BAdI) that are integrated directly into the SAP environment for postal validation, duplicate check, and error tolerant search.

� The RFC Server, which receives and returns data sent from the SAP environment through TCP/IP.

� BusinessObjects Data Quality XI Release 2, which handles data quality processing tasks on the data it receives from the RFC Server through a Common Programming Interface for Communications (CPI-C) connection.

,��$��/��+��0��0��-

Data Quality for SAP Solutions is created and maintained by Business Objects.

��

The postal validation engine of Data Quality for SAP Solutions relies on the BusinessObjects Data Quality XI Release 2 address directories compiled from postal authorities such as the United States Post Office. Data Quality for SAP Solutions can cleanse both U.S. and global addresses.

The postal validation engine is integrated into your SAP system through SAP’s Business Address Services–Postal Validation (PV) interface.

1�� The match engine of Data Quality for SAP Solutions brings sophisticated record-matching technology to your SAP applications. The criteria for deciding which records are a potential match are controlled by business rules that you can customize to your needs. When you enter a record that is a potential duplicate, you have the option of choosing which of the duplicate records to keep.

The match engine is integrated into your SAP system through SAP’s Business Address Services (BAS)–Duplicate Check, Error Tolerant Search (DES) interface.

%� ��

2��/��+

As a Data Quality for SAP Solutions user, you may be wondering what Data Quality is and what it means to you. After installation, you can use Data Quality for SAP Solutions with little thought given to Data Quality, because it handles the data quality processes behind the scenes. The version of Data Quality shipped as part of Data Quality for SAP Solutions is customized to run only as part of Data Quality for SAP Solutions, but the technology of Data Quality offers other potential solutions to your enterprise’s data quality needs. This section provides an overview of what Data Quality does, independent of its use within Data Quality for SAP Solutions, and tells you where you can find more information about Data Quality.

3��*��+��

Data Quality is the next generation data quality platform that allows you to tie in all of your data quality needs to a single “hub.” Many users of Data Quality for SAP Solutions also have data quality needs in other applications or other areas of their enterprise. Instead of having many disparate solutions for each area of your enterprise, you can use Data Quality as the backbone for all of your data quality needs. With Data Quality, you can centralize and standardize this processing through the following Data Quality features.

��

All of the business rule definitions are stored in a single repository that can be shared by all applications that use Data Quality. You can organize business rules into reusable objects that can be shared to meet your enterprise requirements.

You can use the same objects in a project for Data Quality for SAP Solutions, your own custom application that incorporates Data Quality, or direct batch processing through Data Quality itself. This means that you can create data quality standards that are truly shared across your entire enterprise.

��

Data Quality is built on service-oriented architecture principles.

You can set up any number of instances of the Data Quality Server software, and your applications (including Data Quality for SAP Solutions) can communicate with that server directly, or via a web server using the Data Quality web service. This means that all of your data quality processing can happen in one centralized area.

��/��+�� The following diagram shows a possible scenario for how Data Quality can be used as the central hub for all of your enterprise data quality needs. This is only one example; the number of scenarios is practically limitless because of Data Quality’s flexibility.

�� !"��#��#��$ %

1��/��+

For more information about Data Quality, see the Data Quality documentation. The Data Quality documentation is available in electronic format, both in a printable PDF file and an online help format.

The online version requires an internet browser. We recommend Internet Explorer or Netscape 4.x (most recent versions recommended), or Mozilla 1.4 or higher, though other browsers may work as well. The printable version requires Adobe® Reader® 4.0 or higher (6.x recommended).

��/��+��$��

The following table describes the types of information included with each of the documents installed with Data Quality.

��

��

��

��

��

��

��

Documentation is installed as a separate component. The documentation for Data Quality is an optional installation component in most cases. If you don’t install the documentation while installing Data Quality, it won’t be available on your system.

��

Data Quality User’s Guide

Includes conceptual information about Data Quality, details about using the Project Architect interface, and a detailed ref-erence for objects such as transforms and Data Quality Blue-prints™. This guide is intended for the user who creates projects (data-flows) and configures the business rules of your Data Quality processing.

Data Quality Integra-tor’s Guide

Includes information about integrating Data Quality function-ality into custom applications via the web service. For exam-ple, it includes a detailed web method reference.This guide is intended for programmers and integrators.

% ��

��/��+��,��(

After installing Data Quality, Windows users can access the documentation from shortcuts on the Start menu. To access the documentation:

1. Choose Start > Programs > BusinessObjects XI Release 2 > Data Quality 11.6 > Documentation.

2. Click the appropriate shortcut for the documentation you want to view.

��/��+��4�25

After installing Data Quality, UNIX users can access the online documentation from their web browser. Enter the appropriate location and file name for the document you want to view, as shown in this table.

UNIX users can access the printable (PDF) documentation from Adobe Reader. You can find these documents in install_location/documents/pdf/.

Data Quality System Administrator’s Guide

Includes information about system requirements, installation planning, and actual installation steps for Data Quality.

Data Quality Release Notes

Includes information about what is new in the latest Data Quality release.

Data Quality Data Cleanse Modifier’s Guide

Includes information about how to customize cleansing with the Data Cleanse transform.This guide is intended for advanced users of the Data Cleanse transform.

��

��

Data Quality User’s Guide

install_location/documentation/userguide_html/index.htm

Data Quality Integra-tor’s Guide

install_location/documentation/intguide_html/index.htm

Data Quality Data Cleanse Modifier’s Guide

install_location/documentation/modguide_html/index.htm

�� !"��#��#��$ %�

%� ��

��$��&�2��/��+��0��0��

This chapter explains the requirements and procedures for installing BusinessObjects Data Quality XI for SAP Solutions.

The total number of CDs that you receive with your purchase of Data Quality for SAP Solutions is based on the country-specific address-cleansing engines that you purchased. The CDs for Data Quality for SAP Solutions include:

�� The “BusinessObjects Data Quality XI Release 2” and the Auxiliary Directories CDs contain the installation of BusinessObjects Data Quality XI Release 2 and the extensive lookup directories used for address cleansing. The exact CD set that you receive depends on your purchase. See the Data Quality documentation for installation instructions.

�� “BusinessObjects Data Quality XI for SAP – RFC Server” contains the installation of the RFC Server.

�� “BusinessObjects Data Quality XI for SAP – PV and DES Business Add Ins” contains the installation of the Business Add-Ins.

�� “BusinessObjects Data Quality XI for SAP – Dataflows” contains the dataflows that you must copy to your Data Quality installation.

�� “Runtime Environment for International Address Engine” contains an addition for your Data Quality installation if you use the International Address Engine or if you are using HP-UX with any address engines

�� BusinessObjects Data Quality XI Release 2 – Windows Components for UNIX contains additional software for customers who install Data Quality on UNIX

�� %"��&� �� %�

0+��*��

This section shows the requirements for the BAdIs and the RFC Server.

6�*��7��2

The BAdIs portion of Data Quality for SAP Solutions requires the following environment:

�� SAP Customer Relationship Management (SAP CRM) solutions v4.0 (with Basis/ABAP SP 39) and higher.

�� SAP R/3 v4.6 (with Basis/ABAP SP 46) and higher.

�� ECC 5.0 (ERP2004) and higher.

6�*��'00��+��0��+��

You must have installed the following Online Service System (OSS) Notes on your SAP system.

6�*��68��0��

The RFC Server requires one of the following environments.

��

�� Windows 2000

�� Windows 2000 Server

�� Windows XP

�� Windows 2003 Server

�� !"��

�� AIX 5.1, 5.2, and 5.3 (32 bit)

�� HP-UX 11.0 and 11i (32 bit)

�� Red Hat Linux 3.0 (32 bit)

�� Solaris 8.0 and 9.0 (32 bit)

�� SUSE Linux 8.0 and 9.0

#��$��%��

The machine on which you install Data Quality for SAP Solutions must run the 32-bit version of the Java 2 Platform, Standard Edition (J2SE) version 1.4.2 or higher.

An installable version of the J2SE is not included in this software package. You must acquire, install, and run the J2SE independently of the installation and before the installation of Data Quality for SAP Solutions.

��

196958 Collective note: Errors in interface for duplicate check

197217 Composite note: Various errors in quarterly adjustment

197803 Composite note: Error with interface for address check

710565 Termination with AM897 when calling ADDR_PERSONAL_GET_ARRAY

%" ��

��&�� The Business Objects software that powers Data Quality for SAP Solutions requires that you have an Intel or compatible processor with a minimum clock speed of 1 GHz, or a RISC processor of comparable power.

'�� &��(��$)��

68��0�� $��*��

The RFC Server for your Data Quality for SAP Solutions installation requires 117 MB of disk space.

��

��

��

All supported Windows oper-ating systems

256 MB 512 MB

All supported UNIX operat-ing systems

512 MB 1 GB

In Windows 2003 Server, the user account that runs the RFC Server must also have full permissions to access the subdirectories that contain the address directories.

�� %"��&� �� %#

.��$��

The installation of Data Quality for SAP Solutions requires these tasks:

1. Install BusinessObjects Data Quality XI Release 2 and copy the Data Quality for SAP Solutions dataflows.

2. Install the RFC Server.

3. Install the Data Quality Business Add-Ins.

4. Perform the “SAP handshake with RFC server” IMG activity.

5. Load the supported countries.

6. Activate duplicate check index pools.

7. Run Quarterly Adjustments.

8. Run the initial setup program.

�) ��

��/��+��$��

This section describes issues unique to installing BusinessObjects Data Quality XI Release 2 as part of Data Quality for SAP Solutions, including a procedure to copy the Data Quality for SAP Solutions dataflows and transforms from the “BusinessObjects Data Quality XI for SAP – Dataflows” CD. You must complete the installation and configuration of Data Quality before proceeding to rest of the installation of Data Quality for SAP Solutions.

2��/��+ You must install Data Quality before installing the RFC Server or BAdIs. You can find instructions for installing, configuring, and running Data Quality in the Data Quality documentation you received in this package.

*��+��

You can install Data Quality on the same machine as the RFC Server, on a different machine, or even on a machine with a different operating system than the one that contains your installation of the RFC Server. Information about the system requirements for the machine on which you install Data Quality are included with the Data Quality documentation.

*��+��

If you are already an BusinessObjects Data Quality Data Quality XI Release 2 customer (prior to the purchase and installation of Data Quality for SAP Solutions) and therefore have already installed a version of Data Quality that you want to use with Data Quality for SAP Solutions, you must upgrade to BusinessObjects Data Quality XI Release 2 Version 11.6.0.0. See the Data Quality documentation for details of how to upgrade.

� !"�� ,!��!��-��

For UNIX installations of Data Quality, if you use the international address engine within the address-cleansing engine, you must install the International ACE runtime environment on your system from the “Runtime Environment for International Address Engine” CD. This installation requires that you have root access.

For detailed instructions, see the Data Quality Administrator’s Guide and the document International Address Processing: Installing The Runtime Environment for UNIX Platforms, which are included with your shipment if you purchased international address support.

��/��+

After you have installed Data Quality, you must perform additional procedures to prepare Data Quality for use as part of Data Quality for SAP Solutions.

�� (��(��*��+��

The “BusinessObjects Data Quality XI for SAP – Dataflows” CD contains dataflows and transforms in the form of .xml files that are specific to the functionality of Data Quality for SAP Solutions. You must copy the dataflows and transforms from this CD to your Data Quality installation.

The International Address Processing runtime environment is sometimes referred to as the COBOL runtime environment. These names refer to the same product.

�� %"��&� �� %

To copy the dataflows and transforms to your Data Quality installation:

1. From the “BusinessObjects Data Quality XI for SAP – Dataflows” CD, copy the folder repository (and all the folders and files within) to the folder DQinstall\, where DQinstall is the location of your Data Quality installation (by default, c:\dqxi\11_6).

2. When prompted for permission to overwrite files, choose “Yes to all.” The files are copied to their correct locations in subdirectories of the folder DQinstall\repository\.

%��.��

After installing Data Quality, you must enable in Data Quality the address cleanse engines for the countries that your installation of Data Quality for SAP Solutions supports to ensure that Data Quality uses the proper directories during data quality operations. You must also disable any unused engines that are enabled.

For information on enabling and disabling country engines in Data Quality, see “Enable and disable country engines” on page 92.

!If you have a previous installation of Data Quality for SAP Solutions that uses Data Quality and you have customized any dataflows or transforms, copying the dataflows and transforms from the CD will overwrite the existing files and therefore overwrite any customizations you have made. Before copying the dataflows and transforms to your Data Quality installation, you should make a backup copy of all the files in the DQinstall\repository\ folder. You can then use these backup files to recreate your customizations in the new files.

For a description of important dataflows and transforms, see “Data Quality dataflows” on page 91.

��

2��68��0��

The next step in installing Data Quality for SAP Solutions is installing the RFC Server.

The following procedures describe the installation and running of the RFC Server.

2��68��0�� $��

To run duplicate search functionality in batch mode (often called “batch match”), you must run a dedicated RFC Server to handle these tasks. For more information about setting and configuring this dedicated RFC Server, see “Maintain operating parameters” on page 60.

2��68��0�� ,��(

To install the RFC Server on Windows:

1. On a machine that meets the system requirements for the RFC Server (see “Requirements for the RFC Server” on page 18), insert the CD labeled “BusinessObjects Data Quality XI for SAP – RFC Server,” navigate to the location of the CD, and launch the file setup.exe.

The installation begins and the Data Quality confirmation window appears.

2. Click Yes to confirm that you have first installed Data Quality. The Welcome window appears.

3. Click Next. The License Agreement window appears.

4. After reading and accepting the license agreement, click Next. The Choose Destination Locations window appears.

5. After choosing the destination folder, click Next. The SAP Information window appears.

6. Enter the Host Name and Service of the SAP Gateway.

On the same screen, click Yes or No to indicate whether your system is Unicode compliant. Click Next.

The SAP Basis window appears.

You must install the RFC Server from a user account that has permissions to install software on the machine.

By default, the installation routine installs the RFC Server to the folder C:\Program Files\BusinessObjects\DataQuality_for_SAP. Though you can use the Browse button to change the destination folder, Business Objects recommends that you install to this default directory, and you must install to a path that finishes with [your_path]\BusinessObjects\DataQuality_for_SAP.

The host name can be filled by either the name or IP address of the SAP Gateway.

If your system is Unicode compliant, the step “SAP handshake with RFC server” on page 34 has further configuration instructions on configuring Data Quality for SAP Solutions for Unicode systems.

�� %"��&� ��

7. Click the appropriate radio button to indicate whether your SAP Basis version is 6.40 or above, or a version prior to 6.40. (The installer uses different files depending on your Basis version.) Click Next.

The Data Quality Connection Options window appears.

8. Click the appropriate radio button to indicate whether you want the installation to gather your Data Quality settings automatically or if you want to enter them manually.

If you select automatically, you must provide the Data Quality server host name and the location of the Data Quality bootstrap file. (The bootstrap file is typically located in DQinstall\repository\configuration_rules\.)

If you select manually, you must provide the Data Quality server host name, Data Quality port number, Data Quality repository path, and Data Quality substitution file name.

Proceed through the screens. At completion, the Integrated Batch Port Number screen appears.

9. Accept the default values for Low Port and High Port numbers, unless you know that range of values is already in use. Otherwise, enter appropriate values. Click Next. The Ready to Install the Program window appears.

10. Click Install. The RFC Server installation proceeds. When the installation has finished, the Installshield Wizard Complete window appears.

11. Click Finish. The RFC Server is now installed on your system.

2��68��0�� 4�25

To install the RFC Server on UNIX:

1. Place the “BusinessObjects Data Quality XI for SAP – RFC Server” CD in the CD-ROM drive.

2. Mount the CD.

3. Open a console window.

4. Change the directories to point to the CD-ROM drive.

5. Type install_console and press Enter.

The installation begins and the “Welcome” text appears.

6. Press 1 and Enter to go to the next screen. The “License Agreement” text appears.

7. After you read all pages and accept the license agreement, make sure the X is in the appropriate box and press 0 to accept the license agreement. Press 1 and Enter to go to the next screen.

The Data Quality and Java confirmation text appears.

8. Confirm that you have installed Data Quality and the Java Runtime Environment. Press 1 and Enter to go to the next screen.

The “Install Directory” text appears.

9. Enter a directory path for the install directory and confirm that you want to create the new directory.

� ��

Press 1 and Enter to go to the next screen. The “Host” text appears.

10. Enter the SAP Gateway Host name.

Press 1 and Enter to go to the next screen. The “SAP Service” text appears.

11. Enter the SAP Service name. Press 1 and Enter to go to the next screen. The “Unicode” text appears.

12. Indicate whether this machine supports Unicode. Press 1 to go to the next screen. The “Basis information” text appears.

13. Indicate whether your SAP system is Basis version 6.40 or above. (The installer uses different files depending on your Basis version.) Press 1 and Enter to go to the next screen. The “Data Quality interview” text appears.

14. Indicate whether you want the installation to gather your Data Quality settings automatically or if you want to enter them manually.

If you select automatically, you must provide the Data Quality server host name and the location of the Data Quality bootstrap file.

If you select manually, you must provide the Data Quality server host name, port number, repository path, and substitution file name.

Proceed through the screens for your Data Quality interview selection. At completion, the installation begins, goes to completion, and the RFC Server is installed on your system.

0��68��0�� You can find the batch file to start the RFC Server in the install directory of the machine on which you installed the RFC Server.

install_directory\start_rfcserver.bat

(On UNIX, the file is start_rfcserver.)

You can launch this file from the command line or in Windows by double-clicking the file in the Windows Explorer.

Business Objects recommends that you install to a newly created directory such as /local/apps/SAP/BusinessObjects/DataQuality_for_SAP.

The host name can be filled by either the name or IP address of the SAP Gateway.

If your system is Unicode compliant, the step “SAP handshake with RFC server” on page 34 has further configuration instructions on configuring Data Quality for SAP Solutions for Unicode systems.

The remaining sections of these installation instructions are “Windows-centric” in the sense that the paths are suitable to a Windows installation. The procedures are fundamentally identical in UNIX, and should be read with that understanding.

�� %"��&� ��

0��$��68��0�� To stop the RFC Server:

1. Use transaction SMGW. For information on the use and syntax of transaction SMGW, consult your SAP documentation.

Using transaction SMGW is the preferred method to stop the RFC Server. However, if you are running multiple RFC Servers with the same TP name, this method may simultaneously stop all RFC Servers with that TP name (for more information, see SAP Note 923248).

2. On the machine that hosts the RFC server, use Ctrl-C in the RFC Server console to terminate the RFC Server process. Note that this method may on rare occasion cause SAP to show a connection to the RFC Server after the RFC Server has stopped.

When the RFC Server starts, it looks for the SAP Gateway and your installation of Data Quality. Therefore, you should have both the SAP Gateway and Data Quality running before starting the RFC Server. If the Data Quality portion of this product is stopped for any reason, you must restart Data Quality and then restart the RFC Server to reinitialize the Data Quality dataflows.

Additionally, the RFC Server looks for the Java Runtime Environment. Therefore, the Java runtime must be installed relative to where the RFC Server startup script runs, or you must set the JAVA_HOME environment variable to where Java is installed so that the RFC Server can find it.

��

2��/��+��0��0��7��2

With the RFC Server running, you can now install the Data Quality for SAP Solutions Business Add-Ins (BAdIs).

After you have made sure that your SAP system complies with all prerequisites as described in “System requirements” on page 18, there are four steps to installing the Data Quality for SAP Solutions BAdIs:

1. Import the Data Quality for SAP Solutions package on the reference client (client 000).

2. Insert the Data Quality for SAP Solutions IMG structure on the reference client (client 000).

3. Activate the Business Configuration Sets on all target/reference clients (non-000 clients).

0��$�%&�2�$��/��+�$��9��)))

Import to the reference client (client 000) the Data Quality for SAP Solutions package, which is in the form of a .SAR file, from the “BusinessObjects Data Quality XI for SAP – PV and DES Business Add Ins” CD using the SAP Add-On Installation Tool, which you invoke with the transaction SAINT. Make sure that the contents of that CD are available in a disk drive or on the network.

��/�-$(�� For Basis 46C, you must install the following:

Also, you must (re)activate BC Set /FLDQ/AAK25 to import new customizing data.

For Basis 6.20, you must install the following:

Throughout the installation of the Data Quality for SAP Solutions BAdIs, the exact look of SAP windows and other GUI elements may differ from those presented here, depending on the version of SAP you run. At times in these procedures, you may find intermediary screens that your version of SAP shows in between steps of these procedures. Therefore, these procedures rely in part on your knowledge of SAP administration to help you successfully navigate through the installation. However, you must fulfill each step outlined in these procedures.

The BAdIs are installed and upgraded using the Add-on Installation Tool, invoked by the transaction SAINT.

��

SAPK-38ACOINFLDQ.SAR New install

SAPK-38ACHINFLDQ.SAR Upgrade

��


SAPK-38ACHINFLDQ.SAR Existing customer upgrade from 2.00c Rev 3 or above

�� %"��&� ��

Also, you must (re)activate BC Set /FLDQ/47U6X to import new customizing data.





��(��!��

If you intend to use the functionality of Data Quality for SAP Solutions within the IC WebClient, you must import a second .SAR file, SAPK-38BCHINFLDQ.SAR.

For information on the requirements and configuration procedures to use the functionality of Data Quality for SAP Solutions within the IC WebClient, see “Install and configure Data Quality into the IC WebClient” on page 45.

!��*��+��

To import the Data Quality for SAP Solutions package:

1. Enter the transaction SAINT. The Add-On Installation Tool window appears.

2. From the Installation packages menu, select Load packages->From frontend. The Select CAR/SAR archive dialog appears.

3. Browse to the \DATA directory of the “BusinessObjects Data Quality XI for SAP – PV and DES Business Add Ins” CD, and locate the .SAR file.

4. Select the .SAR file and click the Open button.

5. Click the Yes button to load the file. A dialog is displayed showing the contents of the .SAR file.

��



��



If you use Basis 7.00, you must have the SPAM 21 update/patch to be able to load the .SAR package. (For more information, see SAP Note 822379.)

�" ��

6. Click the Decompress button. The Add-On Installation Tool window is displayed, this time with the contents of the Data Quality for SAP Solutions BAdIs listed in the table entitled “Installable add-on and PCS Packages for your system.”

7. Click the Continue button. A confirmation window is displayed indicating that the Add-on FLDQ (named for the namespace you created previously) will be installed.

8. Click Enter on the confirmation dialog. The import continues and may require approximately five minutes.

After the import finishes, you can choose to view logs.

9. Click the Finish button. The Add-On Installation Tool window is displayed, now with confirmation that the Add-on was installed successfully.

�� %"��&� �� #

10. Click the Cancel button because there are no additional Add-ons to install.

0��$��&�2��/��+�21:��)))

After you import the Data Quality for SAP Solutions BAdIs, you must link the Data Quality for SAP Solutions IMG structure to your SAP Reference IMG structure.

To link the Data Quality for SAP Solutions IMG structure to your SAP Reference IMG Structure:

1. Log on to client 000 of your system.

2. Type S_IMG_EXTENSION into the command field and click Enter. The Edit IMG structure window appears.

3. Select the Possible entries button on the “IMG Structure” field.

) ��

The Find structure dialog appears.

4. Enter Address Management on the Title field.

5. Click the Execute button. A dialog appears in order to confirm that the Address management structure exists.

6. Double-click the Address management node to return to S_IMG_EXTENSION.

7. Place the cursor in the Enhancement ID field and click the possible entries dropdown. The Choose enhancement ID dialog appears.

8. In the Choose enhancement ID dialog, double-click the entry /FLDQ/AD_IMG. The Edit IMG structure window appears.

9. Click the Enhance structure button. One or possibly two Information dialogs appear.

10. Click Enter each time to clear the Information dialog boxes.

11. Highlight the last of the Address Management sub nodes.

12. Choose Edit > Nodes > Insert IMG Structure > on same level.

The Reference to a structure dialog appears.

13. Click the Find button. The Find structure dialog appears.

14. Enter BusinessObjects in the title field of the Find structure dialog and click Execute.

�� %"��&� �� %

15. Double-click to select BusinessObjects : Global Data Quality Connector.

The Reference to a structure dialog appears.

16. Highlight the contents of the field “The node refers to the structure” and press Ctrl-C to copy.

17. Place your cursor in the “Node name” field and press Ctrl-V to paste. Copying and pasting ensures that the name is reproduced precisely.

18. Click Enter.

19. Click Save. The Change Request dialog appears.

20. Click the Create button in the Change Request dialog.

21. Enter a name for the change request and click Save.

22. Click Enter to clear the task dialog.

You have now completed the linking. To verify that the Data Quality for SAP Solutions IMG structure has been correctly inserted into the SAP Reference IMG structure:

� ��

1. Enter transaction /nSPRO in the command box.

2. Click the SAP Reference IMG button, and navigate the following path, depending on your Basis version.

You should now see the entry BusinessObjects : Global Data Quality Connector within the IMG structure.

3. Exit R/3 or CRM.

You are now finished with the installation steps required on the reference client (client 000), and can proceed to the steps required on the target clients.

0��$�&�� 7��0��

After you import the Data Quality for SAP Solutions IMG structure, you must now activate the Business Configuration Sets on each of the target clients (non-000, logon clients) that you want to configure for use with Data Quality for SAP Solutions.

To activate the Business Configuration Sets:

1. From a target client that you want to configure for use with Data Quality for SAP Solutions, enter /nSCPR20 to navigate to the Business Configuration Sets : Activation transaction.

2. Type /FLDQ/AAK25 (for R/3 v. 4.6) or /FLDQ/47U6X (for all other versions) in the BC set input field and click Enter.

The following Short text appears: Business Configuration Set for BusinessObjects AAK 06-21-07. (The date may vary.)

3. Click the Activate button or select Activate from the BC Set menu.

4. Create a new change request when the window appears. (You may receive a Caution window, which can be dismissed.)

5. On the Activation Options window, click the Continue Activation (Enter) button. An Activation completed message appears at the bottom of the window.

6. Repeat these steps for each target client that you want to configure for use with Data Quality for SAP Solutions.

�� !

46c (R/3 4.6) Basis Components > Basis Services > Address Management

620 (R/3 4.7 and CRM 4.0)

SAP Web Application Server > Basis Services >Address Management

640 (ECC 5.0) SAP NetWeaver > SAP Web Application Server > Basis Services > Address Management

700 (ECC 6.0 and CRM 5.0)

SAP Web Application Server > Application Server > Basis Services > Address Management

�� %"��&� ��

0��9��(��68��

Now that you have installed the components of Data Quality for SAP Solutions, you must make some post-installation configurations on each target (non-000) client, one-by-one, before running Data Quality for SAP Solutions.

The Data Quality for SAP Solutions IMG activity “SAP handshake with the RFC server” is a mandatory activity that you conduct through the Implementation Management Guide (IMG).

You can find this activity within the IMG structure by following this process:

1. Use the transaction SPRO to access the Implementation Guide for R/3® Customizing (IMG) structure.

2. Navigate down the structure to the following location:

Implementation Guide for R/3® Customizing (IMG) > Basis Components > Basis Services > Address Management > BusinessObjects : Global Data Quality Connector> SAP handshake with the RFC server

��$�� + This activity allows you to define the RFC destination and test whether the components of Data Quality for SAP Solutions are able to communicate by invoking a TCP/IP handshake.

The first time this activity is invoked, you must define the RFC destination.

��68��

The RFC Server is an RFC server used to perform postal validation and duplicate check functions on data sent by the SAP system. To communicate with the RFC Server from within the IMG, you must define the RFC destination for the server.

To define the RFC destination:

1. From the IMG on a target (non-000) client, click on the activity “SAP handshake with the RFC server.” The “Display and maintain RFC destinations” window appears.

2. Click the button Create. The RFC Destination window appears.

3. Fill in the fields of the RFC Destination window as follows:

RFC Destination: FL_GDQC_SERVER

Connection type: T

Description: Connection to BusinessObjects GDQC RFC Server

On SAP versions that use Basis 7.00, this window is labeled “Configuration of RFC Connections.”

By default, Data Quality for SAP Solutions expects the name of the RFC destination to be FL_GDQC_SERVER. If you choose not to use the name FL_GDQC_SERVER, you must go to the activity “Maintain operating parameters” on page 60 and ensure that the value of the RFC_DEST parameter is the name of the chosen RFC destination.

��

4. Save the settings (Ctrl+S).

5. Click the Registration button (in R/3) or choose the Registered Server Program radio button (CRM) to make the Activation Type Registration. This setting is desired because the RFC Server is registered on the SAP gateway as an RFC server.

6. Type the Program ID as FLRFCSRV.

7. Click the Test Connection button.

If the RFC Server is running and the connection is successful, a confirmation appears.


9. If you are installing Data Quality for SAP Solutions on a Unicode system: select the Special Options tab.

10. If you are installing Data Quality for SAP Solutions on a Unicode system: in the Character Width in Target System field, select the Unicode button.

By default, Data Quality for SAP Solutions expects the Program ID to be FLRFCSRV. If you choose not to use the Program ID FLRFCSRV, you must edit the <sap_progid> setting in the configuration file flrfcsrv.xml. For details on editing this configuration file, see “Configuring through flrfcsrv.xml” on page 66.

If you are installing Data Quality for SAP Solutions on Unicode system, you must perform steps 9-11.

On SAP versions that use Basis 7.00, this tab is labeled “MDMP & Unicode.”

�� %"��&� ��


��

� ��

;��$$��+��

Now that you have connected your SAP system to the RFC Server, you must load into each target (non-000) client the supported countries on which Data Quality for SAP Solutions can perform postal validation.

6��$��

To load supported country codes:

1. On a target (non-000) client, run transaction SA38. The ABAP: Execute Program window appears.

2. In the “Program” field, specify /FLDQ/AD_REPT_LOAD_COUNTRIES.

3. Click the Execute button.

The supported countries are loaded into a table that you can maintain from the IMG activity Maintain Supported Countries.

4. Repeat steps 1-3 on each target client that you want to configure for use with Data Quality for SAP Solutions.

!Because of a known issue on AIX, the first time the user executes the FLDQ/AD_REPT_LOAD_COUNTRIES program, the RFC Server will fail (timeout). After this occurs, restart the RFC Server and run the program again.

After loading the country codes with this step, you can optionally configure Data Quality for SAP Solutions by removing country codes for which you have not purchased support by using the Maintain Supported Countries IMG activity.

For details, see the section “Maintain Supported Countries” on page 52.

�� %"��&� ��

�� $��9��<�$��

The next step in setting up Data Quality for SAP Solutions is to run on each target (non-000) client the standard SAP IMG activity “Activate duplicate check index pools.”

You can find this activity within the IMG structure by following this process:

1. On a target (non-000) client, use the transaction SPRO to access the IMG structure.

2. Navigate down the structure to the following location:

Implementation Guide for R/3® Customizing (IMG) > Basis Components > Basis Services > Address Management > Activate duplicate check index pools

��$�� +

This activity creates the standard SAP index pools, KNA1 and BUT000, which are useful when Data Quality for SAP Solutions searches for duplicate data. Initially, the index pools are not active.

�� <�$��

To activate the two standard SAP index pools:

1. From the IMG, click on the activity “Activate duplicate check index pools.” The “Customizing settings for logical search pools: Overview” window appears.

2. For index pool BUT000, enter 90 in the Threshold field and check the Index active box. A checked box activates the index pool.

3. R/3 only: For index pool KNA1, enter 90 in the Threshold field and check the Index active box. A checked box activates the index pool.

Though this activity is part of the standard SAP functionality and not added specifically by Data Quality for SAP Solutions, it is required for the proper functioning of Data Quality for SAP Solutions. You must perform this procedure on each target (non-000) client. Data Quality for SAP Solutions relies on these duplicate check index pools to perform its duplicate check processes.

This IMG structure assumes you are running R/3. The IMG structure for a CRM or ECC system is similar. However the IMG nodes on your system are arranged, you must reach the node “Activate duplicate check index pools” to perform this procedure.

" ��


5. Repeat the entire process for each target (non-000) client.

!Warning: When you activate index pools in SAP CRM systems, you should not activate the index pool KNA1 ADRNR. If you have previously activated index pool KNA1 ADRNR in a SAP CRM system, you should deactivate it. This functionality is not supported in SAP CRM systems.

�� %"��&� �� #

/��+��=��6�$��

The next step in setting up Data Quality for SAP Solutions is to run Quarterly Adjustments. You must run Quarterly Adjustments on each target (non-000) as part of the installation and configuration process to perform postal validation on the existing data in your SAP system.

SAP provides standard reports for Quarterly Adjustments, which allow you to validate all the addresses in your database in a three-step batch process. You may want to run Quarterly Adjustments other times after this installation on a regular, pre-determined schedule and you should run Quarterly Adjustments after installing new Data Quality address directories from Business Objects to validate data that may have changed due to the renaming of streets, the development of new areas, and so on.

If you did not have Data Quality for SAP Solutions installed, to run a Quarterly Adjustment Report, you would execute the defined SAP reports RSADRQU1, RSADRQU2, and RSADRQU3. Installing Data Quality for SAP Solutions allows you to substitute the second of these standard reports, RSADRQU2, with the custom report /FLDQ/RSADRQU2, and take advantage of the postal validation capabilities provided by Data Quality for SAP Solutions.

The running of these reports exchanges records between SAP and the RFC Server. Then the validated and updated addresses are committed to the SAP database.

6�$��60��6/4% You use report RSADRQU1 to select the addresses that are to be cleansed. To run the report:

1. On a target (non-000) client, start the report RSADRQU1 by running the transaction code SA38.

The “ABAP Execute Program” window appears.

2. In the Program field, enter RSADRQU1 and click the Execute button (F8).

The “Create an address index for the quarterly adjustment” window appears, presenting several options.

3. Specify the countries for which the quarterly adjustment is to be performed. This field is required by default.

4. Specify the cities within the selected country or countries for which the quarterly adjustment is to be performed. This field is optional.

5. Specify the postal code or range of postal codes for which the Quarterly Adjustment is to be performed. This field is optional.

6. Change the packet size only if you have experienced problems in running Quarterly Adjustment Reports previously.

Business Objects recommends that you maintain the default setting for packet size of 1000 records. This number determines how many records are processed and stored at one time. All addresses that meet the selection conditions are read, regardless of the packet size. The setting should be adjusted only in response to performance issues previously encountered.

) ��

7. Select the radio button to exclude, check additionally, or check separately addresses that have not previously been subjected to postal validation. This setting is not relevant to Data Quality for SAP Solutions’s functionality, so the setting will not affect the results of postal validation.

8. Select the appropriate radio button either to cancel the Quarterly Adjustment if INDX exists or to overwrite the existing INDX.

Running RSADRQU1 creates a temporary table called INDX, which is used by the other two Quarterly Reports and deleted when the process completes successfully. If the Quarterly Adjustment Reports process did not complete successfully, the INDX table from the failed attempt may still be available. This option allows you to cancel the Quarterly Adjustment process rather than overwrite the existing data, or to proceed creating INDX with the current parameters.

You must select “Overwrite existing INDX” if the Quarterly Adjustment is terminated for some reason and you want to start it again.

9. Click the Execute button (F8) to run RSADRQU1.

A confirmation window appears.

6�$��>8;�/>60��6/4�

Instead of the defined SAP report RSADRQU2, you next execute the report /FLDQ/RSADRQU2. You use this report to read the addresses stored temporarily in INDX and update INDX.

1. Start the report /FLDQ/RSADRQU2 by running the transaction code SA38.


2. In the Program field, enter /FLDQ/RSADRQU2 and click the Execute button (F8).

The “Check and update address data in quarterly adjustment” window appears.

3. Check the “Clear Previous Error Codes” box to clear error codes from previous runs or uncheck the box to have the new error codes appended.

Check the “Skip D records during the Quarterly adjustment process” box only if you want to run postal validation without checking D records.

A confirmation window appears. If any records failed during validation, those records are shown here.

A D record is a record that has its check status set to D. There are three possible check status values.

� C = Postal or address data is known and does not contain any errors� D = Postal or address data may have errors� “ ” = Postal Validation has not been run

If a record has a check status set to D, the address in that record has previously been checked and the user selected to save the address without cleansing it. Records with a check status of D may contain faulty address data as a result. When running report /FLDQ/RSADRQU2, you may want to skip D records because a user has already made the decision to save the address without cleansing it.

�� %"��&� �� %

��0��(��.)1*+.$�-*$+�2

The system uses the “Clear Previous Error Codes” check box to determine whether the report saves validation errors logged from previous runs of the Quarterly Adjustments, or errors only from this run.

The check box “Clear Previous Error Codes” affects the content of the report displayed as a result of running the custom error report /FLDQ/AD_REPT_DISP_QTRERRORLOG. It does not affect the content of the error log that appears automatically after you run the final Quarterly Adjustment Report.

6�$��60��6/4 You use report RSADRQU3 to commit updates to the SAP database with the validations performed in /FLDQ/RSADRQU2.

To run the report:

1. Start the report RSADRQU3 by running the transaction code SA38.


2. In the Program field, enter RSADRQU3 and click the Execute button (F8).

A confirmation window appears, indicating that the addresses have been removed from postal check and committed to the database. If the Quarterly Adjustment process finds that any records are incorrect, the window displays a list of those records. You should next run a Quarterly Adjustment custom error report, which provides you a hyperlink to each of these records so that you can directly edit each record as necessary.

If the report terminates or is terminated prematurely for any reason, it can be started again at any time. When this report has finished, the system displays an error log of all addresses that could not be updated on this run of Quarterly Adjustments.

!If execution errors occur when you run the report /FLDQ/RSADRQU2, you must not run the report RSADRQU3 next. All three of the Quarterly Adjustment reports must be run successfully in sequence. Running RSADRQU3 on data resulting from a failed run of /FLDQ/RSADRQU2 can compromise the integrity of the data written back to the SAP system.

!While RSADRQU3 is in process or not started, the Quarterly Adjustment remains active. If addresses are changed using other SAP business transactions while the quarterly adjustment is in process, these addresses can not be updated by report RSADRQU3. You must complete the Quarterly Adjustment process before making other changes to the postal address data if you want the new data included in the adjustments.

� ��

/��+��=��$��

Data Quality for SAP Solutions provides a custom error report, /FLDQ/AD_REPT_DISP_QTRERRORLOG, which you can use to display the address validation errors that occurred during all Quarterly Adjustment runs since the last time you cleared the previous error codes.

To run the Quarterly Adjustment custom error report:

1. Start the report /FLDQ/AD_REPT_DISP_QTRERRORLOG by running the transaction code SA38.

The ABAP Execute Program window appears.

2. In the Program field, enter /FLDQ/AD_REPT_DISP_QTRERRORLOG and click the Execute button (F8).

The Display Address Errors generated during Quarterly Adjustment window appears. At this window you can set limits to filter and sort the displayed results.

3. Set any filters and click the Execute button (F8).

An error log is displayed showing a list of records on which postal validation errors occurred. Each field item is a hyperlink to the record itself, which you can use to go to the record for direct editing.

You must repeat the entire procedure for running Quarterly Adjustments for each target (non-000) client as part of the installation of Data Quality for SAP Solutions.

�� %"��&� ��

6��$�$��

The last step in setting up Data Quality for SAP Solutions is to run the initial setup program on each target (non-000) client.

��$��$

The initial setup program prepares your existing data for matching with duplicate check and error tolerant search.

6��$ To run the initial setup program:

1. Enter transaction SA38 in the command box.


2. In the “Program” field, enter /FLDQ/RSADRINI and click the Execute button (F8).

The program executes. Installation and setup are complete in this target (non-000) client.

3. Repeat steps 1-2 on each target client that you want to configure for use with Data Quality for SAP Solutions.

!Before running the initial setup program, you must run Quarterly Adjustments to perform postal validation on the data that already exists in your SAP system.

You should execute the FLDQ/RSADRINI program only when users are not updating records in the system, such as during the initial setup.

When users are working in the SAP system and updating records, use instead the /FLDQ/RSMTCCODE program (Match Code Creation Program). This program performs the same function as the RSADRINI program, but on only a subset of the data. This program simultaneously locks records as it runs so that you can run it while users are updating records in the system.

��

2��/��+��2��,��

This section describes the requirements and procedures to install the functionality of Data Quality for SAP Solutions into your IC WebClient environment.

6�*��/��+��0��0��2��,��$��

To run the functionality of Data Quality for SAP Solutions within your IC WebClient profiles, you must meet the following minimum requirements in your SAP system.

��$�� (��2��,��

SAP has provided a mechanism for customers to replace SAP’s IC WebClient views and controllers with third party views and controllers. Data Quality for SAP Solutions contains enhanced versions of the Business Partner Create (BuPaCreate) view and controller. If you are currently using the SAP-provided version of these objects, you can use the instructions in this section to configure your system to use the version shipped with Data Quality for SAP Solutions. If you are currently using an already modified version of these objects, you can use the instructions below to add the postal validation functionality to your modified objects. These instructions can also be used to add postal validation functionality to new views within your environment.

0��+��9

All users of the IC WebClient have a unique profile. To run the functionality of Data Quality for SAP Solutions into your IC WebClient profiles, a Basis Administrator must configure the profile by replacing the BuPa controller of each profile with the BuPa controller provided by this product. The configuration is manually performed because overwriting the existing BuPa controller with the BuPa controller provided with this product would also overwrite any customizations that have been performed prior to the installation of this product.

Make sure that you have imported the file SAPK-38BCHINFLDQ.SAR into your SAP system. For information on importing .SAR files, see “Installing the Data Quality for SAP Solutions BAdIs” on page 27.

�� 70��7��0��

To activate the BSP Business Configuration Sets:

1. From a target client that you want to configure for use with Data Quality for SAP Solutions, enter transaction /nSCPR20 to navigate to the Business Configuration Sets : Activate transaction.

2. Type /FLDQ/BSP_PV in the BC set input field and click Enter.

The following Short text appears: BC Set for BusinessObjects BSP_PV Product 02/08/07. (The date may vary.)

3. Click the Activate button or select Activate from the BC Set menu.

4. Create a new change request when the window appears. (You may receive a Caution window, which you can dismiss.)

" ��

Postal Validation SAP CRM 4.0 and above

Duplicate Check/Error-Tolerant Search SAP CRM 5.0 and above

�� %"��&� ��

5. On the Activation Options window, click the Continue Activation (Enter) button.

An Activation completed message appears at the bottom of the window.

6. Repeat these steps for each target client that you want to configure for use with Data Quality for SAP Solutions.

��2��,��/��+��0��0�� (��

To configure IC WebClients to use the functionality of Data Quality for SAP Solutions views and controllers:

1. Navigate the IMG structure to IMG > CRM > WebClient > Customer-Specific System Modification > Define IC WebClient Runtime Framework Profiles, and select this activity. The Editor XML Data screen appears to modify the Component IC WebClient Runtime Framework Profiles.

2. Add the following XML markup within the <ControllerReplacements> </ControllerReplacements> tags.

<ControllerReplacement><ReplacedController>BuPaCreate</ReplacedController> <ReplacingController>

/fldq/BSP_DQ/BOBJ_BuPaCreate</ReplacingController>

</ControllerReplacement>

�� >8;�/>70�?�/��

Next, you must activate the /FLDQ/BSP_DQ service.

To activate the /FLDQ/BSP_DQ service:

1. Enter transaction SICF. The Maintain service window appears.

2. Navigate through the services hierarchy to default host > sap > bc > bsp > FLDQ.

3. Right-click on FLDQ, and select Activate Service from the context-sensitive menu.

� ��

��$�� +��2��,�� (

The enhancement to the BuPaCreate view was designed with portability in mind. You can add postal validation functionality to other views within the IC WebClient by copying the enhanced code from the BuPaCreate view to the destination view and configuring the form values postal validation should use.

-��

To add postal validation code to the destination view:

1. Open the destination BSP application and view in the SAP Web Application Builder.

2. Create a new session.

3. In the SAP Web Application Builder, open the BSP application /FLDQ/BSP_DQ.

4. Open the BOBJ_BuPaCreate.htm view in the layout tab.

5. Find the beginning of the enhanced code by searching for “Beginning of changes for adding Business Objects BSP_PV Functionality”. This text marks the beginning of the enhanced code.

6. Find the end of the enhanced code by searching for “End of changes for adding Business Objects BSP_PV Functionality”.

7. Copy the enhanced code and insert it into the destination view.

8. Add the following attribute to the Save CRMIC:Button tag at the bottom of the destination view.

��

9. Replace BOBJ_BuPaCreate.htm in the select statement with the name of the destination view.

10. Activate the view and fix any syntax errors.

11. Before continuing to the form configuration section, view the destination form within the IC WebClient to ensure it still displays correctly.

��(��(��(��

To configure form values for postal validation:

1. In the BOBJ_BuPaCreate.htm view in the layout tab, find the following tag:<textarea name = ‘BOBJ_ViewSource’ COLS=80 ROWS=80>

Remove the comments from this tag so that it will be parsed by the XML parser. This change allows the source code specific to this product to be visible within the Web browser by using a View > Source menu command.

2. View the destination page in the IC WebClient. The source for the form is now displayed in the text area form element.

3. Within the source, you can see the SAP-generated names of the data fields. These field names are unique to that SAP system. Make note of each field name, as you must map these fields to field names provided by this product.

4. Open the table AD.FORMMAP. Within this table, map the SAP-generated field names with the field names provided in this table. Save the changes.

5. With the fields properly mapped, copy the code provided in the Controller files provided in this product to the corresponding location within the Controller files of this profile.

�� %"��&� ��

6. Save the changes.

7. Repeat these steps for every IC WebClient profile.

-��(�� !��$'3/4� ��

To activate search functionality within the IC WebClient on a CRM 5.0 system:

1. Navigate down the IMG structure to the following location:

Customer Relationship Management > CRM Cross-Application Components > Generic Interaction Layer/Object Layer> Component-Specific Settings > Extend Object Model for Business Partner

The New Entries: Overview of Added Entries screen appears

2. In the New Entries: Overview of Added Entries screen, select the Implementation Class Definition folder.

3. For the Implementation Class Definition, add the following values:

��@��7��2��2��,��

To use Postal Validation within your IC WebClient environment, you must disable the standard Business Objects Postal Validation BAdI through the IMG activity “Maintain exception table of transaction codes.”

You must add the Program SAPMHTTP and suppress validation, search, and suggestions for it, as shown in this figure.

For information on adding this program to the exception table, see “Add a transaction code to the exception table” on page 53.

��(��

When creating new address records through the IC WebClient using this product, you must create the records using these steps:

1. Click the Create button.

2. Enter the address Data.

3. Click the Save button to save the record.

If you create address records with any other process, data may be stored incorrectly within the SAP database.

"�� #��

External Object Name BuilHeader

Implementation Class /FLDQ/CL_BOBJ_BUIL_HEADER

" ��

��$��&��21:

Now that you have installed both components of BusinessObjects Data Quality XI for SAP Solutions, you can configure it to handle postal validation and duplicate searching with settings appropriate for your business.

You can customize many aspects of Data Quality for SAP Solutions through the activities Data Quality for SAP Solutions adds to the SAP Implementation Management Guide (IMG).

This chapter explains those activities and the options you have for configuration.

�� '"��&��&��&��(� #

;��/��+�21:��

You can find the Data Quality for SAP Solutions IMG activities within the IMG structure by following this process:

1. Use the transaction SPRO to access the Implementation Guide (IMG) structure.

2. Navigate to the BusinessObjects : Global Data Quality Connector node. The navigation to this node path depends on the Basis version that you use.

The Data Quality for SAP Solutions activities are the nodes at the bottom level of this structure. The remainder of this chapter is a description of these activities.

�� !

46c (R/3 4.6) Basis Components > Basis Services > Address Management

620 (R/3 4.7 and CRM 4.0)

SAP Web Application Server > Basis Services >Address Management

640 (ECC 5.0) SAP NetWeaver > SAP Web Application Server > Basis Services > Address Management

700 (ECC 6.0 and CRM 5.0)

SAP Web Application Server > Application Server > Basis Services > Address Management

�) ��

0��9��(��68��

This activity allows you to define the RFC destination and test whether the components of Data Quality for SAP Solutions are able to communicate by invoking a TCP/IP handshake.

The activity is invoked for the first time during the installation and configuration of Data Quality for SAP Solutions. You can perform the activity again at any time.

For details of performing this activity, see page 34.

�� '"��&��&��&��(� �%

1��0�$$��

This activity maintains the ISO country codes for the countries for which Data Quality for SAP Solutions provides postal validation by making changes to the table /FLDQ/AD_VAL_CNT. The list of countries that are supported depends on the postal directories that you have licensed from Business Objects.

If you did not purchase support for all countries or if you do not want postal validation enabled for some of the supported countries for which you purchased support, you can remove those ISO country codes from the filter using this activity.

6�� +��

When you click the “Maintain supported countries” activity, the table /FLDQ/AD_VAL_CNT is displayed, showing the list of supported countries. From this display, you can remove from the filter those ISO country codes for which you do not want postal validation enabled.

To remove a country code:

1. Select the country code from the list of supported countries.

2. Click the Delete button.

3. Save the changes.

��

1��<��$��

This activity allows you to disable suggestion lists, preventing them from being displayed for specific transactions.

During postal validation, Data Quality for SAP Solutions takes ambiguous, incomplete, or inaccurate address data and offers the user a list of address data choices that fit the content of official postal directories. The list is called a suggestion list. The user must select the item from the suggestion list containing the appropriate address data in order for postal validation to continue.

There may be some transactions for which you do not want the user to be presented with a suggestion list and you may disable suggestion lists for those transactions.

By default, suggestion lists are enabled for all transactions. In the default window, there is a transaction code for DEFAULT that controls transactions but the check boxes are unmarked. By checking the Suppress Suggestions box for DEFAULT, you suppress suggestion lists for all transactions.

You can instead add transaction codes and suppress suggestion lists only for that code.

��<��$��

To add a transaction code to the exception table:

1. From the IMG, click on the activity “Maintain exception table of transaction codes.” The “Maintain exception table of transaction codes” window appears.

2. Click the New Entries button.

The “New Entries: Overview of Added Entries” window appears.

3. Enter a Transaction code to specify the transactions for which you do not want suggestion lists to appear.

4. Check the Suppress Validation box if you want to prevent postal validation for that transaction (not recommended).

5. Check the Suppress Search box if you want to prevent both error tolerant search and duplicate checking for that transaction (not recommended).

6. Check the Suppress Dialog box to prevent suggestion lists from appearing in dialog boxes.

7. Exit the window to save the changes and return to the “Maintain exception table of transaction codes” window.

Additionally, you can select and deselect the suppression check boxes directly from the “Change View ‘Maintain exception table of transaction codes’: Overview” window.

�� '"��&��&��&��(� �

In the following illustration, the transaction code XD01 has been added to the “Change View ‘Maintain exception table of transaction codes’: Overview” window. Check the appropriate boxes to suppress postal validation, duplicate searches, or duplicate suggestions.

In the following illustration, the table has a column to specify the Program name. This column is created as a result of importing the .SAR file for the IC WebClient.

For more information, see “Package for use with the IC WebClient” on page 28. To suppress validation, search, or suggestions in the IC WebClient, specify the Program name SAPMHTTP and check the appropriate boxes in that row.

!Warning: This activity also lets you disable both postal validation and error tolerant search/duplicate check on a transaction basis. However, Business Objects does not recommend disabling this capability because doing so would allow invalid address data and duplicates to be stored in your SAP system. Essentially, suppressing these capabilities turns off certain functionality of Data Quality for SAP Solutions without removing it from your SAP system. Suppressing only the suggestions without suppressing validation or searches ensures that invalid data is not stored.

Additionally, suppressing error tolerant search/duplicate check will prevent records from being stored in the table /FLDQ/AD_PUPDATE, where updated records are held before being committed to the SAP database.

� ��

1�� 0��$��9��$��

This activity lets you to define countries for which you want the SAP postal code check to be performed before Data Quality for SAP Solutions validates the rest of the address data.

Data Quality for SAP Solutions can validate addresses even if they do not contain a postal code. Therefore, by default, Data Quality for SAP Solutions disables a postal code check that SAP normally performs on the address before Data Quality for SAP Solutions validates the rest of the address data. Disabling the SAP postal code check allows Data Quality for SAP Solutions to perform postal validation on the data as it was entered by the user.

By default, this table is blank because there are no countries for which Data Quality for SAP Solutions needs a valid postal code before processing. You need to change this setting only if you want the SAP postal code check to be performed for a certain country.

��+��

To add a country to the table to activate SAP postal code check before postal validation:

1. From the IMG, select the activity “Maintain table to activate SAP postal code check before postal validation.” The “Maintain table to activate SAP postal code check before postal validation” window appears.

2. Click the New Entries button.

The “New Entries: Overview of Added Entries” window appears.

3. Enter in the ISO Country code field the two-letter ISO code for the country for which you want a postal check performed before complete address validation occurs.

4. Save the changes and exit the window. The “Maintain table to activate SAP postal code check before postal validation” window returns.

This activity exists only in case future versions of Data Quality for SAP Solutions support additional countries for which a postal check must occur for proper address validation. This activity does not assist this version in performing address validation.

�� '"��&��&��&��(� ��

1�� (��

This activity allows you to define which fields are displayed in the address reviewer dialog and the order of those fields.

During postal validation, Data Quality for SAP Solutions may modify the address data to make the address data conform more completely to the data in official postal directories. If Data Quality for SAP Solutions modifies the address data, it displays a dialog containing both the original and modified address data. The user can choose either to keep the original data or to accept the modified data.

Because standard street address data and P.O. Box data require different sets of fields for postal validation, you must define the fields for both address types.

8��

By default, the following fields are displayed for standard street addresses and given the following order:

1. BUILDING

2. HOUSE_NUM1

3. STREET

4. CITY

5. REGION

6. POST_CODE1

7. COUNTRY

8��A'A�7�<��

By default, the following fields are displayed for P.O. Box addresses and given the following order:

1. PO_BOX

2. POST_CODE2

3. PO_BOX_LOC

4. CITY1

5. PO_BOX_REG

6. REGION

7. PO_BOX_CTY

8. COUNTRY

1�9�� (��

To make changes to the fields or the order of the fields displayed in the address reviewer:

1. From the IMG, select the activity “Maintain fields for address reviewer.” The “Maintain fields for address reviewer” window appears.

2. Check or uncheck boxes in the Display for Street Addr and Display for PO Box columns.

Data Quality for SAP Solutions displays the fields checked in the address review dialog.

��

3. Type sequential numbers for all the checked fields in the Sequence Number fields to indicate the order of the fields for street address data and P.O. Box data.

4. Save the changes and exit the window.

You must number both the street address data and P.O. Box data in sequence from 1 to the total number of displayed fields.

�� '"��&��&��&��(� ��

1��$��$��+

In this activity, you can define which fields are displayed in the hit list and their order for error tolerant search or duplicate check. You must define the fields for both hit list types.

8��$��

By default, the following fields are displayed in this order for the error tolerant search and duplicate search lists:

%�� 1. Score

2. Customer or Vendor or BusPartner

3. Name

4. Name2

5. Street

6. City

7. Region

8. Postal Code

9. Country

*��5��1�� 1. Score

2. Last name

3. First name

4. House number

5. Street

6. City

7. Region

8. Postal Code

9. Customer

10. Vendor

11. BusPartner

SAP Basis 6.40 shows an additional window in this activity that other SAP versions do not show. This window is generated by SAP and not Data Quality for SAP Solutions, and therefore is not documented in this Guide.

�" ��

1�9��$��$��+

To make changes to the fields or the order of the fields in the duplicate hit list display:

1. From the IMG, click on the activity “Maintain fields for duplicate hit list display.” The “Maintain fields for duplicate hit list display” window appears.

2. Check or uncheck boxes in the Display Flag (Search) and Display Flag (Dup. Check) columns.

The fields checked appear in the duplicate check or error tolerant search dialog.

3. Type sequential numbers for all the checked fields in the Sequence (Search) and Sequence (Dup. Check) fields to indicate the order of the fields for duplicate check or error tolerant search data.


Both the duplicate check and error tolerant search data are to be numbered in sequence from 1 to the total number of displayed fields.

�� '"��&��&��&��(� �#

1��$��$��

In this activity, you can modify one of the several operating parameters that affect the behavior of Data Quality for SAP Solutions.

'$��$�� The following table shows the operating parameters, the default values, and a description of each.

�� #��

ADD_REVIEW_FLAG X Flag to determine whether a dialog is displayed that allows the user to review the original and modified address during postal validation. Valid values are ’X’ to receive this confirmation dialog or a space not to receive the dialog.

AD_REVIEW_NEW_WIDTH

35 Width by number of characters of the validated address column in the Postal Validation -- Review Changes window, allowing you to adjust the size of the column if addresses are too long to fit.

AD_REVIEW_ORIG_WIDTH

25 Width by number of characters of the original address column in the Postal Validation -- Review Changes window, allowing you to adjust the size of the column if addresses are too long to fit.

BATCH_MATCH_RFC_DEST

FL_GDQC_BATCH_RFC

Dedicated RFC Server for handling duplicate search functional-ity in batch mode (also called “batch match”).

ENABLE_DES_FUN_NM none Administrator-specified function to enable/disable Data Quality for SAP Solutions duplicate error tolerant search (DES). A pos-sible value is the name of a function module to call before exe-cuting Data Quality for SAP Solutions’s DES. The interface for the function module specified here must have one EXPORT parameter named VALID of type FLAG “pass by value.” After the function call, if VALID is “X,” postal validation processing occurs using Data Quality for SAP Solutions. If VALID is space, then only SAP's standard DES checks occur.

ENABLE_PV_FUNC_NM none Administrator-specified function to enable/disable Data Quality for SAP Solutions postal validation. A possible value is the name of a function module to call before executing Data Quality for SAP Solutions’s postal validation. The interface for the func-tion module specified here must have one EXPORT parameter named VALID of type FLAG “pass by value.” After the function call, if VALID is “X,” postal validation processing occurs using Data Quality for SAP Solutions. If VALID is space, then only SAP's standard address checks occur.

MAX_ACT_DUPS 100 Maximum number of actual duplicates displayed to the user.

MAX_ELP_TM_DUPS 5 seconds Maximum time allowed in seconds to find duplicates. The value must be 1 second or greater.

MAX_REC_QU2 10000 Maximum number of records per package passed to the RFC Server during the quarterly adjustment report.

�) ��

6�� !��(��

The following table shows the operating parameters, the default values, and a description of each for operating parameters used only by the IC WebClient.

1��+��$��

To make changes to operating parameters:

1. From the IMG, click on the activity “Maintain operating parameters.” The “Maintain operating parameters” window appears.

2. Change the Parameter Value field for any of the parameters.


MAX_UPD_PEND 100 Maximum number of records that may be pending for update to the RFC Server when the RFC Server is unavailable. If the number of records pending exceeds this maximum, then the records are not updated automatically and require the pending record update report to be run. For information on the pending update report, see the sec-tion “Records created without break keys due to downtime of RFC Server” on page 84.

NON_DIALOG_ERR_MSG space Toggles whether system messages are to be displayed in non-dialog mode. Valid values are “X” to enable passing of system error messages in non-dialog mode for postal validation or a space not to receive the system message.

PKG_SIZE_DUPS 1000 Package size used for passing candidate duplicates to the RFC Server.

RFC_DEST FL_GDQC_SERVER Name of the RFC Server contacted through a Remote Function Call. This name must correspond to a valid destination that describes a functioning RFC Server.

TECH_ERR_FUNC_NM none Name of a user defined function module that is called whenever a technical error occurs.

�� #��

�� #��

BSP_RANGE_HEIGHT 225 Height of child window for range queries in BSP Postal Validation.

BSP_RANGE_WIDTH 400 Width of child window for range queries in BSP Postal Validation.

BSP_REVIEW_HEIGHT 320 Height of address review BSP page.

BSP_REVIEW_WIDTH 700 Width of address review BSP page.

BSP_SUGG_LIST_HEIGHT 475 Height of child window for suggestion lists in BSP Postal Valida-tion and Duplicate Check/Error tolerant Search.

BSP_SUGG_LIST_WIDTH 700 Width of child window for suggestion lists in BSP Postal Validation and Duplicate Check/Error tolerant Search.

�� '"��&��&��&��(� �%

1�$��+$��/��+��=��

Data Quality for SAP Solutions provides the custom error report /FLDQ/AD_REPT_DISP_QTRERRORLOG to log invalid addresses found by Data Quality for SAP Solutions during the execution of Quarterly Adjustment Reports.

This activity allows you to make each item in the list of invalid addresses a hyperlink that takes the user directly to the appropriate transaction to edit the incorrect address. Allowing the user to access the transaction and address in this manner saves the user the effort of manually entering the transaction and locating each invalid address for editing.

��$$�� The report /FLDQ/AD_REPT_DISP_QTRERRORLOG lists the Address Type, Address Key, and Address Type Code for each address.

The Address Key can serve as a hyperlink that calls the appropriate transaction to edit the address only if the Address Type Code and Parameter ID for this Address Type are defined in table /FLDQ/AD_QTR_OBJ. If the mapping for a particular Address Type does not exist in this table, clicking on the Address Key field has no effect.

For each Address Type in the error report /FLDQ/AD_REPT_DISP_QTRERRORLOG, an edit transaction and the Parameter ID must be defined in order for the key field to serve as a hyperlink. Some of these mappings are predefined in Data Quality for SAP Solutions as shipped, but you must add mappings for all other Address Types for which you want to create hyperlinks. For example, when linking to a Customer record, for transaction XD02 you would define the Parameter ID as KUN.

��$$�� Data Quality for SAP Solutions ships with transaction mappings for the following Address Types:

�� KNA1 - Customer

�� LFA1 - Vendor

�� BUS0010 - Functional Location

�� BUS1006 - Business Partner

�� BUS1006001 - Business Partner Employee

�� USRCOMPANY - Company

You must perform the activity described in the following section to add a mapping for any other Address Types.

��$$��.+$��

To add a mapping for an Address Type Code:

1. Run the /FLDQ/AD_REPT_DISP_QTRERRLOG report.

2. Write down the Address details for an entry for which the hyperlink does not work, noting these three items:

� Address Type

� Address Key

��

� Address Type Code

3. Use the Address Type and Address Key to determine which SAP transaction should be used to edit the address record.

4. Navigate to the Edit transaction.

5. Place your cursor in the Key field (for example, Customer in transaction XD02).

6. Press the F1 key.

7. Click the Technical Information button on the Performance Assistant dialog menu bar.

8. Note the Parameter ID value in the Field Data section.

9. Use the IMG Activity Map of Objects to transaction for Quarterly Error Report.

10. Click the New Entries button and fill in all three columns using the data you have collected:

� Enter the Address Type Code in the Object Type field.

� Enter the transaction Code in the Transaction for Edit field.

� Enter the Parameter ID in the Object Parameter ID field.

11. Save.

12. Repeat as necessary for each address that does not have a working hyperlink.

13. Create a Customizing Request.

�� '"��&��&��&��(� �

� ��

��$�� &��68��0��

Through the installation process, all of the necessary files on the RFC Server are configured to properly run BusinessObjects Data Quality XI for SAP Solutions. You may, however, change items after installation.

�� )"��&��&��*+��#��

�� A<��

The main configuration file of the RFC Server is flrfcsrv.xml. Through the parameters of this file, you control several aspects of Data Quality for SAP Solutions, such as how Data Quality for SAP Solutions handles logging and various performance-related settings. This section discusses certain critical settings of this configuration file.

;�� A<��

The file is located on your system at install_directory\config\flrfcsrv.xml.

B�� A<�� Edit flrfcsrv.xml as you would any other XML file. If you have an XML editing program that you are familiar with, you can use that program. You can also use any text editing program (such as Notepad in Windows).

When you edit a value in flrfcsrv.xml, make sure that you alter configurable values but do not change the structure or required parameters of the file. Be sure to make a backup of flrfcsrv.xml to preserve its original state in case you later want to discard your changes.

0��/��+��

The settings under the commented headings  and  are rarely altered. They are determined at the time of installation.

If you want to run multiple instances of the RFC Server, you can override these settings by making new settings in the <override> tags, found beneath these settings in the file. See “Overrides” on page 68 for details on how to override these settings.

8�� The following table shows the configurable settings and defaults in the section under the commented heading . All of these settings must have an entry.

!You should not make changes to flrfcsrv.xml without a full understanding of the implications of those changes. Errors in this configuration file could disable Data Quality for SAP Solutions.

One reason you might alter a setting in this section would be if you chose a Program ID other than FLRFCSRV during the activity “SAP handshake with RFC server,” and now must edit the <sap_progid> setting to correspond to the correct Program ID.

��

log_level Provides two levels of logging. 1 - Only serious errors are logged2 - Serious errors and any important warnings and information messages are logged.

2

��

:�� The following table shows the configurable settings and defaults in the section under the commented heading . All of these settings must have an entry.

enable_trace Determines whether the RFC server should generate trace files. A trace file provides you with a history of transac-tions. Possible values are yes and no.

yes

tsad10_config Location and name of tsad10.txt, which is a file that stores valid match fields. The path is relative to the installation of Data Quality for SAP Solutions.

config/tsad10.txt

region_file Location and name of regions.xml, which sets regions for a specific coun-try code. The path is relative to the installation of Data Quality for SAP Solutions

config/regions.xml

fmt_file Location and name of fmt.xml file, which is the format file., which speci-fies the format of tables that the gate-way passes as arguments to the RFC Server.

config/fmt.xml

��

��

max_sugg_items Maximum number of suggestion items the RFC server should return. Must be set to a minimum of 1.

99

connect_timeout Maximum amount of time in millisec-onds the RFC server should attempt to connect to the Data Quality server. Must be greater than or equal to zero. A setting of zero indicates no timeout.

20000

process_timeout Maximum amount of time in millisec-onds the RFC server should wait for a response from the Data Quality server. Must be greater than or equal to zero. A setting of zero indicates no timeout.

120000

connect_delay Amount of time to wait between attempts to communicate with the Data Quality server. Must be greater than or equal to zero. A setting of zero indicates that the RFC server is to attempt continuously to connect to the Data Quality server and SAP Gateway without pausing between attempts.

5000

include_empty_candidates_check

Determines whether to include empty candidates in address checks. Possible values are yes and no.

yes

�� )"��&��&��*+��#��

��( The settings under the commented headings  correspond to the name of the dataflows that run each type of SAP request. If you change the name of the dataflow here, you must change it on your Data Quality installation.

For more information about dataflows, see the Data Quality documentation that shipped with this package.

' �� You can override the settings in the other sections, which would be useful if you run more than one instance of the RFC Server.

You can override only the following tags:

�� sap_gwhost

�� sap_gwserv

�� sap_progid

�� sap_encoding

�� dqxi_host

�� dqxi_port

�� repository_path

�� sub_options

�� To create an override:

1. Remove the comment tags from an override so that this section can be parsed by the RFC Server.

2. Fill in the value for the override name.

<override name="my_new_override_name">

3. Fill in the values for each tag that requires an override. If any tags are the same as the default setting, fill in the default setting value.

4. Set the override in the file install_directory\config\start_rfcserver.bat by indicating the name of the override.

set OVERRIDE="my_new_override_name"

5. Save and close both files. When start_rfcserver.bat runs, it looks for the named override in flrfcsrv.xml and executes those override settings.

include_empty_candidates_search

Determines whether to include empty candidates in address searches. This configuration setting is discussed in more detail in the section“RSMTC-CODE program error message” on page 85. Possible values are yes and no.

yes

��

�" ��

��$��&��

This chapter describes postal address validation features of BusinessObjects Data Quality XI for SAP Solutions. Postal validation standardizes and corrects address data, protecting the integrity of that data in your SAP system.

Postal address validation takes place in real time as users enter data and in a batch mode as part of the SAP Quarterly Adjustment Report. In real time, Data Quality for SAP Solutions validates and standardizes address data before the data is saved to the SAP database. During Quarterly Adjustment, Data Quality for SAP Solutions replaces one of the SAP reports to standardize and correct the data that already exists.

�� ,"��#�� #

2�� (��/��+��0��0��

Data Quality for SAP Solutions’s interactive, real-time postal address cleansing capability lets your SAP users cleanse address data at the point of entry and before the data is written into your SAP database.

4��

For interactive address cleansing, the SAP user needs to take no unusual action. The data is cleansed automatically when the user saves the record or clicks the Check Address button. In this example, a user adds information for a new account. The data is not entered properly, and the ZIP Code was not entered.

After the user attempts to save the record, the cleansing takes place in real time. The user is offered a window to review the changes that Data Quality for SAP Solutions made to the address. The user can accept the validated address, use the original address, or cancel the postal validation process.

�) ��

At this window you have three button options:

In this example, the following items were cleansed:

�� The street name was corrected and properly cased.

�� The city was spelled properly and properly cased.

�� The state was cased properly.

�� The ZIP+4 postal code was added.

1��$�� This illustration of the suggestion list (this time, as used in the IC Web Client) offers several addresses because the original provided address was ambiguous.

In this window, the three button options are as follows:

� ��

Accept Validated Address

The previous window returns to focus with the corrected data popu-lating the fields.

Use Original Address

The previous window returns to focus with the data as originally entered populating the fields.

Cancel The previous window returns to focus and the process is cancelled.

� ��

Select The previous window returns to focus with the data chosen here populating the fields.

Use Original Address

The previous window returns to focus with the data as originally entered populating the fields.


�� ,"��#�� %

7��(��/��+��=��6�$��

Data Quality for SAP Solutions accomplishes batch cleansing of postal addresses through Quarterly Adjustments. You first run Quarterly Adjustments with Data Quality for SAP Solutions’s custom report as part of the installation and configuration steps.

After installation, you may want to run Quarterly Adjustments on a regular, pre-determined schedule. Also, you should run Quarterly Adjustments after installing new address directories from Business Objects to validate data that may have changed due to the renaming of streets, the development of new areas, and so on.

For information about running Quarterly Adjustments, see “Quarterly Adjustment Reports” on page 40.

You may also want to further customize the display of the report by making each address listed in the report a hyperlink to the editable address entry. For information on this process, see “Map address types for Quarterly Adjustment” on page 62.

��

��$��&��$��9��

This chapter describes the duplicate check and error tolerant search capabilities of BusinessObjects Data Quality XI for SAP Solutions.

These capabilities allow SAP users to prevent the creation of duplicate customer records in the SAP database and also to search for customer records using information that may contain misspellings, omitted or transposed characters, and so on.

�� -"� � ��.��

4��$��9��

To help you understand the concepts of this chapter, this section briefly defines some of the terminology. Each of these concepts are explored in greater detail later in this chapter.

��$��9 Duplicate check is the process that assures that duplicate addresses are not entered into the SAP system when users create a new address record or update an existing one. During the check, if there are duplicates, the user is presented with the list of possible duplicates and allowed to select an existing customer and open that record, or to continue the process of adding the new customer, or to cancel the operation.

B�� Error tolerant search allows users to find customer records using partial information. Based on the partial information provided by the user, Data Quality for SAP Solutions presents a list of possible matches to the user. The user then can choose to select a record from the search hit list of matches for further processing or can cancel out of the search hit list.

7��9�C�+ A break key is the search index for each record that Data Quality for SAP Solutions uses for discovering similar, possibly matching, candidate records. A break key is made up of search terms that are arranged in a specific order. The search terms can be customized so that Data Quality for SAP Solutions can determine that certain existing records have no realistic probability of being duplicates and should be ignored.

In some previous versions of this product the term “match code” was used instead of break key. The decision to change this term to “break key” is consistent with the terminology used for BusinessObjects Data Quality XI Release 2.

� ��

4��9�9�+��

During duplicate check and error tolerant search, Data Quality for SAP Solutions uses break keys to limit the number of records used in duplicate searches. Once given input data, Data Quality for SAP Solutions determines a break key for the address and considers only stored records with the same break key value when searching for duplicates.

3�(��/��+��9�9�+

By default, Data Quality for SAP Solutions uses the first three alphanumeric characters of the postal code and the first letter of the street field to generate the break key value. Therefore, in order to improve the results during a search, Data Quality for SAP Solutions requires data for the street and postal code fields so that the appropriate records can be used in the matching process.

For example, to search for a customer who you know lives on Main Street in La Crosse, Wisconsin, you would enter the following information in the search window:

Street: Main St

Postal Code: 54601

The break key value for this input data is 546M. The search process selects all of the records from the SAP system that have the break key value 546M. The search process then compares the input data to each record selected using the matching rules set up on the RFC Server.

To illustrate the importance of providing data in the two fields used by Data Quality for SAP Solutions to determine a break key, imagine that you entered the following information in the search window:

Street: <blank>

Postal Code: 54601

The break key value would be 546 and only records with a break key value of 546 would be selected for searching. This result would not include the record you were searching for because that record has a break key value of 546M.

��9�9�+��

The break key settings are configurable and specified in the Data Quality transform transactional_create_break_keys.xml. If you want to change the break

This process is altered when Data Quality for SAP Solutions is configured to include records with empty break key values. For more information about the implications of configuring Data Quality for SAP Solutions to include records with empty break keys and the process to do so, see the section “RSMTCCODE program error message” on page 85.

During duplicate search, Data Quality for SAP Solutions performs postal validation on the input data before performing the search. If this example had been for duplicate search specifically, the postal code left blank, but street, city, and region data were complete, then Data Quality for SAP Solutions could validate the data and determine the postal code. The corrected data would then be assigned the appropriate break key of 546M, even though you did not directly enter the postal code.

�� -"� � ��.��

Business Objects recommends that you contact Customer Care. For contact information, see “Customer Care” on page 2.

1�� You can also perform a search with data from the name field. Data Quality for SAP Solutions creates special break key values based on name information. This ability allows you to perform a name-only search. However, the name break keys are not configurable.

If you enter data into both the name field and address fields, then both the name and address break key values are used to select records.

By default, Data Quality for SAP Solutions includes records with empty break keys when performing matches. In the file flrfcsrv.xml, the parameter for including records with empty break keys to find duplicates in postal validation is include_empty_candidates_check. The parameter for including records with empty break keys in duplicate search is include_empty_candidates_search. You can exclude records with empty break keys when performing matches by changing the default setting on each parameter from yes to no.

For more information on these settings and their values, see “General settings” on page 67.

��

4��$��9

When you create a new entry in the SAP database for a customer, vendor, or business partner, Data Quality for SAP Solutions performs postal validation on the entry to complete and standardize the data, then checks existing data to find records that might be duplicates of the new, validated entry.

You can also use duplicate check in batch mode.

.�� In response to your attempt to save a new record, Data Quality for SAP Solutions processes the data and, if it finds a record for which the new record may be a duplicate, presents a hit list of candidates from which you can select an entry.

If one of the results on the hit list is a match of the record you are entering, select the record by clicking it.

At this window you have three button options:

The duplicate check hit list for the IC WebClient is shown here:

� ��

Continue The previous window returns to focus showing the current address that the user accepted from the previous address reviewer window.

Select Duplicate The previous window returns to focus with the data from the selected record populating the fields.


SAP Basis 6.40 shows additional GUI elements in this window that other SAP versions do not show. These additional elements are created by SAP and not Data Quality for SAP Solutions, and therefore are not documented in this guide.

�� -"� � ��.��

At this window you have two button options:

8��$��+�� You can customize the data fields displayed in the SAP-GUI version of the duplicate check hit list, as well as the order of those fields. See “Maintain fields for duplicate hit list display” on page 58 for information about the default settings and the procedure for making changes to the fields displayed within the SAP GUI.

7�� You can use duplicate search in batch mode (often called “batch match”) to find duplicate records in your database.

To use duplicate search in batch mode:

1. Invoke transaction se38 to go to the ABAP editor screen.

2. In the ABAP editor screen, enter the program /FLDQ/RSBTCMTC. The Initial Match Code (Index) Setup Program screen appears.

3. Set the threshold (a lower number produces more matches) and the packet size, and choose whether to use the SAP functionality to create a cleansing case to combine records. (R/3 4.6 systems do not have an option to create a cleansing case.)

4. Execute the program.

The results appear after the system finishes processing.

� ��

Continue The previous window returns to focus and the record the user entered is saved.


�" ��

4��

When you perform a search for a customer, vendor, or business partner using SAP error tolerant search functionality (often called fuzzy search or rough search), Data Quality for SAP Solutions takes even partial data or erroneous data that you entered and provides a hit list of logical record matches between your search terms and existing data.

A sample search window is shown here:

The searches can take place on address fields or name fields. You can customize Data Quality for SAP Solutions to determine which fields are presented in the hit list to help you decide which record fulfills your search.

.�� In response to your search request, Data Quality for SAP Solutions processes the data, creates a list of possible matches, and presents a hit list of candidates from which you can select an entry.

A sample error tolerant search hit list dialog is shown here.

�� -"� � ��.�� #

If one of the results on the hit list is the desired record, select the record and click the Select button.

At this window you have three button options.

8��$��+�� You can customize the data fields displayed in the error tolerant search hit list, as well as the order of those fields.

See “Maintain fields for duplicate hit list display” on page 58 for information on the default settings and the procedure for making changes to the fields displayed.

� ��

Select A window appears that gives the customer number for confirmation. If this record is the desired record, you can accept it by clicking Enter. The previous window returns with the entered data populating the fields. The duplicate matches are discarded.

New Search The search window returns, populated by the data you entered.

Cancel The standard SAP search window is displayed.

") ��

��$��&�.�$��

This chapter includes information on troubleshooting errors and known issues within BusinessObjects Data Quality XI for SAP Solutions. It also includes tips for using the product.

�� /"�0� ��& "%

2��

��9��68�� DE��

You can determine to which RFC server(s) an SAP gateway is connected by using the SAP transaction SMGW. For information on the use and syntax of transaction SMGW, consult your SAP documentation.

��68��0��

If the connection between your SAP system and the RFC Server closes or is not made during installation, the RFC Server log file flrfcsrv_log.txt contains the entry “connection closed.”

A more descriptive explanation may exist in another log file or trace file on the RFC Server. Depending on the issue, the information may be in various files that have the extension .trc. If you experience failures due to closed connections to the RFC Server, you can search for those files with the wildcard search *.trc.

.��4��

Data Quality for SAP Solutions has two settings that indicate whether your system processes Unicode characters, one in Data Quality for SAP Solutions’s RFC Server configuration file and one in the IMG. If you have problems related to Unicode characters, you should check and configure these two settings to make sure they are correct.

��(��$)�� To configure the RFC Server to determine whether Data Quality for SAP Solutions works with either a Unicode or non-Unicode system:

In Data Quality for SAP Solutions’s RFC Server configuration file (by default, install_directory\config\flrfcsrv.xml), set the sap_unicode key to yes if you have a Unicode system or no if you have a non-Unicode system, as follows:

<sap_unicode>yes</sap_unicode>

or

<sap_unicode>no</sap_unicode>

��(��!'7 To configure the IMG to determine whether Data Quality for SAP Solutions works with either a Unicode or non-Unicode system:

1. Within the IMG, enter the transaction SM59. The Display and Maintain RFC destinations window appears.

2. Select TCP/IP -> FL_GDQC_SERVER. The RFC Destination FL_GDQC_SERVER window appears.

3. Select the Special Options tab.

4. In the Character Width in Target System field, select the Non-Unicode or Unicode button, as appropriate for your system.

"� ��


��

��

�� /"�0� ��& "

�� $��9>��

2��+�� (��$��$��

If you were not running Data Quality for SAP Solutions on your SAP system and you entered an address without using the postal code, the SAP system would return a standard SAP error indicating that you need to enter a valid postal code.

Because you are running Data Quality for SAP Solutions on your SAP system, Data Quality for SAP Solutions attempts to fill in the correct postal code based on the other address information you provided. If, however, Data Quality for SAP Solutions can not determine a postal code, Data Quality for SAP Solutions does not offer you an option to save the address without correcting. This restriction is necessary because if you attempted to save the address without the ZIP Code, the SAP system would return its standard error indicating that you need to enter a valid postal code.

Therefore, instead of creating a scenario in which Data Quality for SAP Solutions allows you to save the address without the postal code only to have the SAP system disallow it, Data Quality for SAP Solutions instead gives an error and does not allow you to save the address.

6��(��9�9�+��(��68��0��

During any time that the RFC Server is not functioning, Data Quality for SAP Solutions can not give a break key to newly created records or changed records.

When the RFC Server again functions and the first record is created or changed, Data Quality for SAP Solutions checks a list of pending records to determine which records have not been assigned break keys, and assigns break keys to those records. The size of that list is configurable through the IMG activity “Maintain operating parameters.” (For details, see “Maintain operating parameters” on page 60.)

If the number of pending records exceeds the size configured in that parameter, Data Quality for SAP Solutions cannot assign break keys to the records. Instead, you must run the custom report /FLDQ/AD_REPT_UPDATE_PEND_RECS.

To run the report /FLDQ/AD_REPT_UPDATE_PEND_RECS:

1. Start the report /FLDQ/AD_REPT_UPDATE_PEND_RECS by running the transaction code SA38.


2. In the Program field, enter /FLDQ/AD_REPT_UPDATE_PEND_RECS and click the Execute button (F8).

A confirmation window appears and Data Quality for SAP Solutions has assigned break keys to all records in the database.

6��$��$��(��

As you add or change records, the records are normally stored in the table /FLDQ/AD_PUPDATE until they are committed to the SAP database. However, records are not stored in that table if the Suppress Search box is checked because with search functionality suppressed, Data Quality for SAP Solutions would never process the records in the table, and the table would grow endlessly.

For information about the Suppress Search checkbox, see “Add a transaction code to the exception table” on page 53.

" ��

4��

Regions are data fields that could be states for U.S. addresses, provinces for Canadian addresses, and so on. You can edit the file regions.xml to control how Data Quality for SAP Solutions maps regions between the data format expected by SAP and the data format expected by Data Quality (and its Address Cleanse transform). In particular, this section describes how the order of region maps in the file is significant. Consider this example.

Each line of regions.xml specifies conversion values for both directions:

SAP region code -> Data Quality region name

CA, PQ -> CA, QC

CA, QC -> CA, PQ

CA, QC -> CA, QC

SAP region code <- Data Quality region name

CA, PQ <- CA, QC

CA, QC <- CA, PQ

CA, QC <- CA, QC

When there are redundancies in the maps, as in this example, Data Quality for SAP Solutions uses the last defined map.

Therefore, Data Quality for SAP Solutions converts the input region:

CA, PQ -> CA, QC

CA, QC -> CA, QC (note: QC->PQ was overwritten by QC->QC)

And Data Quality for SAP Solutions converts the output region:

CA, QC <- CA, PQ

CA, QC <- CA, QC (note: PQ<-QC was overwritten by QC->QC)

Therefore, if the order of these regions map is different, you get a different result that might be unexpected.

��(��6>� A�)�� A�)

If you have R/3 4.60 or 4.70 system, the SAP two character mapping code for the Canadian province Newfoundland is NF. For all other versions of SAP supported by Data Quality for SAP Solutions, the mapping code is NL. In the file regions.xml, the mapping code NL is used for Newfoundland. To assure correct postal validation, users of R/3 4.60 and 4.70 should change the line in regions.xml for country CA:

<region code="NF" name="NL"/>

to

<region code="NF" name="NF"/>

601.��'�B�$��

When you run the program RSMTCCODE for a range of records but no record exists in that range, the system displays an error message that states, “Report execution completed successfully. No updates done to break keys table.”

�� /"�0� ��& "�

2��(��$�+��9�9�+

A break key is the search index for each record that Data Quality for SAP Solutions uses for finding similar, possibly matching, candidate records. A break key consists of search terms that are arranged in a specific order. The search terms can be customized so that Data Quality for SAP Solutions can determine that certain existing records have no realistic probability of being duplicates and should be ignored.

Some records may not have a break key associated with them; that is, some records have an empty break key. Some may have break keys for name data but not address data, or vice versa.

On one hand, including records that have empty break keys during postal validation or duplicate search slows the processing of Data Quality for SAP Solutions, because Data Quality for SAP Solutions has more records to examine. On the other hand, including records that have empty break keys helps Data Quality for SAP Solutions return appropriate records.

In the file flrfcsrv.xml, the parameter for including records with empty break keys to find duplicates in postal validation is include_empty_candidates_check. The parameter for including records with empty break keys in duplicate search is include_empty_candidates_search.

For more information on these settings and their values, see “General settings” on page 67.

��$��$$��<$��

If the duplicate hit list screen fails to appear as expected, the problem may exist in the field SAP_MATCH_THRESHOLD of the Data Quality transform transactional_name_and_address_match. This field must not be blank. For more information about transactional_name_and_address_match, see “Data Quality dataflows” on page 91.

.�� $��

The Data Quality transform address_validate_suggestion contains the values to set the threshold for candidate records to be presented in a suggestion list. However, because of changes in SAP Basis versions 640 and above, the threshold values from address_validate_suggestion are ignored by the SAP system.

Instead, for SAP Basis versions 640 and above, you must set threshold values in the IMG activity “Set Limit for Duplicate List in SAP Dialog Boxes.”

For more information on break keys and how they help Data Quality for SAP Solutions perform searches, see “Understanding duplicate check and error tolerant search” on page 74.

"� ��

For information on configuring this IMG activity, see your SAP documentation.

�� >B��.��"

If addresses do not validate and Error T528 is recorded in the RFC Server log files, the cause may be that the Data Quality Server was stopped and restarted without restarting the RFC Server. For more information, see “Start the RFC Server” on page 25.

�� /"�0� ��& "�

��/��+�.��

2��$��4�25

When you install BusinessObjects Data Quality XI Release 2 as part of the process of installing Data Quality for SAP Solutions, the installer creates a /dirs directory for the directory files. You must make sure that the user copying the directory files has write permissions to that directory.

.��(��$��$��4�25

The SAP workflows that are part of the Data Quality portion of Data Quality for SAP Solutions invoke several transforms, which spawn new threads within your processor. If the number of threads exceeds your computer’s setting for the number of threads allowed per process, Data Quality may stop the dataflow and exit without an error message. You can correct this problem by raising the setting on your computer for the number of threads allowed per process.

"" ��

68��0�� .��

68��0�� (��0.�6.��0.'�

If after initialization the RFC Server state toggles between START and STOP, you may not have a valid gateway service ID in the configuration file flrfcsrv.xml. Check the value for the key <sap_gwserv> to ensure that the entry is correct.

For instruction on editing flrfcsrv.xml, see “Configuring through flrfcsrv.xml” on page 66.

'��$��

Upon startup, the RFC Server console outputs the manifest information, which is the vendor’s name, name of the product, and the version of the product. Then, after the log file is initialized, it writes this information to the log file.

The format of this string is:

<vendor>’s <product> v<version>

Here, <vendor> is the value assigned as the specification vendor in the manifest file, <product> is the value assigned as the specification title in the manifest file, and <version> is the value of the specification version in the manifest file.

This information can be displayed only if the manifest information is available to the program. If this information cannot be loaded, the RFC Server displays the following warning:

Warning: Unable to access the manifest file to display version and vendor information.

The program continues processing normally after displaying this message to the console.

�� /"�0� ��& "#

#) ��

�$$��<��&��/��+��(��.��

This section describes the Data Quality dataflows and transforms that are specific to BusinessObjects Data Quality XI for SAP Solutions.

��/��+��(

These dataflows are located in the Data Quality Project Architect at Configuration_Rules/projects/sap.

Though this section provides information about the Data Quality dataflows and transforms that are specific to Data Quality for SAP Solutions, you must consult the Data Quality documentation for general procedures for working with Data Quality dataflows and transforms.

��

transactional_address_cleanse This dataflow is used when the IMG setting is configured so that the Suggestion List is disabled during the Address Validation. For informa-tion about suggestion lists, see “Maintain exception table of transaction codes” on page 53.If you are upgrading from version 11.5.0.0 and made changes to the default settings of this dataflow, you must manually make those same changes to this dataflow after installation to recreate the customization.

batch_address_cleanse This dataflow is used for quarterly adjustment reports and produces the same results as the results from the interactive address validation pro-cess. For more information about quarterly adjustment reports, see “Quarterly Adjustment Reports” on page 40. In the 11.5.0.0 release of this product, this dataflow was called transactional_address_cleanse_batch. If you are upgrading from version 11.5.0.0 and made changes to the default settings of transactional_address_cleanse_batch, you must manually make those same changes to this dataflow after installation to recreate the customi-zation.

transactional_address_cleanse_with_suggestions This dataflow is used when the IMG setting is configured so that the Suggestion List is enabled during the Address Validation. For informa-tion about suggestion lists, see “Maintain exception table of transaction codes” on page 53.If you are upgrading from version 11.5.0.0 and made changes to the default settings of this dataflow, you must manually make those same changes to this dataflow after installation to recreate the customization.

transactional_create_break_keys This dataflow contains the settings for determining break keys. For information on break keys, see “Understanding break keys and data fields” on page 75.If you are upgrading from version 11.5.0.0 and made changes to the default settings of this dataflow, you can copy your 11.5.0.0 version of this dataflow to your new installation of Data Quality in order to pre-server those customizations.

� #%

B��+��

To enable and disable specific country engines, you must change settings in one Data Quality transform, gdqc_gac_base, and two Data Quality dataflows:

� transactional_address_cleanse_with_suggestions� transactional_US_DPV_address_cleanse

To enable and disable specific country engines on gdqc_gac_base:

1. Open the gdqc_gac_base transform in the Project Architect. It is located at transforms/global_address_cleanse.

2. In the Option Group Name panel, delete any engines you want to disable. Any engines not deleted are enabled.

To enable and disable specific country engines on the dataflows.

1. Open the transactional_address_cleanse_with_suggestions dataflow in the Project Architect.

2. Select the Address_Validate_Suggestion compound transform.

3. In the Option Group Name panel, under the group name AddressValidateSuggestion_GlobalSuggestLists_GlobalSuggestLists_Transform, select ENGINES.

transactional_name_and_address_match This dataflow determines the match scores for a list of candidates sent to the RFC Server from the SAP Gateway. By default, only one match dataflow exists, but you can create copies of this dataflow and custom-ize the dataflow for your own needs. Your new dataflows can then be assigned to process for specific tables, fields, and match modes by assigning the name of the new dataflow to the appropriate setting in the main configuration file.The field SAP_MATCH_THRESHOLD of this dataflow must not be blank, or the duplicate hit list may fail to appear during match process-ing.If you are upgrading from version 11.5.0.0 and made changes to the default settings of this dataflow, you can copy your 11.5.0.0 version of this dataflow to your new installation of Data Quality in order to pre-server those customizations.

transactional_retrieve_country_purchased This transform retrieves the list of countries for which you can perform postal validation.If you are upgrading from version 11.5.0.0 and made changes to the default settings of this dataflow, you can copy your 11.5.0.0 version of this dataflow to your new installation of Data Quality in order to pre-server those customizations.

transactional_US_DPV_address_cleanse This transform processes US records through the URAC (US Regula-tory Address Cleanse) transform and non-US records through the GAC (Global Address Cleanse) transform. If the collection contains multiple records (pending update case), all records must be of US origin to receive URAC DPV processing.

��

#� ��

4. For each country in the Option column, use the dropdown list to set the value to YES or NO.

5. Save your changes.

6. Repeat these steps for the transactional_US_DPV_address_cleanse dataflow and transactional_address_cleanse_with_suggestions dataflow.

��3��17��

The combine_house_num_and_pmb transform allows you to set the option for how Data Quality for SAP Solutions handles house number and PMB (postal mail box) data. The following table explains the eight options.

This transform is located in the Data Quality Project Architect at Configuration_Rules/dataflow_objects/transforms/formatter/.

To set the option for how Data Quality for SAP Solutions handles house number and PMB data:

1. Open the combine_house_num_and_pmb transform in the Project architect.

2. In the Option Group Name panel, select OPTIONS/SUBSTITUTION_VARIABLES.

�� $%��

1 This option will separate the house num1, house num2, and street data in the house num1, house num2, and street fields, respectively. It also appends the PMB data in the street supple2 field.

2 This option will separate the house num1, house num2, and street data in the house num1, house num2, and street fields, respectively. It also appends the PMB data in the street field.

3 This option will combine the house num1 and house num2 with street data in the street field and append the PMB data in the street suppl2 field.

4 This option will combine the house num1, house num2, and PMB data with the street data in the street field.

5 This option will combine the house num2 data with street data in the street field and append the PMB data in the street suppl2 field.

6 This option will combine the house num2 and PMB data with the street data in the street field.

7 This option will combine the house num1 data with the street data in the street field and append the PMB data in the street suppl2 field.

8 This option will combine the house num1 and PMB data with the street data in the street field.

� #

3. For the Option COMBINE_OPTION_ID, directly edit the value to a number from 1 to 8, depending on how you want Data Quality for SAP Solutions to handle house number and PMB data.


��/��+�:��7��

The gdqc_gac_base transform allows you to determine whether suggestion lists preserve alternate street and city names for U.S. addresses.

This transform is located in the Data Quality Project Architect at Configuration_Rules/dataflow_objects/transforms/address_cleanse/.

*��

Certain U.S. addresses use alternate names for cities and streets. (These alternate names are sometimes called vanity names.) For example, a location in Hollywood, California would be the same address if the address instead used the city name of Los Angeles, because Hollywood is the alternate name for a subsection of the city of Los Angeles.

The setting that governs whether the suggestion list should offer the alternative name (Hollywood) or the regulation postal address name (Los Angeles) is called LOCALITY_1 in the USA\OPTIONS group name of this transform.

Similarly, a street named Main Street by the post office may have a section called Joe Smith Memorial Drive. The address 123 Main Street and 123 Joe Smith Memorial Drive would be the same location.

The setting that governs whether the suggestion list should offer the street name Main Street when processing an address on Joe Smith Memorial Drive is governed by the setting PRIMARY_NAME_ALTERNATE in the USA\OPTIONS group name of this transform.

Depending on how you want Data Quality for SAP Solutions to handle alternate city names and street names is suggestion lists, you should make changes to these two settings in the gdqc_gac_base transform.

To determine whether suggestion lists preserve alternate city and street names for U.S. addresses:

1. Open the gdqc_gac_base transform in the Project Architect.

2. In the Option Group Name panel, select COUNTRY(UNITED STATES)\OPTIONS.

For an explanation of how Data Quality for SAP Solutions uses suggestion lists, see “Maintain exception table of transaction codes” on page 53.

# ��

3. For the option ADDRESS_LINE_ALIAS, use the dropdown list to set the value CONVERT (to convert to the regulation postal address name) or PRESERVE (to preserve the alternate name).

The default is CONVERT.

4. For the option ASSIGN_LOCALITY, use the dropdown list to set the value to CONVERT (to use the alternate name), PRESERVE (to use whichever name was input), or VALID (to use the regulation postal name).

The default is CONVERT.


� #�

#� ��

�$$��<�7&�B��

This section lists the error codes and provides a description of each code.

.�� Data Quality for SAP Solutions displays technical error codes in the Error Log Report. You can access the Error Log Report by running the custom report /FLDQ/AD_REPT_DISPLAY_ERRLOG.

To run the custom report /FLDQ/AD_REPT_DISPLAY_ERRLOG:

1. Start the report /FLDQ/AD_REPT_DISPLAY_ERRLOG by running the transaction code SA38.


2. In the Program field, enter AD_REPT_DISPLAY_ERRLOG and click the Execute button (F8).

The Display Error Log Report appears.

The following table lists the technical error codes and a description for each:

&�!��$��

T507 The table from SAP for adding the ISO country codes is not specified.

T509 There is not a record in the IE_CH_ADDR table for getting an input address during ADR_VALIDATE or ADR_VALIDATE_QTR call.

T510 The IE_CH_ADDR table for getting an input address is not specified during ADR_VALIDATE or ADR_VALIDATE_QTR call.

T511 The EX_PROMPTS table for updating a suggestion prompt is not specified during ADR_VALIDATE call with a suggestion list option enabled.

T513 The IM_SUGGLIST table that is for adding the suggestion list is not specified during ADR_VALIDATE call with a sug-gestion list option enabled.

T515 The EX_DRIVER table for getting a driver record for match-ing is not specified during GET_MATCH_CODE call.

T517 There is no record in the EX_DRIVER table for getting the driver record for matching.

T518 The IM_MATCH_CODES table for updating the match codes is not specified during GET_MATCH_CODE call.

T520 The IM_FIELD_LIST table for adding the fields for matching is not specified during GET_INDEXED_FIELD_LIST call.

� #�

T522 The EX_CANDIDATES table for getting the candidate records for matching is not specified during GET_POTENTIAL_MATCH call.

T524 The IM_MATCHES table for adding the matched records is not specified during GET_POTENTIAL_MATCH call.

T526 The search mode parameter (EX_SEARCH_MODE) passed is invalid (must be I, U, or S).

T527 The address type parameter (EX_CURRENT_ADDR_TYPE) passed is invalid (must be 1 or 2).

T528 The Data Quality process timed out.

T529 Error returned from Data Quality during process.

T550 Invalid function object. Unable to process Gateway request.

T600 Error occurred during ADR_VALIDATE or ADR_VALIDATE_QTR call.

T601 Error occurred when creating input data for the Suggestion List process during ADR_VALIDATE call.

T602 Error occurred when retrieving output data for Suggestion List process during ADR_VALIDATE call.

T604 The batch ADR_VALIDATE_QTR dataflow failed to initialize.

T701 An invalid address type was passed to the GET_INDEXED_FIELD_LIST function.

T702 Invalid parameter values found while processing a GET_INDEXED_FIELD_LIST request.

T703 Unable to access stored person fields for a GET_INDEXED_FIELD_LIST request.

T704 Unable to access stored organization fields for a GET_INDEXED_FIELD_LIST request.

T705 Unable to access the list of temporary fields in order to create the indexed field list.

T749 An error occurred processing the GET_INDEXED_FIELD_LIST request.

T750 Error occurred during GET_ISO_COUNTRIES call.

T751 The key file utility could not be found during GET_ISO_COUNTRIES call.

T752 The key file could not be found during GET_ISO_COUNTRIES call.

T753 Permission error creating a temp file during GET_ISO_COUNTRIES call.

T802 Invalid parameter values found while processing a GET_POTENTIAL_MATCHES request.

&�!��$��

#" ��

T803 Unable to locate the configuration file potential match setting for the specified table and field.

T804 Invalid response from the Data Quality server.

T805 Unable to access candidate record information.

T806 Unable to communicate with the Data Quality server.

T807 Unable to access driver record information.

T809 The BATCH_MATCH dataflow failed to initialize.

T852 Invalid parameter values found while processing a GET_POTENTIAL_BATCH_MATCHES request.

T853 Unable to locate the configuration file potential batch match setting for the specified table and field.

T854 Invalid response from the DQXI server.

T855 Unable to access candidate record information.

T856 Unable to communicate with the DQXI server.

T898 An error occurred processing the GET_POTENTIAL_MATCHES request.

T899 An error occurred processing the GET_POTENTIAL_MATCHES request.

T900 An error occurred getting the display function modules for the GUI type.

T902 Invalid parameter values found during GET_MATCH_CODES call.

T903 Undefined application structure.

T904 Unable to access the application structure object.

T905 Unable to access the application structure object field.

T906 GetString method conversion exception on JCO Table.

T907 GetString method name does not exist exception on JCO Table.

T908 Driver record does not exist exception on JCO Table.

T909 Match record exists exception on JCO Table.

T910 Invalid socket table record index or record array not allocated exception.

T911 Insufficient or excess records for the reply tables returned from Data Quality.

T912 Undefined Data Quality response table.

T913 Dataflow error message returned from Data Quality.

T914 Dataflow status message returned from Data Quality.

T915 Unable to access the application input parameter list.

&�!��$��

� ##

��

Data Quality for SAP Solutions displays postal validation error codes within error message windows as the errors occur.

The following table lists the postal validation error codes and a description for each:

��$��9��

Data Quality for SAP Solutions displays a duplicate check error code within error message windows as the errors occur.

There is only one duplicate check error code.:

T916 Unable to access the application output parameter list.

T999 An error occurred processing the GET_MATCH_CODES request.

&�!��$��

��#��

$��

��

FZ01 There are more suggestions than the max suggestion set in the configuration file.

FZ02 The House number provided is blank.

FZ03 Invalid suggestion number is specified for Street record.

FZ04 The house number provided must be an odd number.

FZ05 The house number provided must be an even number.

FZ06 The PO Box number provided is blank.

FZ07 Invalid suggestion number is specified for PO Box record.

FZ08 The PO Box number provided must be an odd number.

FZ09 The PO Box number provided must be an even number.

FZ10 Invalid primary range is entered.

FZ11 The address is not a valid delivery point.

FZ12 The country is not defined.

FZ13 The address is not a valid delivery point.

FZ14 This record locked DPV processing. Consult the Data Quality documentation for the steps required to unlock DPV process-ing.

FZ15 The records primary range is a valid delivery point, but the secondary range is not valid in the DPV directory.

FZ16 The address is a confirmed delivery point, but the parsed sec-ondary range is not available on input.

FZ17 DPV processing is currently unavailable.

FZ18 The secondary unit range provided was invalid.

%)) ��

� ��!�'�

$��

��

D001 The driver record to be matched is empty or data with all spaces.

� %)%

%)� ��

2��<

�AD_REPT_UPDATE_PEND_RECS program, 84

7break key

configure, 75definition, 74

�check status

D record, 41COBOL, 21combine_house_num_and_pmb transform, 93configuring

IMG, 49RFC Server, 65

correction, 10country engines

enable and disable, 92CPI-C, 12

�D record, 41Data Quality

after installing, 22dataflows, 21documentation, 14installation, 21introduction to, 13troubleshooting, 88

data quality, 10Data Quality XI for SAP

components, 12dataflows, 91overview, 9

dataflows, 21, 68Data Quality XI for SAP specific, 91

deduplication. See also matchingdialog

suppressing, 53duplicate check, 73

definition, 74using, 77

Berror codes

duplicate check, 100postal validation, 100technical, 97

error log, 97error tolerant search, 73

definition, 74suppressing, 53using, 79

8fields

address reviewer, 56hit list, 58

FL_GDQC_SERVER, 35/FLDQ/AAK25, 27/FLDQ/AD_PUPDATE table, 54, 84/FLDQ/AD_REPT_DISP_QTRERRORLOG, 42/FLDQ/AD_REPT_DISPLAY_ERRLOG error log, 97/FLDQ/AD_REPT_LOAD_COUNTRIES, 37/FLDQ/AD_REPT_UPDATE_PEND_RECS, 84/FLDQ/AD_VAL_CNT table, 52/FLDQ/RSADRINI, 44/FLDQ/RSADRQU2, 41/FLDQ/RSMTCCODE, 44flrfcsrv.xml, 89

editing, 66fmt.xml, 67

:gdqc_gac_base transform, 94

3hit list, 77, 79

2IMG

configuration, 49IMG activities

Activate duplicate check index pools, 38Maintain exception table of transaction codes, 53Maintain fields for address reviewer, 56Maintain fields for duplicate hit list display, 58Maintain operating parameters, 60Maintain supported countries, 52Maintain table to activate SAP postal code check before

postal validation, 55SAP handshake with RFC server, 34, 51

initial setup program/FLDQ/RSADRINI, 44

installation, 17.SAR files, 27BAdIs, 27Data Quality, 21RFC Server, 23

connection closed, 82troubleshooting, 82

��1 %)

FJ2SE (Java 2 Platform, Standard Edition), 18

;log file

flrfcsrv_log.txt, 82

1Maintain exception table of transaction codes, 53Maintain fields for duplicate hit list display, 58Maintain operating parameters, 60Maintain supported countries, 52Maintain table to activate SAP postal code check before postal validation, 55manifest information, 89match

engine, 12matching, 11

name data, 76

�naming conventions, 8

'operating parameters, 60overview

correction, 10data quality, 10Data Quality XI for SAP, 12matching, 11parsing, 10standardization, 11

�P.O. Box addresses, 56parsing, 10postal validation, 69

engine, 12interactive cleansing, 70quarterly adjustment reports, 40suppressing, 53

/quarterly adjustment, 40

/FLDQ/RSADRQU2, 41error log, 42

6regions.xml, 67

understanding regions, 85requirements

BAdIs, 18

Data Quality Serverdisk space, 19operating system, 18

Java, 18OSS Notes, 18RFC Server

processor, 19RFC Server

configuring, 65console, 89flrfcsrv.xml, 66

overrides, 68installation, 23starting, 25stopping, 26troubleshooting, 89

RFC serverchecking connection, 82

RSMTCCODE program, 44, 85

0search

suppressing, 53standardization, 11start_rfcserver, 25suggestion list

alternate street/city, 94suppress dialog, 53suppress search, 53suppress validation, 53

.table

/FLDQ/AD_VAL_CNT, 52TCP/IP, 12transaction

SA38, 37, 41, 42, 44, 84, 97SAINT, 27SMGW, 26, 82SPRO, 34, 38, 50

transformcombine_house_num_and_pmb, 93gdqc_gac_base, 94

tsad10.txt, 67

4Unicode, 23, 25

troubleshooting, 82

@validation

suppressing, 53

%) ��

dq sap users guide 11 6

Documents