OLAP - Product Sales & Geographic Performance
The OLAP - Product Sales & Geographic Performance dashboard for Sage X3 breaks out net sales by product category, product, country, and region, comparing this year against last year. It helps executive and commercial leadership see which products and regions drive the most revenue and how average sales per product and per country are trending.
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
- Review product portfolio performance by looking at the top performing and underperforming products.
- Explore geographic market expansion through the revenue distribution by country.
- Locate revenue concentration risk in specific products, categories, or regions.
- Match sales and marketing investments to the products and geographies that generate the most net sales.
- Relate geographic footprint to revenue by looking at the number of countries next to the net sales per country.
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. |