Tutorial: How to monitor Business Partner updates?

Overview

Use Case

This use case describes the recommended use of CDQ Cloud Services for establishing continuous data quality monitoring for Business Partner data.

Learning Goals

In this tutorial, the user will be focused on:

• Creating configuration based on validation profiles using Data Validation Configurator cloud app.
• Creating data monitor based on prepared configuration using Data Monitoring Configurator cloud app.
• Analysing validated data with Data Quality Dashboard cloud app.
• Downloading reports using Batch Data Validation cloud app.

Prerequisites

Login

Log into the CDQ Cloud Apps

Data Mirror

Step 1: Data Quality Monitor Configuration

Create a configuration for the Data Quality Rules Engine that is used for monitoring

1. Pick Data Validation Configurator from accessible apps
2. Click create for a new configuration
3. Name the new configuration Standard
4. Click create

5. Check the Data Validation Configuration table below. Every configuration has a unique number assigned.

6. Select newly created configuration for an edition
7. Edit the parameters in the "Details of Standard configuration" section:
   • select Standard Validation Profile from the list
   • set the Rule Status to Release

Validation profile	Rule status

8. Limit validation results with the county filter in the "Data Quality Rules" section
   • Use filter by country and set DE-Germany
   • Set Release state of the rule

Setting filter	Rule state

Create a data quality monitor and activate it using the previously created configuration

1. Pick Data Monitor Configurator from accessible apps
2. Click Add New Data Monitor

3. In the creation windows pick:
   • Data Mirror created before ( Prerequisites )
   • Configuration created in the Step 1
   • Component from the list
   • Schedule plan
   • Click Create New Data Monitor

Thanks to the schedule set during creation, the validation process of the pointed data mirror will run automatically. The report will be sent directly to the mailbox to be assigned to the user.

Step 2: Data Quality Measurement Results Analysis

Analyze Data Quality in the Data Quality Dashboard

To analise the quality of the data, it is important to prepare quality dashboard:

1. Select your workspace where the desired data source is located

2. Open the filter by clicking on the icon in the upper-left corner of the page

3. Set data source and select the countries you want to validate the data for
4. Select Apply button

5. Check the data in the updated dashboard

6. Check the Number of Distinct Records and Records with ERROR Violation increase/decrease indicator compared to previous data quality monitor run

Number of Distinct Records	Records with ERROR Violation

7. Verify the rest of the charts

Download Data Quality Reports

Batch Data Validation app will be used as a report reader-generated from created data monitor. When the job based on the Data Monitor schedule starts the status of completion will be visible in the Data Validation Jobs.

1. Validate the job status:

Job ID	Job in progress	Job is done

2. If it's finished, scroll down to the Data Validation Reports

3. Check the completion status of the report
4. Select Show Results

5. Select one of the results provided by the job and download it

The Job result page provides a list of all generated reports and the Dashboard with charts.

Your opinion matters!

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

Mail our developer-portal team: developer-portal@cdq.com