OLAP - Product Sales & Geographic Performance
The OLAP - Product Sales & Geographic Performance dashboard for Sage 300 surveys net sales by product, category, region, and country. It includes net sales per product and per country, alongside the top 10 product categories, products, and regions by net sales.
Sales and Finance OLAP Cubes
You need the Data Management add-on to use this dashboard.
How to use the product sales and geographic performance dashboard
- Contrast the top and bottom product categories by net sales to see which stand out.
- Locate net sales by country on the world map.
- Divide net sales by the number of products and countries selling to see revenue per product and per country.
- Rank the top 10 products and the top 10 regions by net sales.
- Track net sales this year against last year to see the overall change.
Filters
Use the filtering panel at the top of the 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
Key performance indicators (KPIs)
The key performance indicators (KPIs) at the top of the dashboard show six current year sales, product, and country measures, and update based on the filters you apply.
| KPI | What it measures |
|---|---|
| Net Sales Current Year | Total recognized sales revenue for the selected fiscal period in the current year. Higher values mean more revenue in the period, and lower values mean a decline in revenue or weaker product sales. |
| Net Sales Last Year | Total recognized sales revenue for the equivalent fiscal period in the prior year, used as the baseline for year over year comparison by product and geography. |
| Products Current Year | Number of distinct products with sales in the current fiscal period. Higher values mean more products are selling, and lower values mean fewer products, which points to concentration or a smaller assortment in use. |
| Net Sales / Product Current Year | Average revenue per active product in the current year. Higher values mean each product brings more revenue, and lower values mean each product brings less. |
| Countries Current Year | Number of distinct countries with sales in the current fiscal period. Higher values mean sales reach more countries, and lower values mean sales are concentrated in fewer countries. |
| Net Sales / Country | Average revenue per active country. Higher values mean each country brings more revenue, and lower values mean less revenue per country. |
Visual components
| View name | Type of view | What it shows |
|---|---|---|
| Top 10 Product Categories | Horizontal Bullet | Ranks the top 10 product categories by net sales for this year (TY), with last year as a reference line to show year over year change. |
| Net Sales by Country | Map | Displays net sales across a world map, with shading reflecting sales volume by country. |
| Top 10 Products | Horizontal Bullet | Lists the top 10 individual products by net sales TY, with last year as a reference line. |
| Top 10 Regions | Horizontal Bullet | Sorts the top 10 regions by net sales TY to show where revenue is geographically concentrated. |