About This Release
Released - December 16, 2019
This version of LS Insight supports versions 8.4 - 13.05 of LS Central.
Note:
It is not possible to update LS Insight from version 2019.1 to version 2020.1. Version 2020.1 needs to be set up from scratch.
The following is a list of changes and key features in LS Insight 2020.1.
New or Enhanced Features
Setup
Onboarding
As this is the first release of LS Insight using Azure Data Factory version 2 there were several changes to the onboarding process.
These include:
- Deployment script renamed from CreateNewProjectFreeADFVersion1.ps1 to DeploymentScript.ps1
- Script performance improved. The script now takes 8 minutes to run instead of 40 minutes.
- Offset parameter removed from parameters.txt (not needed any more)
- Onboarding documentation moved to online help.
Data Warehouse
SQL Database
Database Schema
An audit table has been added to the Data warehouse database schema. This audit table holds information about the MAX RowID of all staging tables after the last pipeline run. The audit table is used for incremental load management.
Azure Data Factory
The Azure Data Factory version used in LS Insight has been updated from version 1 to version 2. This greatly improves the editing and debugging options for the Data Factory once it has been setup in Azure.
Pipelines
Staging Pipelines
The staging pipelines now use the column RowID (timestamp) for incremental load instead of BI timestamp. The timestamp field exists in all LS Central tables and the timestamp is updated when a row is added or updated. By using the this field we ensure that the pipelines only pick up added or changed data in most tables.
Reports
There are no changes to the Power BI report templates in this version.
Hotfixes Released for This Version
Hotfix 2020.1.1
Released January 9, 2020
RowID set as primary key on all staging tables in Data warehouse database in Azure.
Hotfix 2020.1.2
Released January 23, 2020
Primary key removed from staging tables in Data warehouse database in Azure.
Hotfix 2020.3.1
Released April 8, 2020
When we made the move from Azure Data Factory to Azure Data Factory v2 we neglected to move one of the Data warehouse pipelines to v2.
The missing pipline is called "fItemCostAdjustment" and is a SQL select statement to fill the table DW.fItemCostAdjustment using FULL LOAD as this captures the cost adjustments in the Value Entry staging table.
You can update your current LS Insight setup with this hotfix to fix the issue.