Skip to main content

OLAP - Sales Anomalies and Trends

Acumatica, OLAP Dashboard

The OLAP - Sales Anomalies and Trends dashboard for Acumatica examines margin erosion risk, unusual daily sales activity, and sales patterns over time. It flags early warning signals in customer and product performance, risk that comes from sales volatility, and statistically abnormal revenue events.

Sales and Finance OLAP Cubes

You need the Data Management add-on to use this dashboard.

  • Follow sales activity intensity through how often sales transactions occur across representatives, customers, and products.
  • Assess revenue productivity by comparing how customers and invoices convert into net sales.
  • Identify top performers among sales reps, customers, and products using order frequency.
  • Monitor transaction efficiency with the average invoice value and the revenue per customer.
  • Spot commercial concentration risk where sales depend on high frequency customers, products, or representatives.
Acumatica OLAP Sales Anomalies and Trends Dashboard

Filters​

Use the filtering panel at the top of the OLAP - Sales Anomalies and Trends dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.

Year: one value
Period: one value
Organization: multiple values
Site: multiple values
Branch: multiple values
Product Category: multiple values

Visual components​

View nameType of viewWhat it shows
Customer Margin Erosion MonitorBubbleDisplays customers by net sales variance %, with bubble size reflecting sales volume. Customers further right have a higher variance, and customers with shrinking margins sit toward the bottom.
Temporal Sales Density MapBubbleGroups sales activity by calendar period, with bubble size reflecting sales volume. Larger bubbles mark periods with a higher concentration of sales.
Product Margin Erosion MonitorBubbleCompares products by net sales variance %, with bubble size reflecting sales volume. The view has the same structure as Customer Margin Erosion Monitor but at the product level.
Anomaly Detection in Daily SalesCombinationFollows daily net sales alongside volatility bands (high and low). Days where sales fall outside the bands point to unusual activity that may need investigation.