Data Quality

Your Favorite 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 Favorite Reports V

To access this page, select Data Quality > Your Groups in the Navigation pane. The Your Favorite Reports page displays in the child pane.

Field

Description

Execute

Click to process the report for the logged in user.

Execute For All Users

Click to process all the reports within the group for all users who have access to the reports.

Reset

Click to reset running report. Reset report if process backs up due to network problems.

Your Favorite

Displays a green check for reports on this 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 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 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 checkbox 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

Displays the data quality score.

(100 - %Defects)

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.

Metrics

Click to view data about the report, e.g., the last time the report was ran.

Your Favorite Reports V

Your Favorite Reports H

This page contains the following tabs:

General tab

Field

Description

Execute

Click to process the report for the logged in user.

Execute For All Users

Click to process the reports for all users who have access to the reports.

Reset

Click to reset running report. Reset report if process backs up due to network problems.

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).

Report Generation Info tab

Field

Description

Execute

Click to process the report for the logged in user.

Execute For All Users

Click to process the report for all users who have access to the report.

Reset

Click to reset running report. Reset report if process backs up due to network problems.

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.

Queue

Click to open the Monitor page to view the process queue for reports.

View

Click to view data within report.

Metric Info

Latest Metric Date

Displays date when metrics were last built.

Metrics

Click to view data about the report, e.g., the last time the report was ran.

Reset Metrics

Click to clear metrics for the report. If the report is run more than once within a 24-hour period, the previous metrics are overwritten.

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 Cloud.