Analysis of Rules & Audit Runs - Icons

When a validation rule is executed, it can have either of the following statuses:

Icon

Status

Definition

Example

 

Pass

Audit rule is passing. If it is master data exception, there are 0 exceptions. If it is not of type master data, then the rule is meeting the criteria

Forecast Name is 100% unique in SALES_FORECAST extract

 

Fail

Audit rule is not of type master data and the rule is failing

Run over run variance of qtyplanned in PURCHASE_PLAN is 5% for Supplier X which is more than the limit of 3%

 

Exception

Audit rule is of type master data and there are 1 or more exceptions

There are 2 routing records where yield is not between 0 and 1

Run Status & Readiness Score

Along with a status, a Readiness Score is also generated. Readiness score provides a second degree of information on the quality of data. If the data rule is failing, how bad is it. Readiness score creates a common unit for measuring the quality of data and allows result of audits calculating the overall data quality score across various data elements and types of audits.

Sample Audit Result

Audit Result Icon

Readiness Score

Count of finish good items in item master is 6000 which is within the tolerance of 5500 and 7000

 

100%

Count of finish good items in item master is 5000 which is not within the tolerance of 5500 and 7000

 

91% (5000 is 9% short of

5500)

Count of finished good items in item master is 3000 which is not within the tolerance of 5500 and 7000

 

54% (3000 is 46% short of 5500). Same test as above, but data quality is lower.

Forecast Name is 100% unique in SALES_FORECAST extract

 

100%

Run over run variance of qtyplanned in PURCHASE_PLAN is 5% for Supplier X which is more than the limit of 3%

 

33% (2% over limit of 3%)

There are 2 routing records where yield is not between 0 and 1. (total records are 100)

 

98% (98 out of 100 are good)

       

 Following insights are available with your audit results

Icon

Insight Type

Definition

 

History

History for all audits

 

Exception List

List of Exceptions for master data audits

 

Drill-down Analytical

Drill-down with Variance for aggregation audits

History Trend Insights

With history, you can get insights into the changes to the audit result from last run and also the trend of that audit over time. History insights can be useful to identify what audits to focus on.

History Trend

Definition

Focus Required

 

Flat. No change

Status Quo

or 

Positive Up – Test was a fail before and now pass. Test has been failing because results too low but now trending up.

Positive Down – Test has been failing because results were too high and now trending down.

Things are improving even if the tests are failing. May not need to focus.

or  

Negative Down – Test was passing before and is now failing. Or it has been passing but values are trending down and will cross the lower tolerance soon. Or it has been failing and things are getting worse

Negative Up – Test was passing before and is not failing. Or it has been passing but values are trending up to cross the upper tolerance soon

Things are getting worse for failed tests – requires top priority focus.

Things are trending in the wrong direction for passing tests – heads-up for future issues

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk