OLAP - Executive Sales & Profit Summary
The OLAP - Executive Sales & Profit Summary dashboard for Sage X3 tracks revenue down to net income, showing how costs and margin change at each step. It helps executive leadership see how sales and costs move by site and by month, and where margin is expanding or shrinking.
Sales and Finance OLAP Cubes
You need the Data Management add-on to use this dashboard.
How to use the executive sales and profit summary dashboard
- Watch revenue performance through a consolidated view of commercial results.
- Catch growth and decline by comparing this year with last year, which shows where revenue accelerates or contracts.
- Trace changes in margin structure alongside revenue growth.
- Single out top performing sales representatives by their net sales.
- Examine dependency on key customers and products to see the commercial risk it creates.
Filters
Use the filtering panel at the top of the OLAP - Executive Sales & Profit Summary dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.
Fiscal Year: one value
Fiscal Period: value range
Company: multiple values
Ledger: one value
Ledger Type: multiple values
Site: multiple values
Key performance indicators (KPIs)
The key performance indicators (KPIs) at the top of the dashboard show six measures from revenue to net income for the selected period, and update based on the filters you apply.
| KPI | What it measures |
|---|---|
| Revenue | Total sales value generated during the selected period, which shows the overall sales demand. |
| Cost of Goods Sold | Direct costs attributable to goods sold, which show production and purchasing costs relative to revenue. |
| Gross Profit | Revenue minus cost of goods sold (COGS), which shows the profit from core operations before operating expenses. |
| Operating Expense | Total indirect costs to run the business, including administrative and overhead expenses, which show how much overhead reduces profit. |
| EBIT | Earnings before interest and taxes, which shows operating profit without financing and tax costs. |
| Net Income | Profit or loss after all expenses, interest, and taxes for the selected period. |
Visual components
| View name | Type of view | What it shows |
|---|---|---|
| Sales by Site (TY vs LY) | Horizontal Bullet | Compares this year's sales against last year by site, with the bar showing this year (TY) and the reference line showing last year (LY). |
| Monthly Sales Performance (TY vs LY) | Horizontal Bullet | Displays this year's sales against last year by month to show which months are ahead or behind. |
| Net Income, Sales, and Margin Trends | Combination | Follows net income, sales month to date (MTD), net income margin %, and net income last year to date (LYTD) together over time to show how profitability and sales evolve month by month. |