Skip to Content
Author's profile photo John Appleby

Year of the Upgrade – tips and tricks for a BI upgrade

Following on from my last blog “2010, The year of the upgrade”, I’ve decided to include some more detail on some of the SAP products I’m seeing being upgraded most right now.

I’m going to start with BW, and the upgrades I’m seeing most of so far this year are BW 3.x to 7.0. Because the BW 7.2 release has now been postponed until BW 7.3, which is projected to go into RampUp in H1 2010, there is even more of an impetus to upgrade to 7.0 now and consider 7.3 in future.

I think there are a few good drivers to this:

1) I think that BW 7.0 came of age in 2009. It matches the stability of the 3.x product set and new features are being introduced without reducing platform stability. With this comes the EOL for BW 3.x and the maturity of the upgrade tools including the CUC.

2) The BOBJ acquisition has now got a fairly stable roadmap, and SAP NetWeaver BW is well and truely part of the future vision of Business Intelligence. The BEx toolkit support has been extended and the Pioneer product will be built out on top of BW. This is especially relevant to customers who are using Webi on top of BW 3.x because it is a tacit admission that the SAP Integration Kit layer isn’t going to replace the RFC platform that BEx users for the middleware layer.

3) Ss we come out of recession, organisations want better line of sight BI through the organisation, and as a result they are looking to invest in the BI platform. Upgrades are often forming the first phase of a larger BI investment.

4) Many BW 3.x platforms are built on ageing hardware and are slow. I’ll talk in some more detail later on about how BW 7.0 can resolve performance problems.

If you are considering an upgrade then you first need to understand the drivers for the upgrade as this will affect your strategy.

1) Performance

If performance is your largest driver then the benefits of BW 7.0 are unlikely to disappoint.

a) The Business Warehouse Accelerator (BWA, formarly known as BIA) is the silver bullet for many organisations and in large data warehouses can be the single reason to upgrade. If you use transaction ST03N and look at the BW Workload, you can see where the time is spent in a BW query. If it is spent at the database level then BWA can help you. It’s not uncommon for database time to be 90% of total. If however the time is spent in the OLAP or front end then you should consider BWA more carefully and how your queries are written.

b) BW Request Archiving

Every time you perform some sort of BW data load (PSA/DSO/Cube etc.) then you write to the BW request tables like RSMONMESS. If you go to DB02 then select the “Largest Tables” option (depends on your DB platform) then look out for large tables starting in RS. It is not unusual for these tables to become very large (80Gb is the largest I have seen a RS table).

This can also be visible by the BW data loads slowing down. If you run a ST05 trace then you will see large numbers of hits to the RS tables which are taking a long time. BW7 permits these large tables to be archived in transaction SARA which can dramatically improve performance.

Note 706478 – Preventing Basis tables from increasing considerably

c) BW7 data objects

It is possible to rewrite your data flows using BW7 concepts such as DSOs and Transformations. This typically speeds up data flows by 25%, although if your loads use poor quality ABAP routines then you can do things like move ABAP code into the start routine and get even large performance increases. For long running data loads, this can be much appreciated.

d) BW 7.0 tools for performance

7.0 brings a number of tools that can benefit performance and they are well documented. Especially if you run queries by characteristic 0CALMONTH or 0FISC_PER, can you get the benefits of online repartitioning. Similarly the online remodelling capabilities are neat for remodelling InfoProviders on the fly.

e) Hardware

Last but not least is hardware. If you are planning to upgrade BW and it is on old hardware then there is the opportunity to purchase new hardware at the same time. BW system copies can be performed at the same time as the upgrade and performance can be much improved, whilst keeping within hardware support.

2) Support

If moving back into support is your largest concern then there are a few obvious points.

a) Support for BW 7.0

BW 7.0 is currently set to be supported until 31.12.2015 wtih extended support until 31.12.2017. Support for BW 7.3 has not yet been announced but general availability is likely to be some time in 2011, which means that there is an expectation that support would be beyond 2015.

b) Support for Gui components

SAPGui 6.40 went out of support some time ago and 7.10 is the current version. However even given this, 7.10 is built on Visual Studio 2005 which goes out of support in April 2011.

Even still, SAPGui 6.20 remains in support until 31.12.2010 although it is not supported in BW 7.0.

Therefore SAPGui 7.20 is coming which is built in Visual Studio 2008 and will therefore go out of support in April 2013. Planned shipment is in March 2010. 7.20 provides support for Office 2010 and Windows 7, although 7.10 does already provide support for Windows 7 on the latest version.

See Note 147519 – Maintenance strategy / deadlines ‘SAP GUI’ for more details.

b) Hardware / DB Support

BW 7.0 supports a wide range of hardware components. Some 32-bit platforms are conditionally supported but my recommendation if you are running 32-bit hardware is to always migrate to 64-bit hardware.

On Oracle and MSSQL this is straightforward – the database files are compatible on most hardware platforms.

Oracle 9i is no longer supported on BW 7.0 and therefore you must upgrade to Oracle 10g before upgrading BW, which is supported until 31.07.2011. Oracle 11g support is coming, planned for H1 2010.

MSSQL is relatively flexible on BW 7.0, although I would strongly recommend running Windows 2008 x64 (not R2!) and MSSQL 2008, because of the row level compression capabilities that it provides – see Note 991014 – Row Compression/Vardecimal on SQL Server.

Linux, HP-UX, Solaris and AIX support is fairly flexible and in most cases not very different to BW 3.x in support terms. Hardware support is

3) New Projects

People talk a lot about building a “Platform for the Future” and this is a phrase that I personally really enjoy. It is not uncommon for a BW upgrade to be as a precursor to a future body of work.

Given this it is not unusual to plan out 3 workstreams – an infrastructure workstream which will build out the hardware (and migrate the database), an upgrade workstream which will perform the in-place upgrade, and a project workstream which will take advantage of this.

The benefit of this is that by using a POC approach, the 3 workstreams can be run in parallel, with a technical cutover (infrastructure and upgrade) shortly preceding the project go-live.


The BW 7.0 upgrade is a well documented and stable process that can be performed as a pure technical upgrade with little or no change to business process whilst providing excellent non-functional benefits.

This can provide a challenge in term of getting internal funding for such and upgrade and this article gives some ideas of how the functional and non-functional benefits of such an upgrade can be put together to create a business case.

Assigned tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Witalij Rudnicki
      Witalij Rudnicki
      Personally, I would add that although DW Workbench in 7.0 is not yet state-of-the-art, it is certainly a big improvement comparing to AWB in 3.x. Newer interface allows making things faster for technical people. But again, there is still a lot of room for improvement in RSA1 and especially in RSPC.

      From my experience all proactive upgrades were driven by need for BWA, and all reactive upgrades were driven by 3.x going out of support. RTDA is another major technical improvement, but I have not seen it being a driver for upgrades.

      I think BWA will be a major driver for 7.2 as well, because features like DSO indexing and more analytics in BWA have been long time expected.

      Thinking about timeline of support, it is funny that SAP measures those starting from SP of General Availability, not from SP when release is getting really stable 😉


      Author's profile photo John Appleby
      John Appleby
      Blog Post Author

      For sure the functional benefits in BW 7.0 are far and wide. Data modelling, partitioning, usability. The improvement in front end tools and in the web interface compared to NetWeaver 2004 Portal. BOBJ Enterprise integration and Data Services integration for ETL. ABAP OO.

      Interestingly (and I think we agree on this anyhow), I have never run an upgrade workshop where one of those many benefits was on the list of significant events which would trigger an upgrade.

      I'd better write a blog on 7.2 at some stage (once the RampUp program starts). However I don't expect this position to change much with 7.2.

      The big benefits I see in 7.2 are the indexing from DSO like you say, and semantic partitioning. Also the ability to do HybridProviders where you can archive online, because as some ageing Data Warehouses need data removing from the top tiers of storage, and the business won't allow it to be deleted.



      Author's profile photo Roland Kramer
      Roland Kramer
      If you have access via the Link to the RKT NetWeaver Material, there you will find a overview Presentation how the Upgrade to BW 7.20 and higher works, with new Features, etc. as a complementary Presentation to the SDN Upgrade Link SAP BW Application Lifecycle Management (ALM)
      To find a suitable Upgrade Workshop for BW you will find on top of the Page the description of the Upgrade Workshop WDEBU7
      Author's profile photo John Appleby
      John Appleby
      Blog Post Author
      Hey Roland,

      I've absolutely been through the BW 7.2 material. I've also presented this to a number of SAP customers and we've had some feedback on the features available.

      Interestingly the most compelling reason for many was the indexing directly from DSOs with the ability to then drop InfoProviders and therefore save disk space.

      The BWA 7.2 features of indexing non-SAP data is also popular although this doesn't require BW 7.2 of course.

      Whether the other features are relevant is an interesting point and we'll see how the customers react. From the reactions I have seen, it is likely that once 7.2 is shown to be stable, customers will immediately begin to upgrade to 7.2 from 3.x.

      This is a great overview presentation of BW 7.2 for those that are interested:



      Author's profile photo Roland Kramer
      Roland Kramer
      SAP NetWeaver Business Warehouse (BW) 7.2 will be consolidated into SAP NetWeaver 7.3

      The feedback from our customers was loud and clear: while they appreciate the features that would have been available via the 7.2 release, they prefer a more complete feature release and fewer upgrade steps. SAP listened and will consequently not release SAP NetWeaver BW 7.2 in favor of consolidating the 7.2 and 7.3 functionality into one go-to release.

      Customers can now look forward to the upcoming SAP NetWeaver 7.3  with the benefit of a full SAP NetWeaver technology platform release supporting all of the SAP NetWeaver hubs. In addition tighter integration of the SAP BusinessObjects tools and support for SAP Strategic Enterprise Management (SEM), enhanced Business Planning and other BW add-ons are important to customers and will be available through the combined SAP NetWeaver 7.3 release.
      The start of Ramp-Up for SAP NetWeaver 7.3 is planned for the second half of 2010.

      Furthermore, a SAP NetWeaver 7.3 Beta program is currently targeted for late 1H 2010. Additional information will be provided in the upcoming weeks.

      Author's profile photo John Appleby
      John Appleby
      Blog Post Author
      Hi Roland,

      Yes, it is very interesting that 7.2 has been cancelled.

      There are a number of features that were going to be very useful to SAP customers but I am minded to agree that a full technology release would be very useful - particularly considering that the 7.2 products released so far have not extended support beyond 31.12.2015/31.12.2017.

      What isn't clear yet is what 7.3 will bring for BW and in what timescale.

      But for BW 7.0 upgrades this seems like a good thing because it has reduced confusion for customers and given them a clear roadmap.



      Author's profile photo Roland Kramer
      Roland Kramer
      Hello Community, you might want do have a look to the SDN page which refers to the Upgrade Workdhop WDEBU7 for the Successfull Upgrade to NetWeaber BW 7.0 and higher, eg. EhP1 SAP BW Application Lifecycle Management (ALM) and in particular the "BW Upgrade Bible" which covers all BW application Specific Steps bundled in the ASU toolbox for BW, due to the Fact the classical Upgrade Manuals only refer to the tool specific pre and post Steps