Reporting v.80

Document status: RELEASED 

Date: 12 Jun 2023  

Requirements:

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

IMPORTANT! This is the last version of Reporting that supports SQL 2014. 

ReportingDataIntegration package extensions

(RTC-30326, RTC-25365)

ReportingDataIntegration LIP package v. 2.1.0.0 has been released together with Reporting v. 80. 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 suppliers from Item Management
   The following fields have been added: supplier number and name, subsupplier number, supplier item and model number, producer name.
2. Import of store permissions from User Management
   User-store permissions import from User Management has been implemented. These permissions are required to o support Row Level Security in Power BI.
   The permissions must be defined in User Management. The name of the permission is Reporting / Access store data, and the role with this particular permission must be linked to the user in order to grant them an access to the reports.

DimCustomer view extended with Organization Number

(RTC-32071)

The import of customer data from Retail database has been extended with Organization Number. The view pub.vDimCustomer has also been extended with this information.

Wet Stock - improvements in import of reading and delivery transactions 

(RTC-31689)

The handling of fuel delivery and reading transactions has been improved. This is to avoid loss of data under heavy load.

General improvements

(RTC-30768, RTC-31358, RTC-31561)

1. SQL 2022
   Refactored code in SSIS package which handles processing. It was done to make sure it works on both SQL 2017 and SQL 2022.

2. OLAP processing
   The processing of Retail Store dimension has been extended with GLN (Global Location Number)

3. Member activities
   To make sure expired and non-expired activities are up to date in OLAP, the member activity dimension is processed every night.