Document status: RELEASED
Date: 79.0 / 79.1 / 79.2
Requirements:
Component | Version |
|---|---|
POS Master* | 3.0.0.90 |
POS JournalService | 2.82.xxx.x / 3.82.xxx.x |
POSLog XML | 82 |
*or a separate script (see upgrade guide for details).
New report for Store Settlement
A new report based on 0016: Store settlement has been implemented. This report has option to multi select stores. The report allows to follow up the store settlement: on the first page, the settlement for all selected workstations is shown. The settlement per each workstation is displayed on following pages. Report is divided in 15 subreports.
The report also shows global localization number of the store (GLN). GLN is imported from both POS Master and Store Service and updated in Reporting data warehouse.
(79.2) The processing of Retail Store dimension has been extended with GLN (Global Location Number).
Web user tracking
(RTC-28181, RTC-28182, RTC-30015)
To provide the data for segmentation on web user activities, the import of web user activities from Marketing Service has been implemented. The imported blob type is: Marketing.Export.TrackingFact.
Activities with no member will be updated with correct member with N-job providing activity with correct member is received (a member lookup from user GUID was implemented to provide more information about member web activities for segmentation purposes).
Expose SegmentationSubscription flag in vMember and vDimMember views
An information about SegmentationSubscription (also known as Data Analysis flag) has been added to dimension views: pub.vMember and pub.vDimMember.
Support for SQL 2022 - fixes
(RTC-30529, RTC-30646, RTC-29676, RTC-30768)
- Fixes in packages that fetch member variables data from Chain Web (tags) or Bridge (variables). (79.2) Reset sync status for tags script attached.
- Improvements in the package that fetches item lists from Chain Classic.
The SQL Server native client is deprecated for SQL 2022. Therefore, the provider for all SQL connections has been changes in all config files.
- (79.1) Refactored code in SSIS package which handles processing.
Gift card sales procedure - improvements
Improvements in the procedure for fetching member activities and sales data for member dashboard.
Data warehouse maintenance
The procedure for deleting fact data for specific store and date(s) has been updated with new tables.