Search Icon
SAP BW to SAP Business Data Cloud | Life Sciences Success Story
Data & Analytics•Life Sciences•4 min read

Future-Proofing Critical Quality Reporting Before SAP BW End of Support with Zero Disruption

Applexus moved a life sciences company's quality and make-to-order reporting from SAP BW to SAP Business Data Cloud at a fixed price, cutting the data estate to maintain by 78% while users kept working exactly as before.

SAP Business Data CloudSAP DatasphereSAP Analytics Cloud
6 monthsfrom kickoff to go-live, at a fixed price
100%of critical reports moved like-for-like, with no retraining
78%fewer data objects to run and maintain
0new licenses, hardware or environments needed
6 monthsfrom kickoff to go-live, at a fixed price
100%of critical reports moved like-for-like, with no retraining
78%fewer data objects to run and maintain
0new licenses, hardware or environments needed

The reports worked. The platform underneath them had an end date.

For a life sciences company, quality and make-to-order reporting is not a back-office convenience. It shapes product quality decisions, keeps customer orders on track and supports audit readiness. At this company, 14 of those reports ran on SAP BW 7.5, a platform leaving SAP's mainstream maintenance in December 2027.

Leadership faced two unattractive options: pay to keep an ageing system alive, or put critical reporting at risk. Applexus gave it a third: a fixed-price move to SAP Business Data Cloud that removed the risk well ahead of the deadline, with no change to how people work.

SAP BW 7.5 vs SAP Business Data Cloud with Applexus modernizationEnlarge

The Challenge

Three risks between the business and its next platform

  • Quality and compliance exposure. Running quality reporting on a platform heading out of support is a risk no quality or compliance leader wants to carry. Staying put meant paying for extended support and relying on a shrinking pool of BW skills.
  • Decisions slowed by fragmented data. Three overlapping BW systems and multiple data load runs meant reports lagged behind the business, and every new question waited on IT.
  • The risk of paying twice. With S/4HANA on the roadmap, a simple lift-and-shift would have meant rebuilding reporting all over again a few years later.

The goal was not just to leave the old platform. It was to leave without quality or operations teams noticing the switch.

And to land on a foundation that would not need rebuilding when S/4HANA arrives.

The Solution

A clean rebuild, not a copy of the old system

  • Same reports, same way of working. All 14 reports were rebuilt in the SAC Excel Add-in at feature parity, on nine Datasphere analytic models that replaced BW InfoProviders. Users kept their Excel workflow.
  • A far simpler data estate. 32 BW data sources were replaced by direct replication flows from SAP ECC. 54 BW objects (16 ADSOs, 11 DSOs, 1 cube and 26 master data objects) were consolidated into inbound, harmonization and reporting layers, with only 12 tables persisted.
  • History and security come along. Eight years of history, 2018 to date, was migrated. BW authorizations were extracted with an Applexus utility and rebuilt as Datasphere roles and row-level data access controls.
  • One predictable schedule. Multiple load runs gave way to three scheduled refreshes a day through Datasphere task chains, run from Control-M, the company's enterprise scheduler.
  • Built for S/4HANA from day one. A data flow was already remediated to run on S/4HANA through CDS views and replication flows, so the ERP move will not mean another rebuild.

solution-diagramV2.pngEnlarge

Applexus's BW Modernization Accelerator mapped every BW object, its lineage and its transformation logic automatically, reducing manual analysis and the risk of missing hidden business rules. It was included in the fixed price, with no third-party licenses.

How It Runs

Six steps from old platform to business as usual

  • Analyze every report back to its source data, automatically, with the Applexus BW Modernization Accelerator.
  • Design the target architecture, layering and standards before any build begins.
  • Rebuild data flows straight from the source and load eight years of history.
  • Recreate all 14 reports and their security in the SAC Excel Add-in, at feature parity.
  • Validate every report number for number against the original, with qualification testing to the company's validation standards before business sign-off.
  • Hand over after three weeks of hypercare, with the in-house support team fully in charge.
What Changed

Beyond the migration

  • Risk removed well ahead of the deadline: Critical quality and operations reporting no longer depends on a platform leaving mainstream support, and there is no last-minute scramble as 2027 approaches.
  • Business as usual from day one: Every report matched its original before go-live, and users kept their familiar Excel workflow. No retraining, no lost productivity.
  • Less to run, fewer points of failure: 54 stored data objects became 12, so IT has far less to store, monitor and reconcile.
  • One rhythm for decisions: Three scheduled refreshes a day replaced multiple load runs, so teams know exactly when data is current and work from the same numbers.
  • Cost certainty, and no second rebuild: Delivered at a fixed price with no new licenses, on a foundation that is S/4HANA-ready and audit-ready, with access controlled down to individual records.

Facing your own SAP BW deadline?

Talk to our experts about a fixed-price path to SAP Business Data Cloud, with no disruption to your business

Contact Us

Related Success Stories

Unifying SAP BDC & Databricks Lakehouse: Freight Rail Success Story

26 October 2026

Connecting Railroad Spend to the Operations Behind It - One Trusted Data Foundation in 6 Months

Cutting Supply Chain Planning

05 October 2026

Enabling Smarter Planning by Conversational Analytics in Supply Chain

Batch Reconciliation on SAP Databricks: 70% Less Manual Effort

21 September 2026

Reconciling Every Delivery Against Contract in Real Time - Cutting Manual Effort by 70%

Specialty Gas AI Forecasting on Databricks

31 August 2026

Driving Better Forecast Accuracy with AI-Led Supply Chain

Modernizing Cost Center Planning with SAP Analytics Cloud

05 January 2026

North American Power Utility provider Modernizes Cost Center Planning with SAP Analytics Cloud

A leading pet products chain in the U.S

10 December 2025

Retail Pet Products Chain Enables Faster Decisions and Enterprise-Wide Visibility with SAP Business Data Cloud

Banner image showcasing advanced medical equipment including diagnostic tools, surgical instruments, and monitoring devices, symbolizing the company's commitment to healthcare innovation and quality patient care.

11 September 2025

US-Based Medical Devices Company Transforms Operational Analytics with SAP Datasphere

SAP Datasphere solution for upgrading sales and finance analytics in the pharma industry

28 July 2025

A Global Pharmaceutical Leader Gained Real-Time Sales Intelligence and Predictive Finance Insights with SAP Datasphere and SAP Analytics Cloud