Data Quality Monitor Update Status

The Data Quality Monitor provides you with two methods of overriding the status of validation rules:

  • Override status manually

  • Override status with date rules

Override Status Manually

In the Data Quality Monitor, you can manually override the status of validation rules for one or more records using the Update Status feature. Manual overrides are automatically updated to the latest status generated by the event of a rerun of the Performance Calculation or Automation Center. Manual overrides are overridden by Status Override Rules with rule override.


To manually override the status of one or more records:

  1. In Performance Center, click Performance Desk and select Data Quality Monitor in the left navigation.
    You see the Data Quality Monitor workspace displaying the last viewed heat map.

  2. Click the checkbox(es) next to the record(s) you want to override and click Update Status on the ribbon. Or, right-click a record and select Update Status.
    You see the Change Status dialog box.

  3. Select the New Status (Error, Warning, Pass) and Reason Code (Data Error, Data Reviewed, Needs Further Review, Potential Data Issue) from the drop-down lists, and then enter Comments and click Submit.
    You see the Overrides Confirmation dialog box displaying the Old Status and New Status of the selected records.

  4. Click OK to confirm the override and create a Pending record. Or, click Cancel to withdraw the change.

  5. To view all of the pending updates, click Pending Approvals on the ribbon .
    You see records with an Approval Status of Manual Override Pending in a separate window, displaying two options, Authorize and Reject.

  6. To commit the changes, select the appropriate record(s) and click Authorize, then click Save.
    The Approval Status value changes from Manual Override Pending to Manual Override Approved.

  7. To discard the changes, select the appropriate record(s) and click Reject, then click Save. The Status is not updated and remains in Manual Override Pending status.

Override Status with Date Rules

In Data Quality Monitor, you can also override the status of validation rules by applying an override rule for a single day or a date range. Applying a date rule ensures that the updated status will not be changed in the event of a rerun of the Performance Calculation or Automation Center.

  • The Date Range option is only enabled when you select a single Effective Date, Entity, and Validation Rule.

  • You cannot override an approved rule for the same entity and validation rule that overlap the same effective dates

  • You can override a pending rule with a different pending rule for the same entity, effective dates, and validation rule.

To override the status with a date rule:

  1. In the Data Quality Monitor workspace, click the checkbox next to the record you want to override and click Update Status on the ribbon. Or, right click on a record and select Update Status.

  2. Select the New Status and Reason Code from the drop-down lists and enter Comments

  3. Click Date Range Rule, select the End Date, and then click Submit.

  4. The Overrides Confirmation screen displays the pending rule. Click OK to create the pending rule.

  5. To view Pending and Approved Rules select Setup in the left navigation of Performance Center and then click Status Overrides Rules.
    You see the Status Overrides Rules workspace.

  6. Click Pending Rules on the ribbon.
    You see the Pending Rules dialog box.

  7. To commit the changes, select the appropriate record(s) and click Authorize.
    The Approval Status changes from Pending to Authorized.

  8. Click Save to commit the changes. Or, click Cancel to close the dialog box without any change.

  9. To reject the changes, select the appropriate record(s) and click Reject.
    The Approval Status changes from Pending to Rejected.

  10. Click Save to commit the changes. Or, click Cancel to close the dialog box without any change.

Status Audit

In the Data Quality Monitor, you can use the Status Audit ribbon item to view all status audit changes or select a specific record. You can also right click to view the status audit changes to review specific changes.

Status Audit Permissions

In the System Management Center, you can control the permissions for functions associated with the Status Audit functionality. To maintain permissions, go to the System Management Center, select Performance Center Roles, and then click the Data Quality Monitor tab. The options in the Data Quality Maintenance section are described below.

Option

Definition

Option

Definition

Allow Status Audits

Enable/Disable the ability for a user to change statuses.

Allow Approve Status Audits

Enable/Disable the ability for a user to approve status change(s).

Allow Status Override Rules

Enable/Disable the ability for a user to create a status override rule.

Allow Authorize/Reject Rules

Enable/Disable the ability for a user to Authorize or Reject status override rule(s).