Skip to main content

OLAP - Sales Anomalies and Trends

Sage 300, OLAP Dashboard

The OLAP - Sales Anomalies and Trends dashboard for Sage 300 scans margin erosion risk, abnormal 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.

  • Spot margin erosion by customer and product before it grows into a larger financial impact.
  • Catch statistically abnormal sales spikes or drops for fraud checks, operational review, and validation of one-off events.
  • Follow day level and month level sales density to see patterns in operational and commercial activity.
  • Notice outliers that may signal posting errors, timing issues, or extraordinary transactions.
  • Trace the source of margin erosion by customer and product, for pricing decisions, contract renegotiations, and product portfolio decisions.

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.