June 05th, 2017

This tutorial takes a Jet Professional report and shows how to implement time-based performance metrics in the Jet Enterprise standard NAV project.

Elements covered:

• Creating a custom reference table (Holiday Schedule).  Alternatives to a Custom Table include importing Excel Spreadsheets, Access databases or other SQL sources (like DQS).
  
• Customizing the Date Dimension with new attributres (the [Is Holiday] attribute) using a SQL CASE statement.
• On Time Delivery metrics ([Num Days Act] and [Num Days Working]) on the Sales Shipment Header using SQL DateDiff and custom SQL Script Actions.
  
• Implementing core business logic in the Data Warehouse (SLA (service level agreement) analytics)

In case you missed the original post, I've also included the video of the mentoring session I did for the original Jet Professional Report.

In the tutorial I review using the Company= argument for multi-company reporting, and include information about report optimization using Data Dumps / Record Keys instead of a slew of NL("First") functions.

Hope you enjoy!