Reporting v.81

Document status: RELEASED

Date: 18 Jan 2024  

Requirements:

*or a separate script (see upgrade guide for details).

ReportingDataIntegration package extensions

(RTC-37544, RTC-36615)

ReportingDataIntegration LIP package v. 2.2.0.1 has been released together with Reporting v. 81. The new version of package requires LIP >= 3.0.23.0.
The following changes have been introduced with the new version of the package:

1. Import of item category attributes from Item Management
   The following fields have been added to the staging tables: item type, item category, report category, classification, category manager, product series, exclude from gross profit report, model name, special group name.
   NB! This extension of the integration package is only used by Cloud integration. The on-premise DimArticle table wasn't extended.
2. Import new store attributes from Store Management
   DimRetailStore table has been extended to include external store number (POS), opening and closing hours. 

General improvements

(RTC-37715, RTC-32891, RTC-37736, RTC-33575, RTC-36654, RTC-32921)

1. SQL 2022
   → Updated script task in selected packages (BonusRulesConfig, FactStockRealtimeUpdate, OlapProcessing, UpdateArticles). This will prevent the packages from failing in upgraded SQL environments.
   → Update of library used by ReportingService method (dataSourceName).

2. POSLog processing
   → Improved POSLog extractor to ensure receipts containing changes in price are updated in data warehouse and not rejected.
   → Empty picking store lines are converted to NULLs.

3. ReportingDataIntegration package
   → Import and merger jobs do not fail anymore after receiving files uploaded by FileService (the issue was caused by the upgrade of LIP libraries)

Audit for Cloud DW data

(RTC-32695)

New package for comparing sales from Cloud and on-prem. Package is not part of Rt- or N-job and must be installed as a separate job