The situation

The manufacturer runs SAP BW/4HANA on data from SAP S/4HANA, with reporting for sales and margins, finance and controlling, production, and purchasing and inventory. Requests for new reports and changes were building up faster than they could be delivered, and several queries and reports had become slow to open.

What we do

  • Monitor the daily data loads and process chains, and fix failed loads before business users start their day.
  • Deliver change requests and new reports: data models, extraction from SAP S/4HANA and queries for sales, finance, production and purchasing.
  • Tune slow queries and data flows, and keep the system clean with regular housekeeping.
  • Document data flows, process chains and operating procedures.
  • Support reporting in Analysis for Office, SAP Analytics Cloud, BW queries and Microsoft Power BI.

The support is delivered remotely, on a time-and-materials basis.

The result

  • Data is ready on time every morning, and failed loads are caught and fixed early.
  • The backlog of report requests is cleared, and new reports and changes arrive at a steady pace.
  • Queries and dashboards respond noticeably faster.
  • Data flows are documented, so knowledge of the system no longer depends on one person.