Skip to Content

This blog provides an insight in to the how SAP Netweaver BW 7.3 is going to benefit from the SAP’s In Memory technology SAP HANA. I have tried to collate all the information available into this one blog to help members get an overview about SAP NW BW7.3 on SAP HANA.

I have explained briefly what are the New additions in SAP Netweaver BW 7.3 and What is SAP HANA. Then we take a look at how BW 7.3 is going to get benefited when using SAP HANA. The blog also highlights briefly various structural changes that the BW objects will be undergoing when SAP HANA is used as an underlying database


SAP Netweaver BW 7.3 Features

SAP BW 7.3 is the latest version of SAP BW. With the enhanced modeling capabilities of SAP BW 7.3 development efforts and maintenance overheads can be reduced considerably. It comes with lot of features like:

  • Allows creating graphical design of the data flows thereby giving a visual interpretation of how the flow would look like, when fully developed.
  • Wizard based data flow modeling and generation of all related data flow objects.
  • With BW 7.3 existing data flow can be copied using the Data Flow Copy tool to create similar data models.
  • BW 7.3 provides a workbench like UI to migrate data flows.
  • BW 7.3 introduces the concept of Hybridprovider which combines the real time transaction data with historical data.
  • BW 7.3 also introduces a new type of modeling object called SPO(Semantic Partition Object)

SAP HANA Overview        

SAP HANA is a flexible, multi-purpose, data-source-agonistic in-memory appliance that combines SAP software components optimized on hardware It includes a number of integrated SAP software components including the SAP in-memory computing engine, real-time replication service, data modeling and data services.  SAP HANA allows: accelerated BI scenarios off any data source; better operational planning, simulation and forecasting; fast analysis and better decision making off accelerated SAP ERP transactional data, better storage, search and ad-hoc analysis of very large data volumes.

  • SAP HANA has the capability to analyze information in real-time at unprecedented speeds on large volumes of non-aggregated data.
  • SAP HANA can create flexible analytic models based on real-time and historic business data.
  • SAP HANA minimizes data duplication.

SAP BW 7.3 on SAP HANA

Till now SAP HANA was running side by side SAP NetWeaver BW. But in November 2011 SAP has launched SAP NetWeaver BW 7.3x running on HANA as the underlying In-Memory DB Platform. With version 7.30 SP5 it is possible to run run SAP BW on SAP HANA as database platform. This enables us to leverage the In-Memory capabilities of HANA and create SAP-HANA-optimized BW objects.


SAP BW 7.3 on SAP HANA:

  • Provides an integrated engine for all the data management and in memory processing of analytical capabilities
  • Allows the Database and BWA to merge in once instance. BW on HANA delivers BWA functionality for BW objects locally. There is no need for a separate BWA.
  • Simple administration of the database and singe set of administration tools.
  • Improved load performance for the DSO’s.
  • Excellent query performance
  • Accelerated In-Memory planning functions.
  • HANA supports column based storage, hence the compression rate will be higher and less data has to be materialized.

Difference between BW 7.3 running on HANA as against running on any DB

SAP Netweaver BW 7.3 on any Database

SAP Netweaver BW 7.3 on HANA

Supports Standard Datastore Objects

Supports In-Memory based Datastore objects

Includes both Database server and SAP Netweaver BWA

Includes just the SAP HANA In-Memory Platform

Support Standard InfoCubes

Support In-Memory based InfoCubes

Support BW Integrated Planning

Supports In-Memory Planning Engine

HANA data marts running side-by-side BW

Objects created in HANA studio and BW Staging from HANA.

SAP BW 7.3 powered by SAP HANA

To migrate to SAP HANA as database pure DB conversion is possible. No separate implementation required.

Once the DB conversion activity has been completed, conversion of InfoCubes and DSOs into new Hana-optimized object types needs to be performed so as to make optimal use of new In-Memory technology. Objects can be converted on an object-by-object basis.

Below diagram depicts how the system architecture will look like after the migration

Pic 1.jpgAfter the DB conversion, BW objects like DSO, InfoCubes can also be converted to leverage the In-Memory capabilities. These BW objects are then referred as In-Memory optimized DSO and In-Memory optimized InfoCubes respectively.

In-Memory optimized DSO

DataStore Objects forms an integral part of a data model in SAP BW. It is usually utilize to store information or data at a detail level. A DSO is also useful if we want to extract Delta information from datasources. At times with huge amount of data the activation process and the reporting on a DSO takes a lot of time, thereby affecting the overall performance.

In the current architecture the activation process calculates changes for each record thereby creating load on the database. The Delta calculations are performed on the Application server itself. A lot of lookup/roundtrips happen between the application server and database to calculate the delta information

Pic 2.jpg

With an In-Memory optimized DSO’s:

  • Delta calculation has been completely integrated in HANA.
  • Uses In-Memory data structures which helps in faster access.
  • As the calculations are done in HANA itself, there are no round trips to application server.
  • Helps avoiding storage of redundant data.
  • The existing dataflow of the DSO remain unchanged. The DSO definition also remains unchanged after migration.
  • To activate In-Memory capabilities in a Standard DSO a new setting ”In Memory Optimized” is available, when checked and activated the standard DSO is converted to In-Memory Optimized DSO.
  • In-built tool provided to convert the existing Standard DSO’s to In-Memory optimized DSO’s

In-Memory optimized Infocube

InfoCubes also forms an integral part of a data model in SAP BW. They describe a self contained dataset. In the current architecture an Infocube is a set of relational tables arranged according to star schema. This star schema has a big fact table surrounded by Dimension tables. The Dimension tables are then linked to Master Data tables through SID’s

Pic 3.jpg

With an In-Memory optimized InfoCubes:

  • In Memory optimized info cubes are structured to represent flat structures without Dimension tables and the E table.
  • The Data Modeling process gets simplified as the dimensions are not physically present.
  • Faster data loads to cube as there are no Dimension Id’s.
  • To activate In-Memory capabilities in a Standard Infocube option is available in Infocube property, when Selected and activated the standard Infocube is converted to In-Memory Optimized Infocube.
  • In-built tool provided to convert the existing Standard Infocube’s to In-Memory optimized Infocube

In-Memory Planning:

For a SAP BW server on any database the Traditional Planning runs planning function on Application server. With In-Memory the planning functions are executed on SAP HANA

Pic 4.jpg


  • This provides a performance boost for planning capabilities like aggregation, disaggregation, conversion, revaluation.
  • Performance boost for plan/actual analysis.
  • No changes required to the planning models

Query Performance on In-Memory :

With SAP HANA as the underlying database the query performance also improves significantly.

Query performance on InfoCube

  • Indexes on InfoCube and master are no longer required.
  • In-Memory based calculation engine.

Query performance on DataStore Objects

  • Acceleration via In-Memory Column storage.
  • Additional acceleration via Analytical views on top of DSO

Pic 5.jpg

Conclusion:

With SAP HANA as underlying database, SAP BW 7.3 system can achieve:

  • Excellent query performance.
  • Accelerated In-Memory planning capabilities.
  • Performance boost for ETL processes.
  • DB and BWA merging in one instance.
  • Simplified administration via one set of admin tools.
  • Column based storage with highly compression rates and significantly less data to be materialized.
  • Simplified data modeling and reduced materialized layers.
  • Integrated and embedded flexibility for Data Marts

Related Content

Reference 1

Reference 2

Reference 3

To report this post you need to login first.

9 Comments

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

  1. Jagadish Thirumalachetty

    Hi Mr Partho Mukherjee

        We are currently in a Pre upgrade phase to implement BW 7.3 from current 7.0 do you suggest to go with existing data base and just upgrade I.e  SAP Netweaver BW 7.3 on existing Oracle 11 G ?? or recommand for SAP Netweaver BW 7.3 on HANA to use the In-Memory capabilities. Business is very much interested to increase the performance of our daily running operational reports.

    Thanks for the very nice write up it helped me a lot.

    Regards

    Jagadish Thirumalachetty.

    (0) 
    1. Rama Shankar

      Jagadish:

      Upgrading your SAP BW 7.3 system to run on SAP HANA database is always a good ideas. Last week SAP announced the GA (general availability) of SAP HANA SPS3 database for BW 7.3. If your business needs it and you have budgets to purchase SAP HANA hardware and software, it is always good to migrate your BW 7.0 system to run on SAP HANA.

      Please read my executive summary / write-up on SAP HANA DB for BW 7.3 also @ http://www.sendspace.com/filegroup/u1AO5NidaMTYSD49JoHsjg

      Regards,

      Rama

      (0) 
      1. Jagadish Thirumalachetty

        Hi Rama

            Thanks for the write up/Reference on Hana. I am very much impressed with What’s Cool in HANA v1.0 i am confident most of our on going business concerns/performance issues will be address with this 7.3 upgrade we plan to do i shall surely share all my best practices / learning for every one here in SCN . i am lucky to get some reference from you on the first go ..looking forward of a good learning experience and honored to be here .

        Much Regards

        Jagadish Thirumalachetty.

        (0) 
    2. Partho Mukherjee Post author

      Hi Jagdish,

      Thanks for your comments. It is always a good idea to move to SAP BW on HANA provided your business is ready to approve.

      Regards,

      Partho.

      (0) 
      1. Jagadish Thirumalachetty

        Thanks Partho , Yes we are talking to business this week and shall come up with all the pain points that can be address marketting upgrade 7.3 with Hana hopefully business will be happy to approve.

        Regards

        Jagadish Thirumalachetty.

        (0) 

Leave a Reply