OLAP | Why upgrade and what's new

The following information is valid for the users who have received an email confirmation of being upgraded to the OLAP architecture. For more information, please contact your Technical Account Manager or Brightpearl Support.

What is OLAP and what are its benefits?

OLAP (Online Analytical Processing) is an architecture that allows users to efficiently retrieve information from multiple database systems at the same time. It does all the heavy lifting in the background so that the reports are faster, more reliable and scalable. The most significant benefits include speedy data analysis, flexible reporting, supporting business-focused multidimensional data and calculations.

Why Brightpearl upgrades to OLAP Reporting

Performance

  • OLAP reports are faster to load, sort, filter and export.
  • Transaction throughput is upgraded.
  • Higher capacity and unlimited exports are supported.
  • Reporting scalability is enabled both on report and account level.

Architecture

  • Dedicated to reporting requirements to enable scalability and performance.
  • Adding new metrics and calculations is more efficient and quicker.

Features

  • Additional filters, configurable columns, sorting options, search and multi-select filters (please see specifics below).
  • UI enhancements (please see specifics below).
  • Blockers to future feature work (new reports, filters, customisation, formats) are eliminated.

What’s new across all OLAP reports

The first phase of OLAP upgrade includes the sales list (recent sales), credits list (all credits), general ledger and low inventory report.

  1. Row actions have been removed, offering more space and consistency among the reports:Screenshot_2020-08-21_at_12.45.40.png
  2. “Clear filters” and “Filter” buttons are available at the top of the filtering section too:
    Screenshot_2020-08-21_at_12.48.03.png
  3. Additional options to select rows for export and the export task runs in the background:
    Screenshot_2020-08-21_at_12.49.49.png
  4. Confirmation messages appear under the filtering section for all batch actions:
    Screenshot_2020-08-21_at_12.50.37.png

What’s new in Recent Sales and All Credits

  1. Both sales orders and sales credits can be viewed:
    Screenshot_2020-08-21_at_12.54.26.png
  2. “Tax status” added to the filters:
    Screenshot_2020-08-21_at_12.55.23.png
  3. “Created”, “Tax date”, “Delivery” and “Payment due” date filters are split to be concurrently used:
    Screenshot_2020-08-21_at_14.13.08.png
  4. Headers and rows filters are split to be concurrently used:
    Screenshot_2020-08-21_at_13.42.54.png
  5. “Order reference”, “Order id” and “Invoice reference” are split to be concurrently used:
    Screenshot_2020-08-21_at_13.41.49.pngScreenshot_2020-08-21_at_13.44.26.png
  6. Filters are grouped in themes:
    Screenshot_2020-08-21_at_13.45.30.png
  7. Filtering options with multi-select values:
    1. Assigned to
    2. Country
    3. Created by
    4. Lead source
    5. Order type
    6. Warehouse
      Screenshot_2020-08-21_at_13.47.23.png
  8. Filtering options with search function:
    1. Channel
    2. Order status
    3. Country
    4. Created by
    5. Assigned to
      Screenshot_2020-08-21_at_13.49.52.png
  9. All columns, including the configurable columns, are sortable:
    Screenshot_2020-08-21_at_13.50.55.png

What’s new in General Ledger

  1. Filters are grouped in themes:
    Screenshot_2020-08-21_at_13.59.01.png
  2. “Created date” and “Tax date”, filters are split to be concurrently used:
    Screenshot_2020-08-21_at_13.59.32.png
  3. Filtering options with multi-select values:
    1. Created by
    2. Currency
    3. Lead source
    4. Nominal code
    5. Nominal class
      Screenshot_2020-08-21_at_14.00.17.png
  4. Filtering options with search function:
    1. Channel
    2. Created by
    3. Nominal code
    4. Nominal class
    5. Tax code/class
      Screenshot_2020-08-21_at_14.01.10.png
  5. Configurable columns are available:
    Screenshot_2020-08-21_at_14.01.52.png

What’s new in Low Inventory

  1. Instead of having the option to choose one warehouse at a time, all warehouses option is available:
    Screenshot_2020-08-21_at_14.02.36.png
  2. Filtering options with multi-select values:
    1. Brand
    2. Category
      Screenshot_2020-08-21_at_14.03.24.png
  3. Filtering options with search function:
    1. Brand
    2. Category
    3. Supplier
      Screenshot_2020-08-21_at_14.04.29.png
  4. Configurable columns are available:
    Screenshot_2020-08-21_at_14.04.54.png

More questions?

You can try visiting the OLAP | Frequently Asked Questions (FAQ) article. 

Have more questions? Submit a request