Skip to content

How to Show Business Partners with Data Quality Issues from CDQ.POOL in Lookup

Overview

By default, Lookup only returns CDQ.POOL Business Partners with high data quality: records with a WARNING or ERROR quality status are filtered out. This tutorial describes how to enable the SHOW_CDQ_POOL_QUALITY_ISSUE_RECORDS feature so Lookup also returns these lower-quality Business Partners, together with a quality indicator and a filter to narrow results by quality status.

Info

Business Partner type-dependent validation rules determine whether a record is classified as WARNING or ERROR. High-quality Business Partners are always included in Lookup results, regardless of this setting.

Learning Goals

In this tutorial, you will learn how to:

  • Understand what the SHOW_CDQ_POOL_QUALITY_ISSUE_RECORDS feature controls
  • Enable the feature for Lookup
  • Filter Lookup results by quality status (ERROR, WARNING)
  • Review the quality status of a Business Partner in the search results and in the Business Partner details
  • Understand the default behavior when the feature is off

Prerequisites

To go through the tutorial, you have to log in to the CDQ Cloud Apps.

Click on Sign In and enter your username and password.

Warning

If you have no access to the CDQ Cloud App, ask your internal point of contact to create a CDQ dedicated account. Account details will be sent by email.

Step 1: Enable the Feature for Lookup

  1. Go to the First Time Right cloud app.
  2. Click the Settings button to open Request Settings.
  3. Go to the Augmentation tab.
  4. In Data Sources, make sure CDQ.POOL is selected.
  5. Under Features On, add SHOW_CDQ_POOL_QUALITY_ISSUE_RECORDS alongside ACTIVATE_DATASOURCE_CDQ_POOL.
  6. Click Save Changes.
Request Settings - Augmentation tab, Features On with ACTIVATE_DATASOURCE_CDQ_POOL and SHOW_CDQ_POOL_QUALITY_ISSUE_RECORDS
  1. A confirmation message, "Settings have been saved," confirms the feature is active.

Step 2: Search and Review Results Including Lower-Quality Records

  1. Run your search as usual in First Time Right.
  2. Business Partners with a WARNING or ERROR quality status are now included in the results, alongside high-quality matches.
Info

High-quality Business Partners are always returned, whether or not this feature is enabled. The feature only adds WARNING and ERROR records to what is already returned.

Step 3: Filter Results by Quality Status

  1. In the search form, next to the Identifier, Type, and Lookup fields, use the new Quality Status filter.
  2. Select ERROR, WARNING, or both to narrow the results to lower-quality Business Partners.
  3. Leave the filter empty to return all results: high-quality Business Partners plus any with ERROR or WARNING status.
Filter Selection Results Returned
Empty (no selection) High-quality + ERROR + WARNING
WARNING High-quality + WARNING
ERROR High-quality + ERROR
WARNING and ERROR High-quality + WARNING + ERROR
Quality Status filter with ERROR and WARNING options
Info

The filter only affects lower-quality Business Partners; high-quality Business Partners are always included, whatever the filter selection.

Step 4: Review the Quality Status in Business Partner Details

  1. Select a Business Partner with a quality issue from the results.
  2. A Quality Status section is displayed in the Business Partner details, listing each individual data quality issue together with its severity (Error or Warning) and a human-readable description.
Quality Status section in Business Partner details, listing severity and details for each data quality issue

Feature Behavior Summary

Feature Off (default)Feature On
Business Partners with WARNING/ERROR qualityExcluded from Lookup resultsIncluded in Lookup results
Quality status label on each resultNot shownShown (ERROR/WARNING badge next to match score)
Quality status filterNot visibleVisible, multi-select (ERROR, WARNING)
Quality Status panel in BP detailsNot displayedDisplayed, listing severity and description for each issue found

Summary

In this tutorial, you learned how to enable the SHOW_CDQ_POOL_QUALITY_ISSUE_RECORDS feature so Lookup also returns CDQ.POOL Business Partners with WARNING or ERROR data quality, how to filter results by quality status, and how to review the quality status of a Business Partner in the search results and in its details.



Your opinion matters!

We are constantly working on providing an outstanding user experience with our products. Please share your opinion about this tutorial!