Reporting v. 83
Document status: RELEASED
Date:
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).
Rebuild cube: NO
End of day consolidation
Solution to export end of day data to a new blob type: Reporting.Export.EndOfBusinessDayStatistics.
Solution consists of two parts:
- when EOBD receipts are updated from cash register, total number of EOBD candidates is saved in a new column WorkstationsCount in table dbo.FactEndOfBusinessday.
- new on-prem LIP-job EndOfBusinessDayStatisticsExport in ReportingDataIntegration package will check new entries in FactEndOfBusinessDay table and see if the number of EOBD receipts for given store and date matches the number in WorkstationsCount (the job runs on schedule, default: every minute). If it does, the job will export EOBD data and publish it to the configured blob storage.
For further technical information about the job, see ReportingDataIntegration LIP package documentation.
Further information about the content in EndOfBusinessDayStatisticsExport can be found swagger (ReportingService): https://docs.egretail.cloud/.