Data Quality

Your Application Tables H

Your Application Tables V

To access this page:

  1. Select Data Quality > Your Applications in Navigation pane.
  2. Click the Tables icon.

Field

Description

APPLICATION

Displays the name of the application.

TABLE NAME

Displays the name of the table.

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

Displays the data quality score.

(100 - %Defects)

ERROR COST

Displays the cost of data quality issues for all reports based on data in the application table. 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 that none of the associated reports have an opportunity view, or that in all reports, the number of opportunities is less than the number of number of defects in the rolled up calculations.

Columns

Click to open the Your Application Table Columns page to view data quality information for the columns in the application table.

Reports

Click to open the Your Application Table Reports page to view all application table reports to which the logged in user has access.

Your Application Tables V

Your Application Tables H

Field

Description

Application

Displays the name of the application.

Table Name

Displays the name of the table.

Profile

Click to profile the application table. Refer to Profile a Target Table in Data Quality for information about profiling tables.

View Data

Click to view data within report.

View Fields

Click to open the Table Field (Results) page in Common to view the results of a profile run on the table.