In this article
Disabling fact tables pipelines
From version 2024.2 of Analytics for LS Central we are backwards compatible to version 19.0 of LS Central. This means that if you set up Analytics and use an LS Central version 19.0 or later as a source all pipelines should run. There might be columns or tables that are not populated, but nothing should fail.
If you use LS Central versions that are older than version 19.0, you might experience failing dimension and fact table pipelines. This is especially true for functionality like Hospitality and Bookings that has been added to LS Central in recent years. When you run the Initial load or Scheduled run, you can see in the Azure data factory monitor tab which dimension and fact tables are failing against your LS Central version.
If you still want to run Analytics for an older version of LS Central and only want to run the pipelines for the Sales and Inventory Analytics, you can do that with a few modifications of the Analytics pipelines and data warehouse.
Methods to disable load of dimension and fact tables is described below.
Disabling dimensions
Because the dimension tables are all loaded by a single pipeline, they must be "disabled" in the data warehouse. The easiest way to do this is to rename the stored procedure that loads the dimension so the pipeline does not pick it up. This will then just leave this dimensions empty.
To rename a stored procedure you need to:
- Open SQL Server Management Studio or Azure data studio, and connect to the Analytics data warehouse database.
- Navigate to the stored procedure folder Programmability - Stored procedures, and alter the name of the dimMerged procedures, you want to leave out to XdimMerged. This will cause the procedure to be left out when the Load dimension pipeline runs, but the procedure is still available should you want to include it again at some point.
Disabling fact tables pipelines
The loading of the fact tables happens during the run of the Scheduled run pipeline, so the easiest way to disable the load of a fact table is to:
- Open the Scheduled run pipeline in the Analytics Azure Data Factory in Azure portal.
- Select the Execute pipeline, right-click and select Deactivate. This deactivates the running of this pipeline, so the fact table associated with it is not be loaded with data and it will not matter if the staging tables are missing.
Note: Running an update on an Analytics environment that has been changed in this way might fail if there are updates to the dimension stored procedures, and the Scheduled run pipeline will be overwritten if there are any changes, so you must repeat the disabling of the fact tables you do not want to run.