About This Release
Released - November 4, 2020
This version of LS Insight supports versions 8.4 and later of LS Central on-premises and lates versions of LS Central in cloud (Saas). Setup of LS Insight for LS Central in cloud (Saas) need some additional setup from the standard LS Insight onboarding process which is explained in detail in the new onboarding documentation.
In this version we have added support for setting up the LS Insight database on an already existing SQL server in Azure or on-prem.
We have also in this version added support for setting up LS Insight with LS Central in cloud (SaaS), version 17.0 and later.
Note:
Since there are no changes to the standard LS Insight functionality, this version should only be used for new installations of LS Insight, or if you want to add LS Insight for Hotels to your current LS Insight setup.
The following is a list of changes and key features in LS Insight (2020.5).
New or Enhanced Features
Setup
Onboarding
We have made some changes to the onboarding Deployment script:
- Script no longer uses the parameter.txt file to read the parameters.
- Script prompts for all parameters, validates them right away and allows user to re-enter parameter if incorrect.
- Script displays a progress bar for the parameter collection and deployment of LS Insight.
- Script now creates LS Central pre-staging table in the LS Insight database if needed.
Because of these changes and the added support for LS Central source in cloud and LS Insight setup on-prem the onboarding process documentation has been rewritten to reflect the changes in the onboarding script.
The onboarding process now has three different setup wizards depending on the LS Central and LS Insight environments.
LS Central On-premises and Analytics in Azure
LS Central On-premises and Analytics Database On-premises
LS Central SaaS and Analytics in Azure
Product Package
The Scheduler Job Header.xml file has been added to the LS Insight product package.
This file is only used when running the onboarding process for LS Central in cloud and LS Insight in Azure.
It holds the replication job and subjob setup for replicating from the LS Central cloud server to pre-staging tables in Azure.
Data warehouse
Database
All description columns in staging tables have been updated to nvarchar(100), some were still nvarchar(50)
Pipelines
Fixed hardcoding of CRONUS company in two places in arm_template file.
Fixed the source for SP [dbo].[UpdateAdjustedCost]
- [dbo].[UpdateAdjustedCost] was using [Stg].[ItemCostAdjustment] as a Source. But this has now been changed to [DW].[fItemCostAdjustment]
PL-fItemCostAdjustment has been added to scheduled run.
Fixed population of PL-stgProductGroup to use 'Product Retail Group' as source instead of 'Product Group' that is now obsolete.
Fixed duplicate entries in Stg.TransSalesEntry tables when cost changes on Transaction entry.
Fixed duplicate entries caused by "adjustment entries" in the ItemLedgerEntry table. Adjustment entries are now excluded.
LS Central for Hotels
A new pipeline was added to the Azure Data Factory to run the Stored procedure, PL-SP-fHotelStatistic.
Reports
LS Insight Sales
Changes to the LS Insight Sales report
- Maintain Layer Order has been set to TRUE on all informational vizuals.
- Gradient effect was added on Net Sales based on margin% on the Net Sales landing page of the Sales report.
- Rectangular Lasso Select was enabled in report.
- Page information (i) was reviewed and updated.
- Mobile view was created for all report pages.
- Filter page has been removed and report filters have been added to filter pane instead.
LS Insight Inventory
Changes to the LS Insight Inventory report
- Maintain Layer Order has been set to TRUE on all informational vizuals.
- Rectangular Lasso Select was enabled in report.
- Page information (i) was reviewed and updated.
- Mobile view was created for all report pages.
- Filter page has been removed and report filters have been added to filter pane instead.
LS Insight Hotels
No changes.