Adding a Value Standard Table in dspMonitor

Value Standard Tables in dspMonitor is a valuable tool users can use to quickly and effectively update their reports that incorporated such tables without having to add additional code to the report itself. In short, a value standard table can be defined as tables that interpret or capture functionality of values in the target ERP, where the data does not exist in the target system. For example, if your ERP system contains a standard list of units of measure, i.e. ounces, pounds, kilograms, feet, meters, etc., then a report might be written to find records that may contain measurement units that would be outside the value standard list. Another example may not necessarily relate to the configuration of the ERP system per se, but as general value guidelines, such as a list of special characters, which may be incompatible with the ERP system (@,#,%,^, etc.).

The advantage of incorporating that list of standards within dspMonitor is that, if the report was built using the data from this list, then, if the list changed, users can easily update the standard list within dsp, thereby updating the report. This functionality is accomplished by the use of construction tables found within the dspMonitor application.

Part of the dspMonitor install is a webapp called MC. dspMonitor pulls data from the pages found within the MC webapp. Users must be aware that all tables and views must therefore be contained within the MC database.

Prepare the webapp and data

1. Add a table with data to the MC database using naming convention dc[tablename].
2. Add a horizontal view to the MC database using naming convention web[table]hor.
3. Add a page to the MC webapp in Admin > Webapps > MC.
4. Add the table and horizontal view to the page, allowing inserts and deletions.
5. Add page to MC menu switchboard.
6. This page and data can now be accessed by selecting the Construction tab in the Context bar.

Incorporate Value Standard Table Data into a Report

1. Add the value standard table to the report view in SQL Server using a join or cross join.
2. Filter as required.
3. Save the view.
4. Process the updated report in dspMonitor to verify results.

With the new value standard table in place within dspMonitor, users can add, edit or delete records from the table. To update the report with the altered value standard table data, the report must simply be re-processed in dspMonitor without having to alter the underlying code in SQL Server. This provides the ultimate flexibility when dealing with data sets that evolve over time to satisfy a business' ever-changing needs.

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/