¶¶Òõ

Skip to main content

¶¶ÒõReports

2025-03-27 | 3.10 ¶¶ÒõReports

This release is not dependent on another component update.

Version HistoryÌý

Refer to Change Ticket: CHANGE-11958 when speaking to a ¶¶ÒõTeam Member about these release notes.

Component

Current Version

New Version

Web App API

1.0.344-1

1.0.344-4

ImprovementsÌý

RPT-13663

Weekly Sales Report

Weekly Sales Report now only includes data for assigned sites.

2025-03-27 | 3.10 ¶¶ÒõReports

This release is not dependent on another component update.

Version HistoryÌý

Refer to Change Tickets: CHANGE-11886, CHANGE-11887, and CHANGE-11888 when speaking to a ¶¶ÒõTeam Member about these release notes.

Component

Current Version

New Version

Reporting ETL

1.0.831-4

1.0.833-1

Reporting PBI

1.3.115-4

1.3.116

Web App API

1.0.343-4

1.0.344-1

Web App UI

1.0.343-4

1.0.344-1

ImprovementsÌý

RPT-11422

AG-Grid Reports

Increased the number of rows in AG-Grid reports from 50k to 150k.

RPT-11826, RPT-12800

AG-Grid Format

Converted the following reports to the AG-Grid format:

  • Weekly Sales Report

  • Employee Audit Report

RPT-12149

Category Sales Report

The Employee Selector is now no longer available if more than one site is selected.

RPT-12239

Labor Performance Summary Report

Minimum Wage Adjustment (MWAJ) and Minimum Breaks Penalty (MBP) values are now excluded from the labor calculations in the Labor Performance Summary Report

RPT-12275

Product Mix Report

Improved the logic for the Product Mix Report so that the correct Named Calculation values are displayed.

RPT-12415

Distkey for Tables Logic

Made the following updates to the Distkey for Tables logic:

  • New column to allow the ability to changes a distkey

  • Updated historical data to populate data stored within Redshift

  • New column to temp_business_dates_table for the delete statement

RPT-12743

SDR

The SDR shows the Guest Count QTY value in the Qty column as expected.

RPT-13045, RPT-13505, RPT-13530, RPT-13578 RPT-13681

Technical Improvement

This release includes infrastructure improvements that do not affect the business functions of ¶¶ÒõCloud or supported services.

RPT-13060

Report ETL Job Alarm

New alarm for Report ETL jobs to alert if an order begins a flow into Mango/Redshift without a cashier name.

RPT-13168

Reporting API

New substatus field in the reporting API indicates the substatus of a deleted item.

RPT-13335

ETL Retry Mechanism

Added the following logic to the ETL Retry mechanism flow:

  • Set ETL_SQL_QUERY_TIMEOUT within job schedules to control the timeouts per job

  • Added controller with every scheduler to check if a retry is needed for a Timeout script

  • In cases where the query exceeds the defined timeout and controller enabled, the retry_on_failure will relaunch the script again

RPT-13376

Daily Sales Report

Disabled SSRS Version of the Daily Sales Report.

RPT-13402

Altametrics Configuration

New configuration to set a list of sites to prevent notifications for the Dlyposchecks flow of the AnyConnector API to send until the Altametrics subscription is disabled.

RPT-13443

Ideal Labor Report

Ideal Labor Report now only calculates as an average for the previous 5 dates for days where Actual Labor is greater than 0.

RPT-13468

Spectrum/Historical Recalculation Flow

The Spectrum/Historical Recalculation flow now sets up a new scheme if there is no data available to re-sync.

RPT-13537

Mango/Redshift Verification Job Notifications

Improved the notifications for the Mango/Redshift Verification Job.

RPT-13538

WebApp API Page Limits

WebApp API Page limits are now a constant values in API components.

  • API_DEFAULT_PAGE_SIZE

  • API_MAX_PAGE_SIZE

RPT-13539

SDR/WSR

System and User Deletions show under Deleted Items as expected for SDR and WSR.

RPT-13547

Redshift Tables Comparison Job

New query in the Redshift Tables Comparison Job to check the difference between calculated_net_sales and net_sales in the custom_calculations_json

RPT-13550

Keys from Crowdin

The default title is displayed when translations/EN values cannot be retrieved from Crowdin.

RPT-13551

Void Summary Report and Void Summary Detail Report

The Void Summary Report and Void Summary Detail Report do not show deleted orders as expected.

RPT-13552

Mango/Redshift Verification Jobs

Improved following Mango/Redshift verification jobs:

  • SDR Sales Breakdown Comparison:

    • Added one additional threading

    • Added debug logs that show time spend on each operation

  • Drawers Comparison:

    • Added debug logs to show cause of a drawer being tracked to re-sync

    • added checkpoint mechanism to avoid missing drawers from previous business dates

RPT-13558

Employee Sales Report and Void Summary Reports

Improved the Voided Items calculation logic for the Employee Sales Report and Void Summary Report.

RPT-13566

Deputy Sales Ref Verification Job

Updated Deputy Sales Ref Verification Job to only write missed orders to the result file while in Debug mode.

RPT-13568

BOH Load Jobs

Improved BOH Load jobs to prevent unnecessary data from loading.

RPT-13576

Category Sales Per Site Report

This update fixes a issue where the Category Sales Per Site Report did not fully load.

RPT-13587

BOH Tests

Optimized BOH tests and added documentation.

RPT-13606

Payroll Generation Check Job

Improved Payroll Generation Check Job to track worktimes from a previous business_date during a date check.