Inferred promotions with eCoupons (RTC-30286)

Changed reading offer number from ExternalReference to OfferNo in POSLog. This is to avoid creating inferred offers with eCoupon name.

NB! this change requires latest version of POSLog.

New view with list of reports (RTC-36630)

A new view with list of reports (dashboards) was implemented under Dashboards menu entry. The list consist of three predefined dashboards, including previously implemented sales dashboard. The user can navigate to specific reports, as well as see recently used reports and flag the favourite ones with a star.

Image Added

Each dashboard can be also accessed with a direct link. The direct links support cashier login functionality.

Example: to access Sales dashboard with a cashier login, navigate here: https://reportingmanagement.chainweb.lindbaktest.com/dashboards/1?loginTenantId=????????????&loginStoreNumber=???

Reporting.Export.FlightSaleStatistics - adjustments in formatting (RTC-41456)

The following adjustments in file formatting were implemented:

• quotation marks removed from string columns,
• scheduled date time column extended with seconds and milliseconds,
• scheduled date time column values for fake flights set to 9999-12-31 22:59:59.999.

Budget menu with view and export/import functionality (RTC-36630)

A new menu with budget rows and import/export functionality.

The grid is accessible from the main menu:

Image Added

The following common level permission can be used to limit user's access to the functionality:

Image Added

The grid displays rows directly from the data warehouse. The following data is presented:

• store number,
• store name,
• budget date,
• budget measures:
  • amount,
  • net amount,
  • gross margin,
  • average amount per receipt.

In the bottom right corner, there are two buttons that allow the user to export the data to Excel file and import new rows:

Image Added

The exported file can be used as a template for import; it is possible to attach more than a single file.
The asynchronous import starts soon after selecting the file(s) and submitting.

Reporting dashboards - custom filters (RTC-40682)

A new feature in edit mode was added to make the dashboards in Reporting module even more customizable. It is now possible to configure a custom set of filters per each page.

The filter configuration is simple and intuitive. In the edit mode, a new filter can be added by clicking on + button:

Image Added

The next step is to select the filter dimension value and the filter is ready to use. All tiles on the dashboard are affected by a custom filter. Removing a filter is also simple and intuitive and it can be done by clicking on Delete button.

All changes are effective only after saving them in the edit mode.

The filter is ignored if no values are selected.

Export job - prevent exceptions during the initial run (RTC-41028)

Update to prevent exceptions during the initial run of job for new blob types.

Adjustment in exported flight blobs (RTC-41151)

The following changes to the flight blobs were implemented:

• Reporting.Export.FlightSaleStatistics:
  • set encoding of the file to UTF-8 BOM,
  • add prefix EG_ to the filename,
  • remove header,
  • column Quantity: round to the nearest whole number (no decimals),
  • column Amount: keep 4 decimals only,
  • column ScheduledDateTimeUtc: value for fake and dummy flights should be: 9999-12-31 22:59
• Reporting.Export.MemberFlightSaleStatistics:
  • set encoding to UTF-8 BOM.

Reporting.Export.MemberFlightSalesStatistics - adjustments (RTC-41024)

The following adjustments were implemented:

• new dummy columns (see docs: Reporting.Export.MemberFlightSaleStatistics) ,
• number of decimals limited to 2,
• added double quotes on string columns.

Initialize and finalize the release (RTC-40866)

The release pipeline was extended with Initialize and Finalize stages, which help to make the release process more stable.

Data type change for LoyaltyNo (RTC-40866)

Data type for LoyaltyNo field (loyalty number) in FactSales table was extended from 20 to up to 100 characters (same limit as on-premise).

Reporting.Export.FlightSaleStatistics - changes in TravelType and UniqueFlightId columns (RTC-40676)

The logic for TravelType and UniqueFlightId columns was changed:

• TravelType:
  
  • uses values returned by WebDok (DD/DI/ID/II/ARR/DEP),
  • if WebDok values are not available:
    • all "fake" flights with name .DEP get TravelType = DEP,
    • all "fake" flights with name .ARR get TravelType = ARR,
    • all "fake" flights with name .PAX get TravelType  = EXT,
    • all manually added departure flights get TravelType = DEP,
    • all manually added arrival flights get TravelType = ARR,
• UniqueFlightId
  • is blank (not -1) for all "fake" flights (flights with name .DEP, .ARR and .PAX)

Sales dashboard - display average KPIs with two decimals (RTC-40721)

They Key numbers section on the sales dashboard was adjusted: the Average purchase and Items per customers KPIs are displayed with two decimals.

Image Added

Export job: configure row limit per export type (RTC-40476)

There is a new parameter to set for the Export job: rowLimitFile - for maximum number of rows in a file. If total number of rows exceeds parameter, the job will split the output in multiple files adding _1 to the file name.

The parameter can be configured per file type in LIP. Example:

Image Added

Data visualizations (RTC-39753)

Alongside creating tiles with data presented in a standard grid format, user now have possibility to create custom tiles with graphs. The supported types are:

• bar chart,
• line chart,
• area chart,
• pie chart,
• donut chart.

Image Added

A custom report page was also created to present all available types that can be accessed from the menu.

Resizeable tiles (RTC-40304)

It is possible to adjust the size of tiles on the dashboard now. The action can be performed in Edit mode by dragging the border of the tile:

Image Added

The custom size can be also set precisely (by giving number of rows and columns the tile) when editing existing tiles.