Data Quality

Your Object Reports H

NOTE: When a user accesses this page in the Navigation pane, the fields below display. When a user clicks the View icon on this page to view report data, the report title still displays as the page name even though columns that display depend on the columns on the generated report. In this case, the page displays the report’s columns only and not the fields below.

Your Object Reports V

Use this page to View Your Object Reports.

To access this page:

  1. Select Data Quality > Your Objects in the Navigation pane
  2. Click the Reports icon.

Field

Description

Your Favorite

Displays a green check if the report has been added to the Your Favorite Reports page.

QUALITY DIMENSION

A Quality Dimension is a recognized term used by data management professionals to describe a feature of data that can be measured or assessed against defined standards to determine data quality. Refer to Register Quality Dimensions for more information.

NOTE: Data Quality is delivered with six industry standard quality dimensions: Accuracy, Completeness, Conformity, Integrity, Timeliness and Uniqueness.

NOTE: All Error reports require a quality dimension.

DATA QUALITY RULE

Displays the name of the report.

Report Warning

Displays one of the following two options:

  • No warnings
  • Report appears multiple times because it has different User filters in different Groups

A report can appear multiple times on the Your Object Reports page because it could be assigned to multiple groups, have different filters applied, and be executed independently. This field communicates the duplication of reports.

REPORT TYPE

Displays the categorization of report. Values are: Error, Information and Metric.

SIGMA LEVEL

Displays the sigma level based on data quality score calculations.

The Enable Sigma Level check box on the Parameters page must be checked for this field to display.

OPPORTUNITIES

Displays the number of records in the opportunity view, which contains the full set of possible records that could potentially fail in the error report.

DEFECTS

Displays the number of errors on the report.

DPMO

Displays the Defects Per Million Opportunities as calculated based on Opportunities and Defects.

DPMO = (Total Defects / Total Opportunities) * 1,000,000

DEFECT PERCENTAGE

Displays the defect percentage.

(Total Defects / Total Opportunities)* 100%

DATA QUALITY SCORE

Displayed the data quality score.

(100 - %Defects)

ERROR COST

Displays the cost of data quality issues for the report. Error cost is calculated by multiplying the number of errors on a report by the report's cost per failure, entered on the Vertical View of the Repository Reports page.Refer to Configure the Business Value Dashboard for more information.

STATUS

Displays status based on defect percentage and data quality score thresholds. Statuses are Red (critical), Yellow (warning) and Green. Hover over a Status icon to view the threshold.

NOTE: A Warning icon (yellow triangle) in the Status field indicates the error report does not have an assigned opportunity view, or that the number of opportunities is less than the number of number of defects in the rolled up calculations for the report.

View

Click to view data within report.

Download a file

Click to download a file that contains the report data.

Your Object Reports V

Your Object Reports H

Use this page to View Your Object Reports.

This page contains the following tabs:

General tab

Field

Description

Report Info

Repository

Displays name of database where reports reside.

Group ID

Displays the ID of the group to which the report belongs.

Data Quality Rule

Displays the report title entered by users when they register the report to the report repository. The title should briefly describe what the report's focus is, such as Leading Spaces in Customer Names or Informal Word found in Customer Name. If the field is blank, a user has not entered a title for the report.

Report View

Displays name of report as it appears in the repository. Click link to view SQL code used to generate report.

Opportunity View

Displays the name of the opportunity view, which contains the full set of possible records that could potentially fail in the associated error report.

NOTE: An opportunity view is only applicable to Error reports.

The opportunity view is used in data quality score calculations. When calculating data quality scores on the Your Groups, Your Objects, and Your Applications summary and report pages, error reports without an opportunity view are not included in the data quality scoring calculations.

The opportunity view must include all required key fields of the error report and any fields needed for user filters.

Where Clause

Displays filter applied to report for user to limit data displayed in report.

Order By

Displays columns by which the report is sorted.

Status

Displays status based on defect percentage and data quality score thresholds. Statuses are Red (critical), Yellow (warning) and Green. Hover over a Status icon to view the threshold.

NOTE: A Warning icon (yellow triangle) in the Status field indicates the error report does not have an assigned opportunity view, or that the number of opportunities is less than the number of number of defects in the rolled up calculations for the report.

Classification

Quality Dimension

A Quality Dimension is a recognized term used by data management professionals to describe a feature of data that can be measured or assessed against defined standards to determine data quality. Refer to Register Quality Dimensions for more information.

NOTE: Data Quality is delivered with six industry standard quality dimensions: Accuracy, Completeness, Conformity, Integrity, Timeliness and Uniqueness.

NOTE: All Error reports require a quality dimension.

Report Type

Displays the categorization of report. Values are: Error, Information and Metric.

Data Quality Scoring

Threshold ID

Displays the threshold ID used for data quality scoring.

NOTE: If no threshold is selected the threshold ID set on the Parameters page is used in the data quality status calculation. Refer to Register Data Quality Score Thresholds for more information.

Scorecard Link

This field is not used.

Impact

Implication

Displays description of what the report means to the business.

Comment

Displays comment or description about report.

Business Value

Currency

Displays the currency set on the Parameters page, and used for the Cost per Failure calculation on the Business Value dashboard.

Cost Per Failure

Displays the cost per failure applied to each error record.

NOTE: The Cost per Failure value only displays on the Error type reports (Business Readiness, Target Readiness, and Error).

Favorite Settings

Favorite

Displays a green check if the report has been added to the Your Favorite Reports page.

 

Report Generation Info tab

Field

Description

Opportunity Count

Displays the number of records in the opportunity view, which contains the full set of possible records that could potentially fail in the error report.

Defects

Displays the number of errors on the report.

Process Started On

Displays date and time when report started running.

Process Completed On

Displays date and time when report completed running.

View

Click to view data within report.

Documentation tab

External Reference

Displays hyperlinks and supporting commentary that demonstrate the connection from data-related assets in the Stewardship Tier to external references in other platforms and applications.

Syniti recommends a report be linked to a Term, Rule or Data Set in Syniti Knowledge Tier.