SAP BW/4 HANA Upgrade Best Practices

Who am I? I’m Jim, and I’ve been living with BW for 20 years!

I first began working with SAP BW in 1998. At that time, I worked as part of a team delivering reporting solutions that would enable our business to work flexibly with Customer and Profitability data sourced from SAP R/3.

BW was effectively replacing a solution I had proudly built with Microsoft SQL and Cognos reporting applications. Although I appreciated and understood the architectural decision of the company to adopt the benefits of SAP integration, I was heartbroken at having to wave goodbye to my SQL-Cognos baby. I found the swap of SQL freedom to the controlled and initially confusing configuration options inside a BW 2.0b app a very bitter pill to swallow!

However, with good training and a strong desire to understand the inner guts of the BW apps, I was soon a convert. With BW, I had an object-based application that would help materialise a standard, pattern based Data Warehouse; supported with all the data extraction, query and reporting apps we needed to give us an end-to-end Business Intelligence platform, and critically a platform that could efficiently make sense of the thousands of underlying tables and “sophisticated” relationships in the R/3 database!

Upgrades, Upgrades!

Since then, SAP’s relentless investment in BW has consistently improved the usability of existing functions and brought new capabilities that build on the core concepts established in the early releases. Any BW developer will therefore know that the question of the next upgrade is something that is never far away in their thoughts.

Evolution of BW versions and investment in functionality

SAP BW/4HANA – THE Upgrade

What’s exciting about the upgrade timeline above, is that it is the here and now and the latest incarnation, SAP BW/4HANA, that presents the most dramatic step change in the world of BW as we know it. In the same vein of S/4HANA, some of the earliest foundations of the application are being radically ripped out in favour of a simplified suite of modern data platform capabilities that will enable BW to be reborn and live on in the new data driven future.

For example, no more will we build data models in the classic SAP GUI, no more will we deliver Business Explorer content – and with the right approach, no more will we be frustrated by the restrictions of data modelling solely based on the features available in the BW apps. In my opinion, this is the greatest benefit of SAP BW/4HANA: the capability to tap into the powerful in-memory SQL based modelling functions available with HANA Studio. In SAP BW/4HANA, BW Object data models can be consumed in the HANA SQL modelling space and vice-versa, side by side in the same Eclipse development environment. It is true that this capability has been evolving since the first versions of SAP BW on HANA, but with BW4’s Eclipse based data flow modeller the concept of a fully merged development environment supporting BW content and SQL based extensions is realised.

So, for those coming to BW for the first time, developers should find their experience far less jarring than the challenges I faced as a SQL head being plunged into BW in 1998. In fact, with the premium application management and maintenance features offered by SAP BW/4HANA, data modelling analysts and specialists from any technical background should appreciate the strength and completeness of functionality SAP BW/4 HANA offers.

How do we get there if you already run BW apps?

Migration to SAP BW/4 HANA needs to be approached with the same level of due diligence that any customer would introduce when upgrading systems. Essentially, we have two options available that should be considered as part of any initial analysis.

  • Upgrade you existing solution.

In terms of the journey to SAP BW/4HANA, the upgrade of an existing BW implementation is something that needs to be carefully considered. In one sense, the upgrade approach is based on the same path of generic activities we undertake with any upgrade. However, this time there should be far more focus on the step highlighted below “Execute pre-upgrade tasks”.

As SAP BW/4HANA radically digs out and replaces some of the classic core object types, pre-upgrade execution tasks are more involved. SAP BW/4HANA only supports the objects introduced with the more recent versions of BW running on a HANA Database e.g.  Advanced Data Stores and Composite Providers. Therefore, in preparation for the upgrade, we need to ensure that all deprecated object types are converted to their new equivalent before the upgrade can proceed and complete.

Arriving at the point where we can perform that conversion will involve an interim upgrade to SAP BW 7.5 on HANA (SP4) – unless you are already there. This two-step process and the timing of activities is something that should be carefully planned, and will of course depend on the complexity and criticality of the BW solution being addressed.

Typical Upgrade Activities (Functional Perspective)

  • Re-implement

The alternative is to consider a new installation of SAP BW/4HANA, and take the opportunity to re-implement your existing BW based solutions (and maybe some new ones) on a fresh platform that will replace your legacy BW implementation. The benefit here is that you are able to develop your new SAP BW/4HANA apps and implement without disruption to your current operational services.

I like the re-implementation approach, as many mature BW solutions contain a proliferation of redundant data and meta-data, so a clean slate could be the best place for an organisation to begin the next step of their analytics journey. On the Upgrade path, the preparation activities will force a review of existing objects (not least in terms of the conversion exercise), but a blank canvas could provide the catalyst for a full re-evaluation of “how” the Enterprise Data Warehouse is architected. SAP BW/4HANA supports modern data platform thinking and the concepts of logical data warehousing – for more information on that please look at the blogs here:

The Modern Data Platform Blog Series

Struggling to make data actionable? Blog

What is best for you?

Ultimately, finding the “right way” between an upgrade and re-implementation depends on a number of factors:

  • The complexity and criticality of the existing solution as a start point;
  • The level of risk/impact the upgrade would bring to the operation;
  • The analytics vision and priorities of the organisation; and
  • Organisational responses required for new initiatives e.g. “Connected” Business

At NTT DATA Business Solutions we have experienced consultant who can support customers with migration of SAP BW to SAP BW/4 HANA following our standard methodology. This methodology also takes in to account the customer roadmap of their ERP to S/4 HANA where required. Please contact NTT DATA Business Solutions to find out more about our migration assessment offers. I am looking forward to delivering the presentation “Best Practices for Migrating from BW to BW on HANA and Beyond to BW/4HANA” at the NTT DATA Business Solutions conference on 25 May 2017 in London. The NTT DATA Business Solutions Annual Conference, (#itelli2017), will promote 36 sessions comprising 18 presentations, 18 interactive areas, an extended Hands On Zone showcasing the very latest SAP solutions, plus the SAP Digital Boardroom.

Please Register here.

I look forward to welcoming you.


Posted by: Jim McNerney, Principal Consultant and SAP HANA / BW Capability Lead, NTT DATA Business Solutions

Jim BW (2)Jim is a SAP certified Principal BW/HANA Consultant and Chartered Management Accountant with over 18 years solution design experience gained while working for global end user and consulting organisations. As the NTT DATA Business Solutions Analytics Competency Lead for SAP Customers, Jim designs and delivers solutions that help clients drive insight from their data using SAP BW, HANA and BI technologies. He has solution experience covering a broad range of industries, including Professional Services, Food and Beverage, Retail, Manufacturing and Finance.

itelligence is now NTT DATA Business Solutions
We will be even stronger for our clients, partners and employees.
Check out our new website

For any questions please feel free to contact us.