OLAP - Executive Sales & Profit Summary
The OLAP - Executive Sales & Profit Summary dashboard for Sage 300 breaks out revenue, cost structure, and profitability. It includes revenue, cost of goods sold, gross profit, operating expense, EBIT, and net income.
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
- Read revenue, profitability, and operating costs together in the six KPIs at the top.
- Follow gross profit, EBIT, and net income to see how much of the revenue remains at each step.
- Check operating expense and cost of goods sold against revenue.
- Compare sales month by month between this year and last year to spot growth or slowdown.
- Trace net income and its margin over the year.
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
Ledger: one value
Segment 2: multiple values
Segment 3: 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. |