ONYX REPORTING LTD.
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
Search

June 05th, 2017

5/6/2017

0 Comments

 
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!
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Profile Picture Jae Wilson
    View my profile on LinkedIn

    Stay Informed.

    * indicates required

    RSS Feed

    Categories

    All
    Automation
    Basic Training Series
    Business Intelligence
    Connect
    Dashboard
    Data Pipeline
    Data Science
    Domo
    Excel Tricks
    Executive Training & Leadership
    Extract
    Jet Enterprise
    Jet Essentials
    New Release
    NP Function
    Onyx Reporting
    Planning
    Power Pivot
    Python
    Report Writing
    Statistics And Analytics
    TimeXtender
    Visualization

London, UK
jae@OnyxReporting.com
+44 747.426.1224
Jet Reports Certified Trainer Logo
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters