Anomalous Data

From the Data Quality Reports page, you can view an Anomalous Data report. To view:

1. Click the hyperlink of the Name field to view the Anomalous Data report
   
2. Click to exclude the attribute from the report. Click to include the attribute in the report.
   NOTE: No attributes are included in the report by default.
3. Click the Show Removed checkbox to show excluded attributes. Unclick the Show Removed checkbox to hide excluded attributes.
4. Enter the percentages for the RAG thresholds. Click the Update button to save the RAG thresholds.
5. Click the hyperlink of the Anomalous Records field to filter the Data Records table
   1. The selected attribute is displayed in the heading
      
   2. Click to clear the selected attribute
6. Click the hyperlink of the Acceptable Values field to define the acceptable values for the attribute
   1. All values are included for each attribute by default
      
   2. The value or number of selected values is displayed when acceptable values are defined
      

Acceptable Values

From the Anomalous Data tab, you can add acceptable values. To add:

1. Click the hyperlink of the Acceptable Values field to bring up the Acceptable Values for Attribute dialog
2. Click the Populate from Data button to populate the acceptable values from the existing attribute values. Enter a value and click to manually add an acceptable value. Click to delete an acceptable value. Click the Clear List button to delete all acceptable values. Enter a regular expression to match acceptable values based on a pattern. Click the Update button to save the acceptable values. Click the Close button to cancel the operation.
   

Regular Expressions

See Regular Expressions Overview for details on the syntax for regular expressions. Regular expressions entered as acceptable values must be bracketed by slashes (e.g., /Regular Expression Goes Here/). The following table outlines regular expression examples.

Data Records

The Data Records tab provides the ability to manage data records in the data quality report.

Available operations:

• View data records in the data quality report
  • Columns available depend on what is defined for the data type
• View the properties of data records by clicking the hyperlink of the Name field
• Edit data records by selecting a record (row) and clicking the Edit Record button on the toolbar
• Assign data records to a wave
  • Select all records (rows) on the page by clicking the Select All button on the toolbar
• You can also change the number of visible rows in the table, view full screen, set column visibility, export to CSV or Excel, refresh the table, and search for text

Edit Record

From the Data Records tab, you can edit the properties of data records. To edit:

1. Select a record (row) to edit
   
2. Click the Edit Record button on the toolbar to bring up the Edit Record dialog
   
   1. The edit button is grayed out unless a record (row) is selected
      
      
   2. The edit function is only available to users in the Administrator security group
3. Edit the properties of the data record
   
   1. Name – Name of the data record (required)
   2. Data Type Specific Columns – Columns specific to the data type
      NOTE: Lookups with a large number of records will be converted from a normal drop down menu to a dialog.
4. Click the Update button when finished to update the data record. Click the Close button to cancel the operation.

Assign to Wave

From the Data Records tab, you can assign data records to a wave. To assign:

1. Select one or more records (rows) to assign to a wave
   
2. Click the Assign to Wave button on the toolbar to bring up the Assign Records to Wave dialog
   
   1. The assign button is grayed out unless a record (row) is selected
      
      
   2. The assign function is only available to users in the Administrator security group
3. Select the waves that you want to assign to from the Waves drop down and then click the Assign button. Click the Close button to cancel the operation.