Skip to Content

This is yet another question that I get from all angles, partners, customers but even colleagues. BW has been the spearhead SAP application to run on HANA. Actually, it is also one of the top drivers for HANA revenue. We’ve created the picture in figure 1 to describe – on a high level – what has happened. I believe that this not only tells a story on BW’s evolution but underlines the overall HANA strategy of becoming not only a super-fast DBMS but an overall, compelling and powerful platform.


Fig. 1: High level comparison between a classic BW and the two versions of BW-on-HANA. Here as PPT.

Classic BW

Classic BW (7.3ff) follows the classic architecture with a central DBMS server with one or more application servers attached. The latter communicate with the DBMS in SQL via the DBSL layer. Features and functions of BW – the red boxes in the left-most picture of fig. 1 – are (mostly) implemented in ABAP on the application server.

BW 7.3 on HANA

At SAPPHIRE Madrid in November 2011, BW 7.3 was the first version to be released on HANA as a DBMS. There, the focus was (a) to enable HANA as a DBMS underneath BW and (b) to provide a few dedicated and extremely valuable performance improvements by pushing the run-time (!) of certain BW features to the HANA server. The latter is shown in the centre of fig. 1 by moving some of the red boxes from the application server into the HANA server. As the BW features and functions are still parameterised, defined, orchestrated from within the BW code in application server, they are still represented as striped boxes in the application server. Actually, customers and their users do not note a difference in usage other than better performance. Examples are: faster query processing, planning performance (PAK), DSO activation. Frequently, these features have been implemented in HANA using specialised HANA engines (most prominently the calculation and planning engines) or libraries that go well beyond a SQL scope. The latter are core components of the HANA platform and are accessed via proprietary, optimised protocols.

BW 7.4 on HANA

The next step in the evolution of BW has been the 7.4 release on HANA. Beyond additional functions being pushed down into HANA, there has been a number of features (pictured as dark blue boxes in fig. 1) that extent the classic BW scope and allow to do things that were not possible before. The HANA analytic process (e.g. using PAL or R) and the reworked modeling environment with new Eclpise-based UIs that smoothly integrate with (native) HANA modeling UIs andconcepts leading also to a reduced set of infoprovider types that are necessary to create the data warehouse. Especially the latter have triggered comments like

  • “This is not BW.”
  • “Unbelievable but BW has been completely renewed.”
  • “7.4 doesn’t do justice to the product! You should have given it a different name!”

It is especially those dark blue boxes that surprise many, both inside and outside SAP. It is the essence that makes dual approaches, like within the HANA EDW, possible, which, in turn, leads to a simplified environment for a customer.

This blog has been cross-published here. You can follow me on Twitter via @tfxz.

To report this post you need to login first.

12 Comments

You must be Logged on to comment or reply to a post.

  1. vivek singh

    Hi Thomas,

    I am struglling to find answer to a question.

    Is it possible to run two BW servers on single HANA DB, accoriding to note – 0001666670, its not possible,

    Have you come accross any such scenario.

    If this is not possible, then what is the best possible approach.

    Regards,

    Vivek

    (0) 
    1. Thomas Zurek Post author

      Hi Vivek,

      your question does not really relate to the blog. However, here two quick pointers:

      1. A “multi DB” feature is planned to be shipped for HANA in 2015. It’d allow to run one HANA instance that caters for multiple DBs, each of them isolated to a certain extent. You’d have 1 of those DBs per BW system.
      2. While you are asking for a “MCOD” scenario you might want to consider an “MCOS” option. This is already possible for non-prod systems – e.g. dev + test systems on one HANA. Have a look at this OSS note: https://css.wdf.sap.corp/sap/support/notes/1681092

      Hope this helps.

      Thomas

      (0) 
      1. vivek singh

        Hi Thomas,

        Got the note beforehand, and I am still looking how to run multiple BW on single HANA box.

        Since client doesnt want to buy another box, looks like merging two BW system is the only option .( quite painfull).

        Do you have any other suggestion.

        Regards,

        Vivek

        (0) 
          1. vivek singh

            Hi Thomas,

            Lools like virtualization also doesnt allo multiple Productive BW systems in one hana box,

            Yes that should allow the applications in the “white list” ., but unfortunately, multiple SAP system is not one of them.

            Regards,

            Vivek

            (0) 
            1. Wilson Kurian

              Hi Vivek,

              HANA SP9 will bring in multi-tenancy capabilities along with workload management features, which will allow multiple DBs to act as tenants in a single HANA instance. You can then have BW, CRM, HANA Live and other white listed applications on a single productive instance.

              Regarding running multiple BWs on a single HANA instance is technically possibly when SP9 comes in play, but needs the correct of HANA license type.

              Regards,

              wilson

              (0) 

Leave a Reply