About This Release
Released - April 8, 2020
This version of LS Insight supports versions 8.4 and later of LS Central on-premises. Support for LS Central version 15.0 and later in cloud and hybrid cloud will be added in future versions of LS Insight.
Note:
This versions does not update older versions of LS Insight and should be set up from scratch. If you are running older versions of LS Insight you can still connect the new Sales report to your LS Insight database to get access the new features.
All pipelines have been updated to support both older versions of LS Central (14.2 and older) and the newer versions (15.0 and later).
Member list page in LS Insight Sales report can now display a list of lost members.
New pipelines and report template for LS Central for Hotels (15.3) has been added in this version. LS Central Hotels has not been officially released, but we wanted to prepare and make this available for testing.
The following is a list of changes and key features in LS Insight (2020.3).
New or Enhanced Features
Setup
Onboarding
We have made some modifications to the onboarding script for this version. Now the script prompts for the version of LS Central you are running and then runs the setup according to that.
If you have the latest LS C version 15.3 and are running the LS Central for Hotels extension, you can set up LS Insight for Hotels as well. This is a new feature since we have never before had an extension as a part of the LS Insight product.
Data warehouse
Database
The LS Insight database schema has been altered to include tables for the Hotels extension. These tables will exist in all LS Insight Azure data warehouse databases. But they will not be populated unless you are running the LS Central for Hotels extensions on top of LS Central and have set up the LS Insight Hotels extension.
The following tables have been added:
- Stg.Hotel Res_ Statistics
- Stg.Hotel Reservations
- Stg.Hotel Rooms
- Stg.HotelRes_Entry
- Stg.Detailed Revenue Entry
- DW.dHotelReservations
- DW.dHotelRooms
- DW.fHotelDetailedRevenue
The following stored procedures have been added:
- fHotelDetailedRevenueSP
Pipelines
LS Central
The LS Insight product package now contains a different set of staging pipeline setup for LS Central version 14.2 and for the newer AL LS Central versions from 15.0 and up. The newer pipelines account for the new GUIDs that have been added to all table names and for Business Central tables that are extended by LS Central tables.
LS Central for Hotels
New pipelines have been added to move the Hotels data from LS Central to the Azure data warehouse staging tables.
- PL-stgDetailed Revenue Entry
- PL-stgHotel Res_ Entry
- PL-stgHotel Res_ Statistic
- PL-stgHotel Reservation
- PL-stgHotel Rooms
Reports
LS Insight Sales
You can now see and filter to lost members on the Member List page in the LS Insight Sales report:
LS Insight Hotels
The Hotels report shows KPIs and statistics for the Hotels extension:
Hotfixes Released for This Version
Hotfix 2020.3.1
Released April 8, 2020
This fix also applies to versions 2020.1 and 2020.2.
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.