Skip to Content
Author's profile photo Vivek Singh Bhoj

Share the Knowledge – Optimizing SAP BW on SAP HANA Part 2

Hi Everyone,

This is the second part of the blog Share the Knowledge – Optimizing SAP BW on SAP HANA Part 1

Best Practice # 7: Avoid Issues During Migration by  Using Automated Task Lists

We were told about optimizing System Migration

1.) Use the Checklist tool:It is recommended to run it before, during, and after migration for optimal insights

2.) Setup Task lists: use task lists for system preparation and system copy

3.) Run Post Migration Program

Go to Migration tab


After that a little bit intro about DMO was given

DMO(Data Migration Option) is an option of SUM (Software Update Manager) for a combined update and migration: update an existing SAP system to a higher Software Release and migrate to SAP HANA database.

To learn more about DMO check the below documents:

Migration to HANA made easy with DMO

SAP First Guidance – Using the DMO Option to Migrate BW on HANA

Automated Processes for BW on HANA Migration | SAP HANA

Also check SAP Note 1799545 – Using DMO of SUM for SAP BW systems

Best Practice # 8: Validate SAP HANA Configuration,  Check Table Consistency and  Monitor Delta Merge

Use the Checking Tab of BW Migration Cockpit:

Rerun the checklist tool


Run Table Consistency check


Run Delta Merge Check


To learn more about Delta Merge process, check the below document:

How To – Delta Merge for SAP HANA and SAP NetWeaver BW powered by SAP HANA

Also check SAP Note 1663501 – Log for BW merge trigger

Check if Secondary indexes are required to be created


Also check SAP Note 1740373 – DSO: Maintenance of database indexes in SAP HANA

Best Practice # 9: Improve Performance and  Simplify Administration and Infrastructure by  Converting Data Flows and InfoProviders

Go to Conversion tab


Optimize Data Flows: Convert 3.x Data Flows to 7.x Data Flows


For migration, also check the below link:

Migrating a Data Flow – Modeling – SAP Library

Optimize InfoProviders: Conver Infocubes to HANA Optimized Infocubes


Learn more about InfoProviders in BW on HANA:

InfoProviders in SAP NetWeaver BW powered by SAP HANA – Webinar Presentation

DataStore Objects in SAP NetWeaver BW on SAP HANA

Aspects of the HANA-optimized InfoCube | SAP HANA

Also check SAP Note 1849497 – SAP HANA: Optimizing standard DataStore objects

Optimize Data Layers:


To learn more about LSA++, check the below documents:

LSA++ for SAP NetWeaver BW on SAP HANA

SAP HANA as Driver of EDW Evolution: LSA++ (Layered Scalable Architecture) for BW on SAP HANA – Webinar Presentation

Use BW Transform Finder to quickly find transformations in SAP NetWeaver BW systems – for example to identify InfoProviders that can potentially be retired when using SAP HANA.

Check SAP Note 1908367 – SAP NetWeaver BW Transformation Finder


Best Practice # 10: Tune Custom Code According to  Best Practices for ABAP on SAP HANA

Go to Optimization tab


Use ABAP Routine Analyzer that automates the check of best practice guidelines for ABAP routines in SAP NetWeaver BW systems focused on statements that can potentially be optimized for SAP HANA


To learn more about ABAP Code optimizzation for SAP HANA, check the below documents:

Performance Guidelines for ABAP Development on the SAP HANA Database

ABAP ON SAP HANA – Optimization of Custom ABAP Codes for SAP HANA- Presentation

How to Evaluate ABAP Coding for Optimization On SAP Suite on HANA

ABAP for SAP HANA – Webinar Replay

ABAP and developing on BW on HANA | SAP HANA

The tools mentioned above do most of the tasks but still there can be few activities that we might have to perform manually.

For knowing more about BW on HANA migration and steps involved in it, we should also check SAP BW on HANA Cookbook

Additionally, we can learn more about BW on HANA from the below documents:

General Information for BW on HANA | SAP HANA

DBA aspects | SAP HANA

BW 7.4 on HANA Overview and Roadmap

Do remember to check SAP NetWeaver BW Powered by SAP HANA Community

Thanks for reading my blog



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good one.



      Author's profile photo Raman Korrapati
      Raman Korrapati

      Nice blog and very help full to me.All content at one place.

      Thanks for making and sharing with us vivek.

      Author's profile photo Antony Jerald J
      Antony Jerald J

      Really helpful.  Thanks so much for sharing with us 🙂


      Antony jerald.

      Author's profile photo Former Member
      Former Member

      Dear Vivek,

      Awesome elobartion of the topic. Thank you so much. One question, do you know where I can find the link to the video of RDP303? Any demo with it? Looking for BWoH demo on Custom Code like CD262 demo

      TQVM & Cheers,

      Author's profile photo Mahmoud Soliman
      Mahmoud Soliman

      Good job and thank you for sharing this document with all of us

      Author's profile photo Former Member
      Former Member

      Thanks for the document, it is very informative.