How to set up KPI alerts and scheduled reports from SAP

Alert only on the few KPIs where a named person will act, set limits outside the normal range of each figure, and send each audience a short scheduled report at the pace of its decisions. Keep every report inside your organization. LendraBI sends scheduled email reports with a PDF and checks KPI limits hourly.

Updated LendraBI by XPL Services

Which KPIs are worth an alert?

Alert only on figures where a change calls for action by a named person. If nobody would do anything when the alert arrives, the figure belongs on a dashboard instead.

Test each candidate with three questions:

  • Who owns it? One person or role, not a whole team.
  • What will they do? Call the customer, chase a delivery, move stock or hold a purchase.
  • How often can it change? A figure that moves daily can justify daily attention. A monthly figure cannot.

KPIs that often pass the test, for example:

  • Overdue receivables for a key customer above an agreed amount.
  • Stock of a critical material at a plant below its safety level.
  • Sales for a sales organization falling behind plan for the month.
  • Spending on a cost center above its budget.
  • Open purchase orders past their delivery date.

Keep the list short. A handful of alerts per person is plenty.

How do you set limits that avoid noise?

Base each limit on the figure's normal range, not on a round number, and decide whether you care about a level or a change. Then review the alerts once they have run for a while.

  1. Look at the history. Check how the figure moved over recent months to see its normal range.
  2. Set the limit outside normal variation, so an alert means something unusual happened.
  3. Choose the alert type. Use the table below.
  4. Give each alert one owner who receives it and acts on it.
  5. Review after the first month. Adjust alerts that fired too often and question the ones that never fired.
  6. Retire alerts nobody acts on. An ignored alert trains people to ignore the next one.
TypeUse it whenExample
Limit alertA level matters on its ownOverdue receivables pass the amount agreed with the credit manager
Change alertA sudden move matters more than the levelWeekly sales of a product line drop sharply against the week before
Scheduled reportPeople need the picture, not a triggerA Monday sales summary for regional managers
An alert that fires every day stops being read. Fewer, sharper alerts get acted on.

Who should get which report, and how often?

Match each report to the decisions its audience makes and the pace at which they make them. One short report per audience works better than one long report for everyone.

AudienceReportFrequency
Management teamSales, margin, cash and receivables overviewWeekly, plus the monthly pack
FinanceReceivables by age and overdue customersDaily or weekly
Sales managersSales by customer and product against planWeekly
Plant and warehouse managersProduction and stock by plantDaily
PurchasingOpen purchase orders and late deliveriesWeekly

Time each report to the moment it is used: a daily stock report before the morning planning meeting, a weekly sales summary before the Monday sales call, the monthly pack once the close is signed off. A report that arrives after the meeting it was meant for gets skipped.

Keep the email itself short: the three or four figures that matter, how they changed since the last report and a link to the dashboard for detail. Attach a PDF when people need a record. The monthly pack has its own process, covered in building the monthly management report.

How do you keep scheduled reports inside the organization?

Send reports only to named people in your organization, give each audience only the figures it may see, and check the recipient lists whenever you review access.

  • Use named recipients rather than open mailing lists that grow over time.
  • Build a separate report for each audience instead of one report with every company code.
  • Remember that a PDF can be forwarded, so send detail only to people allowed to see it.
  • Remove leavers and people who changed jobs from recipient lists. The same principles apply as in controlling who sees which SAP figures.

How does LendraBI handle alerts and scheduled reports?

LendraBI sends scheduled email reports and watches the KPIs you choose. Scheduled reports go only to people in your organization.

  • Scheduled email reports show the figures in the email and as a PDF, on the schedule you set.
  • KPI alerts fire when a figure crosses a limit you set, with limits checked hourly, or when a figure changes.
  • In-app notifications and a "What changed" card keep changes visible inside LendraBI.
  • "Ask why…" on any chart explains in plain words what moved a figure, a good first step after an alert.
  • On a phone, LendraBI installs on the home screen with a phone layout, so owners can check a figure wherever they are.

The ready-made dashboards for receivables, sales, purchasing and inventory are a good base for both alerts and reports. See SAP dashboards for what they cover. To see alerts and scheduled reports in LendraBI, book a demo.

Questions

How often does LendraBI check KPI limits?

Limits are checked hourly. You can also get an alert when a figure changes, not only when it crosses a limit.

Can scheduled reports include a PDF?

Yes. Scheduled email reports show the figures in the email and as a PDF.

Can scheduled reports go to people outside my organization?

No. Scheduled reports go only to people in your organization.

Can I check figures on my phone?

Yes. LendraBI installs on a phone's home screen with a phone layout, and you use the same sign-in as on desktop.

Book a demo

See LendraBI on your own SAP figures.

A guided walkthrough with our team, built around the questions your people ask every day.