LS Insight (2021.3) Release Notes

About This Release

Released - August 30, 2021

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 the last released version we added support for affixes to extension tables. We have now tested the replication against version 17.5 and later on SaaS and LS Insight is available for those versions but not older versions of LS Central SaaS.

A few issues, reported by customers and partners, have been fixed.

Note: Updates for version 2021.2 are provided in a special update package. If you have already set up version 2021.2, you can update to 2021.3 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 that the updates do not affect these customizations before you start. If you are running LS Insight against LS Central in SaaS, you will not be able to update LS Insight but need to set up a new instance of LS Insight.

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

New or Enhanced Features

Setup

Onboarding

Script that creates pre-staging tables for LS Insight for LS Central Saas now creates tables that reflect the LS Central table structure in version 17.5 and later.

This means that all LS Central specific tables now have the LSC prefix and all extension table columns have also been prefixed with LSC. For you to be able to replicate between LS Central SaaS 17.5 and later, you must set up this latest version of LS Insight so you have the correctly prefixed pre-staging tables and columns.

Data Warehouse

Database

Tables

Description field column length in dItemVariant table was changed from nvarchar(50) to nvarchar(100).

Stored procedures

Fixed the "finishing date time" registration in LSInsight$Audit table. To fix this we changed the Batchdate from GETUTCDATE() to GETDATE() in the UpdateLSInsightAudit stored procedure.

Fixed that incorrect fiscal year start month was added to company table by adding the AND clause, "AND sACP.[New Fiscal Year] = 1", to predimMergedCompany stored procedure.

Fixed issue that not all lines were moved from Item ledger entry staging table to fInventory table. This required and update in the factInventory stored procedure and in the Inventory Power BI template. The script to update the stored procedure is a part of the update package.

Pipelines

PopulateQueryBase fix

To prevent duplicate rows in QUERYBASE, the PopulateQueryBase > Tablelists subquery was modified. CountRows was removed from group by and selected as max(CountRows).

Staging query fix

WITH (NOLOCK) added to all staging select queries. This means that the staging queries no longer lock the LS Central tables while getting data.

Reports

LS Insight Sales

No changes.

LS Insight Inventory

Because of the change in the factInventory stored procedure, we needed to make a change in the Inventory Power BI template. If you have an existing power BI report that you have customized for inventory but you want to make use of this fix, you can run the Modify_factInventory.sql script from the update package on the LS Insight database, and then manually update the dax calculations in your LS Insight Inventory report by following the instructions below.

Manual calculation update

1. Open LS Insight Inventory.pbix report in Power BI desktop.
2. Right-click below the fields list in the right-side pane, and select View hidden.

   

3. In the fields search box, type OYInventory and edit the top 3 calculations with the formulas below:

   

   OYInventory = 
   /*
   Showing the end of year inventory on hand
   */
   	CALCULATE(
   		[YearInventoryMovement]
   		,Filter(
   				ALL(EOYinventory[PostedDate]),
   				EOYinventory[PostedDate] < MAX('Date'[Date])
   		)
   	)

   OYInventoryCost = 
   /*
   Showing the end of year inventory cost 
   */
   	CALCULATE(
   		[YearInventoryCost]
   		,Filter(
   			ALL(EOYinventory[PostedDate]),
   			EOYinventory[PostedDate] < MAX('Date'[Date])
   		)
   	)

   OYInventoryValue = 
   /*
   Showing the end of year inventory value 
   */
   	CALCULATE(
   		[YearInventoryValue]
   		,Filter(
   			ALL(EOYinventory[PostedDate]),
   			EOYinventory[PostedDate] < MAX('Date'[Date])
   		)
   	)

4. Publish the report to Power BI service.

LS Insight Hotels

No changes.