Document status: RELEASED
Date:
Requirements:
Component | Version |
|---|---|
POS Reporting DW | 2.4.0.60 |
POS Reporting Staging | 2.4.0.60 |
POS Master | 3.0.0.24 (or higher) |
POS JournalService | 3.75.160.0 (or higher) |
POSLog XML | 75 |
Delayed processing of cube
(TFS 175734)
It is now possible to delay processing of data in cube. Processing will only trigger in RT-job if data is older than x number of seconds. This is done to improve overall performance of Reporting server by reducing processing resources.
Config: New parameter in LindbakPOSReportingConfig.dtsConfig; varOlapProcessingLatency. This is number of seconds before triggering processing. Default value is 0 (disabled).
Example:
varOlapProcessingLatency = 300 (5 minutes)
RT-job 1 updates data in DW database, adds a processing request which can be seen in view vOlapProcessingLog. Processing request is not handled by this run of the RT-job.
The next RT-job where processing request from job1 is less than 300 seconds old, will add new requests but not trigger processing.
The next Rt-job where processing request from job1 is more than 300 seconds old, will trigger processing. All unprocessed requests will be executed.
Postal code for delivery and external customer order number
(TFS: 176920)
When updating customer order details we now read ZipCode from delivery element in POSLog and ExternalId from CustomerOrder element.
Information is updated in two new columns in DimOrder, ExternalOrderNumber and ZipCode.
View pub.vOrder is also extended with these two new columns.
View for item list
(TFS: 177545)
New view created to show articles in item lists.
New view: pub.vItemListArticles
Columns:
StoreNum
ItemListKey
ItemListName
ArticleName
EAN
Improvements
Modules | Description |
|---|---|
Customer order | Refactor orders in Reporting (TFS: 173252) In order to support customer order statistics we have refactored the way customer orders are handled in Reporting. Old way of handling customer orders are maintained in existing views pub.vOrder, pub.vOrderLine and pub.vOrderStatusHistory. NB! When upgrading manual steps must be done to migrate existing customer orders. See upgrade documentation for further details. |
Dimension data | Operators from master (TFS: 175511) We have improved the package that fetches operators from master to Reporting. Improvement makes sure we don't get duplicate operators in DimOperator. |
General | Updating new workstations (TFS: 175732) Improvement in RT-job when processing new workstations from master. This change is done to enhance performance of the RT-job. Exclude historical sales when processing cube (TFS: 175737) This only applies to customers who is using enterprise version of SQL. It is now possible to exclude creation of monthly partitions before set date. New parameter in LindbakPOSReportingConfig.dtsConfig, varOlapStartDate. When running partitions job, it will not create monthly partitions before this date. Note: It is important to set this date before running partitions job. Reading compressed POSLogs from queue (TFS: 176281) An issue related to reading compressed POSLogs is corrected. Reading compressed POSLogs are no longer dependent on dll's from previous versions of Reporting. RT-job performance (TFS: 176772) To increase performance of RT-job we now process dimensions in parallel. Cleanup log table (TFS: 176883) Added cleanup of rows older than 14 days in OlapProcessingLog table. |
Performance | Processing VAT Codes (TFS: 175731) The package which fetches VAT codes from master has been optimized to improve performance related to OLAP processing. |
Settlement | Improved query when exporting settlement to RIGAL (TFS: 174050) New index added to table FactBalanceTransaction to prevent timeout when exporting store settlement data to RIGAL. |