Open Studio for Data Quality
You can set up SQL business rules based on WHERE clauses and add them as indicators to table analyses. You can as well define expected thresholds on the SQL business rule indicator's value. The range defined is used for measuring the quality of the data in the selected table.
It is also possible to create an analysis with SQL business rules on views in a database. The procedure is exactly the same as that for tables.
For more information, see Creating a table analysis with an SQL business rule with a join condition.