What is Data Quality Module
- Data Quality Module (DQM) helps quickly find discrepancies and errors in your project data.
- This module contains two different user rights settings on the User Rights page: one setting for creating/editing custom rules, and one for executing rules.
Pre-defined Rules
- To pull up the list of rules, click on "Data Quality" in the left margin (circled in red below)
- There are 8 pre-defined rules. They cannot be modified, reordered, or removed.
- To find discrepancies for a given rule, click the Execute button next to it, or click the "All", "All except A&B", or "All custom" buttons to file multiple rules at once.
Custom Rules
- Custom Rules can include mathematical operations and also advance functions to provide you with a great amount of power for validating your project data.
- The project variable names may be used in rule logic by placing the variable name inside square brackets [].
- Data Quality rules must always result with a TRUE or FALSE condition and NEVER a value.