Viewing output results for data rules, metrics, and rule sets

The View Output workspace will give you specific details about your data rules, rule sets, and metrics, in a History workspace that outlines a textual summary of the data quality element history, as well as graphical views showing the trend of the execution results. The output displayed differs based on the way you configured your output when you created each individual data rule, rule set, and metric. The following output elements are displayed for the following data quality items:

Data Rules

In the History workspace, you can view details about the individual executions of your data rules, such as statistics and benchmarks. Click Make Baseline to set the starting point in the graphical view. You also have the option of adding notes to the History workspace by clicking the Note icon.

To view the graphical history of a data rule, click the graph icon in the bottom left of the screen. You can change the start date and end dates of data rule executions you want to see in the graph, as well as change the view to display either % Not Met or # Met. Use the legend in the lower left side of the screen for details about the components of the graph.

Click View Details from the History workspace to display details for a specific data rule execution. In the View Details workspace, click the Overview or Results tab to view statistics and results about a particular data rule execution. You can see all exception details based on how you configured your output. What you will see here matches your output configuration. The fields you see are based on the columns you selected to include when setting output for a particular data rule. You can click Export to export the data rule data to a fixed or delimited text file.

Rule Sets

In the History workspace, you can view details about the individual executions of your data rules, statistics, and benchmarks. Click Make Baseline to set the starting point in the graphical view. You also have the option of adding notes to the History workspace by clicking the Note icon. Click View Details to display details for a specific data rule execution.

To view the graphical history of a rule set, click the graph icon in the bottom left of the screen. You can choose from the following graphical views:

• Validity
• Confidence
• Baseline Comparison
• Number of Rules Not Met

You can change the start date and end dates of rule set executions that you want to see in each graph. Use the legend in the lower left side of the screen for details about the components of the graph.

In the View Details workspace, click the Overview or Results tab to view statistics and results about a particular data rule execution. The Overview workspace provide provides details about the rule set, such as the mean, the standard deviation, statistics, and benchmarks.

The Results tab has four different views. Click the view you want to see in the Select View menu on the left side of the screen:

Record

This displays all of the records for a rule set. You can view all of the rules not met by for each execution result for a rule set. When you highlight an execution record for a rule set, you can see the individual records that violated the rule in the Rules Not Met By Selected Record workspace on the bottom of the screen.

Rule

This displays all of the rules for a rule set. You can select multiple rules at one time. You can select Union to show all records that failed one of the rules, or both of the rules, or you can select Intersection to show records that failed both ones that failed both rules.

Distribution

This view shows the percent of records that had one ore more violations. You can sort records by # of Rules Not Met or % of Rules Not Met.

Pattern

This view shows the pattern of your rule set records. It can show information such as, when rule A broke, rule B also failed 97% of the time. It provides a confidence to show if there is an association between two rules. It helps you find correlations between rule patterns and shows any dependencies or relationships between two rules.

You can see all exception details based on how you configured your output. What you will see here matches your output configuration. The fields you see are based on the columns you selected to include when setting output for a particular data rule. You can click Export to export the data rule data to a fixed or delimited text file.

Metrics

In the History workspace, you can view details about the individual executions of your metrics. Click Make Baseline to set the starting point in the graphical view. You also have the option of adding notes to the History workspace by clicking the Note icon. Click View Details to display details for a specific metric execution.

To view the graphical history of a metric, click the graph icon in the bottom left of the screen. You can change the start date and end dates of data rule metric executions you want to see in the graph. Use the legend in the lower left side of the screen for details about the components of the graph.

Click View Details from the History workspace to display details for a specific metric execution. In the View Details workspace, click the Overview or Results tab to view statistics and results about a particular metric execution. You can see all exception details based on how you configured your output. What you will see here matches your output configuration. The fields you see are based on the columns you selected to include when setting output for a particular metric. You can click Export to export the data rule data to a fixed or delimited text file.