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

Regards,

Vivek