Feb 12, 2015

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

Via Content in SCN

Hi Everyone,


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
M.JPG

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:
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
CHC.JPG
Run Table Consistency check
   TC.JPG
Run Delta Merge Check
DM.JPG
To learn more about Delta Merge process, check the below document:
Also check SAP Note 1663501 - Log for BW merge trigger

Check if Secondary indexes are required to be created
SD.JPG
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
IP.JPG
Optimize Data Flows: Convert 3.x Data Flows to 7.x Data Flows
DF.JPG
For migration, also check the below link:

Optimize InfoProviders: Conver Infocubes to HANA Optimized Infocubes
OC.JPG

Learn more about InfoProviders in BW on HANA:
Also check SAP Note 1849497 - SAP HANA: Optimizing standard DataStore objects

Optimize Data Layers:
LA.JPG
To learn more about LSA++, check the below documents:

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
RA.JPG
To learn more about ABAP Code optimizzation for SAP HANA, check the below documents:

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: