LS Insight (2022.2) Release Notes

About This Release

Released - August 18, 2022

This version of LS Insight supports versions 8.4 and later of LS Central On-premises and later versions of LS Central In-cloud (SaaS). Setup of LS Insight for LS Central In-cloud (SaaS) needs some additional setup from the standard LS Insight onboarding process which is explained in detail in the onboarding documentation.

In this version we have added Transfer Orders pages in the Supply Chain report and added Basket Value and Product Mix page in the Sales report. Mobile-optimized views of the report's pages have been added. Supply chain and Actionable Insights reports are now supported for LS Central SaaS by adding pre-staging scripts and a new job scheduler header file to the product package.

Note: Updates for version 2022.1.1 are provided in a special update package. If you have already set up version 2022.1.1, you can update to 2022.2 without creating a new instance of LS Insight. See update guidelines for more information. Please note that if you have customizations in your LS Insight instance, you need to make sure before you start that the updates do not affect these customizations.

The following is a list of changes and key features in LS Insight version 2022.2.

New or Enhanced Features

Setup

Product package

Prestaging scripts have been added to product package for the following tables:

  • ACI Alert Detail - INS_NORMAL_COUNT
  • ACI Alert - INS_NORMAL_COUNT
  • ACI KPI Family - INS_NORMAL_FULL
  • ACI KPI Group - INS_NORMAL_FULL
  • ACI KPI Pack - INS_NORMAL_FULL
  • ACI KPI - INS_NORMAL_FULL
  • ACI Notification - INS_NORMAL_COUNT
  • ACI Signal - INS_NORMAL_COUNT
  • ACI User Group Member - INS_NORMAL_FULL
  • ACI User Group - INS_NORMAL_FULL
  • Purch_ Cr_Memo Hdr_ - INS_NORMAL_FULL
  • Purchase Header Archive - INS_NORMAL_FULL
  • Purchase Line Archive - INS_NORMAL_FULL
  • Validation Period - INS_NORMAL_FULL

Prestaging scripts for other Purchase and Transfer order tables had already been added in earlier versions of LS Insight.

Job Scheduler header xml file has been updated, and the new ACI, transfer and purchase order tables have been added to the appropriate Scheduler jobs.

Refer to the update guidelines on how to import the new Job Scheduler header file to add the new tables to subjobs and subjobs to Scheduler jobs.

Data Warehouse

Database

Tables

Three new fact tables were added to the data warehouse:

  • fTransferOrders
  • fTransferOrderReceipts
  • fTransferOrderShipments

SK_Vendor has been added to FactSalesPosted table to connect sales with the vendor dimension.

The Run GUID from ADF is now accessible in all staging tables.

Stored procedures

New procedures were added for the new fact tables:

  • factTransferOrders
  • factTransferOrderReceipts
  • factTransferOrderShipments

Stored procedures for all fact tables will no longer try to merge if the incremental load results in no rows of data.

FactSalesPosted stored procedure has been updated to add SK_Vendor to sales entries.

Azure Data Factory

Pipelines

Fact tables

Three new pipelines have been added for the new stored procedures:

  • PL-SP-factTransferOrders
  • PL-SP-factTransferOrderReceipts,
  • PL-SP-factTransferOrderShipments

Scheduled Run

The new pipelines have been added to the Scheduled Run.

The Telemetry post web action in the Scheduled Run pipeline can now handle SQL servers with instances.

Performance enhancements have been made in the pipelines: All staging tables and FactSalesPosted.

Reports

All Reports

Mobile-optimized views of all pages have been added in all reports. When a mobile-optimized view exists for a page, it automatically displays when the mobile device is held in portrait orientation. If users want to see the regular non-optimized view of the page as they would see it on their computer, they can tip the phone onto its side. Tooltips' look and feel in all reports were synchronized.

LS Insight Sales

Changes to the LS Insight Sales report.

  • Added Basket Value and Product Mix page in Sales report.

LS Insight Supply Chain

Changes to the LS Insight Supply Chain report

  • Added Transfer Orders report pages in Supply Chain report.
    • Shipping Agent Overview
    • Orders Inbound vs. Outbound
    • Quantity Inbound vs. Outbound
    • Lead Time Analysis
    • Lead Time Analysis Orders
    • Transfer Flow
    • Quantity Received Weekday Analysis
    • Quantity Shipped Weekday Analysis
  • Updated Order Status from showing status on order line to now showing status by order number.
  • Added new column, Location Type, showing if location is Store, Warehouse, Location, or Store & Location.

LS Insight Actionable Insights

Changes to the LS Insight Actionable Insights report

Bug fixes

In all staging pipelines in the activity UpdateLSInsightAudit, the parameter for MinTimestamp has been changed from Int32 to Int64. This was an issue in LS Insight version 2021.4.1 and earlier. This parameter is not used in version 2021.1 and newer.

When staging pipelines run multiple instances resulting in duplicate lines in the staging database, there was a reoccurring bug where the Merge statements for the DW tables would fail. Usually, this happened when the scheduled run was triggered before the initial load finished. This is not an issue anymore.

Bug when processing fPurchaseReceipt - when receipting without opening the original purchase order, a new document was created in LS Central, which was not anticipated in previous version.