Statuses are rolled up from the lowest level to the higher levels, according to the "One negative – All negative" rule. For example, if an underlying status is red, then the overall status would be red. The same rule applies for the other color codes. Data Quality Monitor error codes are captured in the Automation Center's exceptions tables. You can add and manage error codes in the Automation Center's Exceptions workspace. See "Manage and Resolve Exceptions" in Automation Center User Guide.

Anchor
dqm_use_the_data_quality_monitor_1441 dqm_use_the_data_quality_monitor_1441

Anchor
_Toc441239665 _Toc441239665

Define Heat Map Search

You define a heat map by submitting search parameters to filter data results.

To define a heat map search:

1. From the Performance Center window, click Performance Desk and click Data Quality Monitor in the left navigation.
   You see the Data Quality Monitor workspace displaying the last viewed heat map.
2. Click the expand arrow next to Search.
   You see the available search options.
3. Define search options to limit the data displayed in the heat map.
4. Select the Make This My Default Search check box if desired.
   The next time you log on, you see the results of this search reflected in the heat map.
5. Click Save if you wish to save the parameters.
6. Click Search.
   You see a heat map based on your search selections.

Anchor
dqm_use_the_data_quality_monitor_5642 dqm_use_the_data_quality_monitor_5642

Anchor
_Toc441239666 _Toc441239666

Search Options

You can define a search to limit the data displayed in a heat map.

The following are the heat map search options:

• Begin Run Date. The beginning date for validation test results. The default is yesterday. The run date is the date the validation rule was run and not the effective date of the data or calculation being tested.
• To Run Date. The ending date for validation test results. The default is today.
• Begin Effective Date. The first effective date of the data you want to test.
• To Effective Date. The last effective date of the range of effective dates you want to test.
• List/Composite. The lists or composites you want to see results for.
• Fund. The funds that you want to see validation results for.
• Performance Model. The performance model set in the Data Quality Rule that contains the validations.
• Commit Source. The designated sources used by the performance calculation that produced the validation results.
• Status. You can filter for only the status you want to review. The options are Error, Not Run, Pass, and Warning.
• Display. The options are Most Recent and All. The Most Recent option limits the validation results to only the last validation result for that run date, effective date, entity performance model, or frequency.
• Frequency. The options are Daily, Monthly, and Quarterly, in any combination.

Anchor
dqm_use_the_data_quality_monitor_164 dqm_use_the_data_quality_monitor_164

Anchor
_Toc441239667 _Toc441239667

Configure Heat Map View

You can adjust how the heat map view is displayed in the workspace and save the view. Creating groups and sub-groups or changing the arrangement of columns does not change the data or the underlying tests.

The following are the heat map configuration options:

• Group. Click a column header and drag it to the place labelled Drag a column here to group.
• Sub-group. Click a second column header and drag it next to the first header.
• Remove a group. Click the X next to the column header.
• Collapse a group. Click the up arrow next to the group header.
• Expand a group. Click the down arrow next to the group header.
• Change column order. Select a column header and drag it to a new position.
• Create default view. Select the Make this my default view check box. The next time you log on, you see the results arranged according to your specifications.
• Change column sort order. Click the column header to sort in descending or ascending order.

Anchor
dqm_use_the_data_quality_monitor_2366 dqm_use_the_data_quality_monitor_2366

Anchor
_Toc441239668 _Toc441239668

Save and Manage Heat Map Views

After you configure a heat map view, you can save it for future use. Once you have saved the heat map view, you can edit the name, duplicate the view, or delete the view.

To save a heat map:

1. From the Performance Center window, click Performance Desk and click Data Quality Monitor in the left navigation.
   You see the Data Quality Monitor workspace displaying the last viewed heat map.
2. Select the search parameters you want to view and configure the heat map to meet your requirements.
3. Click the Status Heat Map drop down and select Save.
4. Enter a name for the view.
5. Select the Make My Default View check box if desired.
   The next time you log on, you see the results of this search/view reflected in the heat map.
6. Click Save.
   You see the view listed in the drop down.

To manage heat maps:

1. From the Performance Center window, click Performance Desk and click Data Quality Monitor in the left navigation.
   You see the Data Quality Monitor workspace displaying the last viewed heat map.
2. Click the Status Heat Map drop down and select Manage.
   You see the Manage Views dialog box listing the available views.
   Options include:
   –  Edit. Allows you change the name of the view.
   –  Duplicate. Allows you change the configuration settings and save under a new name.
   –  Delete. Allows you to delete the view.
3. Select a view and then select an option by clicking the icon on the ribbon.
4. Enter a new name if required.
5. Click OK.
   You see the changes in the drop down.

Anchor
dqm_use_the_data_quality_monitor_2064 dqm_use_the_data_quality_monitor_2064

Anchor
_Toc441239669 _Toc441239669

Use Diagnostics Viewer

With the Diagnostics Viewer, you can see detailed information about a result in the heat map including the entity or security tested, the logic of the test, the values used in the test, and the result of the test.

To see the data underlying heat map:

1. From the Performance Center window, click Performance Desk and click Data Quality Monitor in the left navigation.
   You see the Data Quality Monitor workspace displaying the last viewed heat map.
2. Right click a cell and select Diagnostics Viewer.
   You see a new workspace tab with the effective date, logic definition, entity ID, security alias or issue name, status, and validation test result.
3. Click the Actions tab and select Print or Export if desired.

Anchor
dqm_use_the_data_quality_monitor_8439 dqm_use_the_data_quality_monitor_8439

Anchor
_Toc441239670 _Toc441239670

View Commit Journal Results

With Data Quality Monitor, you can link the Commit Journal to view the most recent committed results including entity, begin and end dates, frequency, and numeric and alphanumeric reference.

To view Commit Journal results:

1. From the Performance Center window, click Performance Desk and click Data Quality Monitor in the left navigation.
   You see the Data Quality Monitor workspace displaying the last viewed heat map.
2. Select a row in the heat map and select Commit Journal Results on the ribbon. Or right click and select Commit Journal Results.
   You see the Commit Journal in a new tab with the most recent committed results for that entity, frequency, and effective date.
3. Click the Actions tab and select Print or Export if desired.