Adding Multiple dspMonitor Reports to a Group

Data Goverance is a critical component of any company's data strategy. The reliability and cost-effectiveness of an ERP system is only as good as the quality of data that resides within it. One of dsp's data solutions addresses this very concern, providing a powerful and easy-to-use tool in the form of dspMonitor. This passive data goverance application allows users to analyze specific sets of data in an ERP system and pull metrics to determine the current 'health' of the system.

Such audits are done with reports, written in SQL, which are usually meant to view data from one data set, such as Vendors, Customers or Materials. Registering such reports is not a difficult process, but can be time consuming, splitting time between registering the report with the appropriate repository and adding additional metadata, and then registering the report to a user's group. While individual registration of reports can be done in this fashion, if there are multiple reports for a given data set or if these reports are provided by a third party, the procedure for report registration can get tedious.

Thankfully, there is a way to register a set of reports associated to a particular data set (called Objects in dspMonitor) all at once. dspMonitor comes loaded with over 400 pre-made reports which address common issues in data, ranging from finances to customers to materials. Further, the application has a default list of common data sets, or Objects, already added to the system. These are:

• Customer
• Equipment
• Finance
• HR
• Material
• Purchasing
• Vendor

Users can add additional Objects as well. This should be done prior to registering a report that would utilize this Object. To add multiple reports in an Object:

1. Users register the report as usual, associating it with the report's repository in dspMonitor.
2. Opportunity views, Quality Dimensions and Thresholds should be added for proper metrics.
3. A target table and target field should be added to the report to enchance metrics.
4. When a report is registered, it can also be added to an Object while still in the Configuration / Report Repository / Repository Reports level.
   NOTE: a report can be added to more than one Object.
5. While in Configuration, users would access Objects. Reports may be added at this level too.
6. Once all reports have been satisfactorily added to an Object, users would select Publish.
7. A new window will display where the user will choose which Group will house all the reports from the Object.
8. Select Execute to complete the process.
9. To verify transfer, users would access Groups to find all reports in a particular Object had been added to the group, saving a lot of time, had it been done for each individual report.

BackOffice Associates offers professional, instructor-led training in an interactive hands-on style. To view the latest schedule of classes currently offered, visit http://www.boaweb.com/company/product-training/