Reporting.Export.MemberFlightSaleStatistics - exclude items with specific special groups from the report (RTC-44036)

All items linked to special group 01 are excluded from the report. 
The data in the report is also ordered by transaction date, and then transaction ID (ascending).

Fix: 'Data warehouse is paused' message in Budget grid (RTC-44101)

Data warehouse is paused message was incorrectly shown in the budget grid and prevent from viewing and updating budget rows. The issue was fixed.

Import balance data to Cloud data warehouse (RTC-42654, RTC-42655)

The data from balance receipts is available in the data warehouse now. The data is stored in a new table and will be used for settlement purposes.

New control transaction with price check from POS (RTC-43987)

Support for new control transaction type: PriceCheck has been implemented. Such transactions, performed by cashiers, are going to be stored in the data warehouse together with other control transactions. The number of price checks performed by the cashier is also going to be stored.

Fix: assign receipt count flag to the first not deleted line  (RTC-42955)

The logic for counting receipts in the data warehouse has been improved. From now on, the receipt count measure will return correct numbers for normal sales.

Import log view (RTC-41241)

A new view (Import log) with list of imported blobs was implemented Dashboards menu entry. The list consist of imported excel files in Management app, as well as imported blobs via FileService (ref.: Reporting Service - file import documentation).

The grid contains a lot of details about imported blobs - including import status, number of rows (imported and failed), and also has a drilldown option - so that the user can view the details about each imported or failed raw and see the raw content.

New Budget API (RTC-42935)

New endpoint has been developed in Reporting Service: Budget with a new method for fetching budget related statistics. The method is documented in swagger: Reporting Service - Budget API. 

Sales API - fetch sales statistics from Cloud (RTC-42936)

The salesStatistics method in Sales API supports a Cloud data source now. If AasConnecitonString is configured (in Tenant Admin), the API is going to fetch the data from Cloud (instead from an on-premise server).

The method was also extended with new optional parameters: hour, cashregisterno and cashierno. Full documentation: Reporting Service - Sales API - salesStatistics method .

New KPI API (RTC-42379)

New endpoint has been developed in Reporting Service: KPI - with genericRequest method for requesting various data from Analysis Services. Documentation: Reporting Service - KPI API 

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.

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:

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

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:

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:

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.

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:

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.

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:

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