Data Quality
Your Application Tables H
Use this page to:
To access this page:
- Select Data Quality > Your Applications in Navigation pane.
- 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
Use this page to:
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. |