Assure DQ

 View Only
  • 1.  Creating summary controls/reports

    Posted 02-12-2020 12:47

    We are trying to create controls to achieve a certain outcome.

    The control would compare 2 files.  

    Each file has 10 records

     

    Today, we have created controls that do not do exactly what we want.

    Today, we get alerts for each of the discrepancies in the 2 files.

    We don’t want this.

     

    We want to be able to compare the 2 files and find all the discrepancies.

    We want one report, that lists all the discrepancies.

    We want one summary alert to go out.

    We would like to, if possible, know how to reference that report so that we can look at it later.



  • 2.  RE: Creating summary controls/reports

    Posted 02-13-2020 13:52

    Hi Daniel,

    The Scan control point option within Best Practices For Generating Alerts in Assure would prevent a large amount of alerts from being sent. The original discrepancy data would still exist in the original control point, which is where your report of all discrepancies would exist, but the scan control point would send the summary-level alert.

    For linking an alert to another control execution’s report, that isn’t possible within Assure alone. Customized alerts and reports are generally created by Perceive or Data360 DQ+, both using the data received by Assure.