LS Insight (2023.1) Release Notes

About This Release

Released - January 26, 2023

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 improved our report template for LS Central for Hotels. Several report pages have been added to the template and we now support slicing occupancy and revenue by customer, market segment, and reservation channel. We have also added information about guest nationality and adult/child classification.

Note: Updates for version 2022.3 are provided in a special update package. If you have already set up version 2022.3, you can update to 2023.1 without creating a new instance of LS Insight. See update guidelines for more information. If you are not using LS Central for Hotels tyou can skip this update.

Note: This update only includes changes for Hotels extension and Hotel reports, so if you are not running LS Central for Hotels you do not need up update. The next version will work to update 2022.3 and 2023.1.

Note: 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 2023.1.

New or Enhanced Features

Setup

Product package

Prestaging scripts

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

  • Customer3.sql
  • Transaction Header2.sql
  • Room Blocking Entry.sql
  • Room Type Block.sql
  • Hotel Res_ Guestlist.sql
  • Hotel Guest Group.sql

The following script was removed:

  • Hotel Res_ Statistic.sql

Scheduler job

Hotel Scheduler job file has been updated. Now the Scheduler job includes normal subjobs for the following tables:

  • LSCHT Room Blocking Entry
  • LSCHT Room Type Block
  • LSCHT Hotel Rooms
  • LSCHT Hotel Room Availability
  • LSCHT Hotel Reservation
  • LSCHT Hotel Res_ Entry
  • LSCHT Detailed Revenue Entry
  • LSCHT Hotel Res_ Guestlist
  • LSCHT Hotel Guest Group

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.

Report templates

LS Insight Hotels report template has been updated. See below for more information.

Documentation

A few updates have been made to the online help:

  • Architecture image and text have been updated.
  • New extension guidelines for version 2022.3 and later.
    • Because of changes in the source table setup we needed to create new extension documentation. A link to the new extension guidelines has now been added to online help extension page.
  • Section on Power BI service gateway has been added to LS Central on-premises and LS Insight on-premises onboarding process.

Data Warehouse

Database

Tables

There are four new fact tables for the Hotels report.

  • fHotelDetailedRevenue
  • fHotelGuestList
  • fHotelReservationEntry
  • fHotelRoomAvailability
  • fHotelRoomBlockedEntry

One fact table has been removed.

Stored procedures

Five new stored procedures have been created for new fact tables used in Hotels report. One stored procedure for a dimension table has also been updated. All updates are related to the Hotels report.

  • factHotelDetailedRevenue
  • factHotelGuestList
  • factHotelReservationEntry
  • factHotelRoomBlockedEntry
  • factHotelsRoomAvailability

For slicing in Power BI, the stored procedure below adds rows for each room type without a room connection to the dHotelRooms table.

  • dimextMergedHotelRooms

Azure Data Factory

Pipelines

New pipelines have been added for the new fact tables used in the Hotel reports. They are only triggered if the LS Central source is LS Central for Hotels.

  • PL-SP-factHotelGuestList
  • PL-SP-factHotelReservationEntry
  • PL-SP-factHotelRoomBlockedEntry
  • PL-SP-factHotelRoomsAvailability

One pipeline has been removed since the factTable it populated has been removed from the data warehouse.

Reports

LS Insight Hotels

Several updates have been made to the LS Insight Hotels report and it now contains 11 report pages:

  • Hotel Overview
  • Occupancy
  • Reservations
  • Reservations (Date Comparison)
  • Arrivals
  • Guests
  • Revenues
  • Revenue Analysis
  • Occupancy (Last 28 days)
  • Occupancy (Next 28 days)
  • Night Statistics

Here below you see two of the new pages, Occupancy and Guests.

In the Occupancy report you can see room availability down to days. You can filter the data by room types, market segment, reservations channel, and customer.

In the Guests report you can see the number of guests and average revenues. To be able to see, for example, if revenues increase when the number of guests increases, guest nationality, and reservation channel. You can filter the data by room type, market segment, countries, reservation channel, and customer.

If you would like to review the rest of the report, refer to the Hotels report page where you can navigate all report pages with sample data.

Bug fixes

No bug fixes are included in this release.