Data Quality Monitor Reports

Owned by Tom Fahey (Unlicensed)
Last updated: Jul 26, 2023 by Jacob Mathews (Deactivated)
3 min read

In the Data Quality Monitor, you can run two types of reports:

  • Advanced Diagnostics Report analyzes the detailed level statuses down to the security level for multiple entities, effective dates, Validation Rules, and Data Quality Rules.

  • History Report analyzes the history of results for multiple entities, effective dates, Validation Rules, and Data Quality Rules when a Data Quality Rule has been submitted multiple times for the same effective date.

When selecting search parameters, keep in mind that there is a maximum of 10,000 rows that can be displayed on the screen. 

Define Report Search

You define an Advanced Diagnostics or History Report by submitting search parameters to filter data results.

To define a search:

  1. From the Performance Desk in the Performance Center, open the Data Quality Monitor workspace, click Reports on the ribbon, and then select the Advanced Diagnostics Report or History Report.
    You see the Report workspace.

  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 grid. Effective Date, Fund, Validation Rule or Data Quality Rule are required fields.

  4. Select the Make This My Default Search check box if desired.

  5. Click Save if you wish to save the parameters.

  6. Click Search.
    You see the search results in the workspace as a heat map. 

  7. If needed, click Print to send the results to a printer. You can also click Export to save results in Excel or Text format.

Search Options

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

The following are the Advanced Diagnostics Report search options:

  • 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. The lists that you want to see results for.

  • Fund. The funds that you want to see results for.

  • Status. The options are Error, Not Run, Pass, and Warning.

  • Validation Rule. You can search based on a specific Validation Rule.

  • Data Quality Rule. You can search based on a specific Data Quality Rule.

You must select at least one Effective Date, List, Fund, and Validation Rule or Data Quality Rule.

The following are the History Report search options.

  • Begin Run Date. The first run date of the data you want to test.

  • To Run Date. The last run date of the range of run dates you want to test.

  • 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. The lists that you want to see results for.

  • Fund. The funds that you want to see results for.

  • Performance Model. Performance dictionary used for grouping the returns data.

  • Commit Sources. Specifies the source that the report uses to commit performance results to the PERFORM database.

  • Status. The options are Error, Not Run, Pass, and Warning.

  • Frequency. Reporting frequency. Options include Daily, Monthly, and Quarterly.

  • Data Quality Rule. You can search based on a specific Data Quality Rule.

  • Status Source. Options include Data Reviewed, Default, Manual Override, Manual Override Pending, Manual Override Rejected, Needs Further Review, Rule Override, Rule Override Pending, Rule Override Rejected.

  • Validation Rule. You can search based on a specific Validation Rule.

You must select at least one Effective Date and Data Quality Rule.

Configure Report View

You can adjust how the view is displayed in the workspace. The Views drop-down menu allows you save the view after configuring it. You can configure and save multiple views. Select Manage Views to choose a saved view or make further adjustments if needed.

The following are the Advanced Diagnostics Report 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.

  • Change column sort order. Click the column header to sort in descending or ascending order.