Jan 12, 2015

Optimizing SAP BW on SAP HANA Part 1

Optimizing SAP BW on SAP HANA Part 1


Hi Everyone,

During the TechEd I attended lecture RDP303 - "Master Class for Optimizing SAP Netweaver Business Warehouse on SAP HANA"
It was only a 1 hour session but there were many things to learn.
The session was aimed at Optimizing SAP BW on SAP HANA and best practices to be followed
I would like to share learning from the session.

Also check Part 2: Share the Knowledge - Optimizing SAP BW on SAP HANA Part 2

Best Practice #1: Master The Basics and Understand the Path to BW on HANA

The session started with migration options for implementing BW on HANA
There are three options available for implementing BW on SAP HANA and they have their own advantages and disadvantages as shown below:
Capture1.JPG
To learn more about migration, check the below document:

Best Practice #2: Know the Tools That Do the Work For You

After that we were told about BW Migration Cockpit for SAP HANA tool that can  be used for migration and a demo was shown for it
Check SAP Note 1909597 - SAP NetWeaver BW Migration Cockpit for SAP HANA for this and install attached ABAP program - "ZBW_HANA_MIGRATION_COCKPIT"
Once you have installed the program and you execute it, you get the below screen
Checking.JPG
Best Practice # 3: Ch eck Your BW System : Before and After Migrating to SAP HANA

The first tab is checking
It has three main tools "Checklist Tool", "Consistency Checks" and "Planning Function Check"
Checklist Tool automates the check of best practice guidelines for operations and pre-requisites for migration of an existing SAP NetWeaver
BW deployment to the SAP HANA platform.
Once you click on checklist tool, the below screen appears and you can select which all checks you want to perfo rm
Checking1.JPG
Once the checklist is completed you get the below screen:
Checking2.JPG
To learn more about the checklist tool, check th e SAP Note 1729988 - SAP NetWeaver BW powered by SAP HANA - Checklist Tool
Planning Function Check tool determines whether planning functions are executed in ABAP or in SAP HANA
It uses program RSPLS_PLANNING_ON_HDB_ANALYSIS and it should be installed in your system otherwise you will see the below screen stating "Program RSPLS_PLANNING_ON_HDB_ANALYSIS does not exist"
Checking3.JPG
Check the below blog to learn more about it:

Best Practice # 4: Size Your BW System  Using a Fully Automated Sizing Tool

Go to Sizing tab
Sizing.JPG
In this tab, we can determine memory requirements for SAP HANA using the Sizing tool, can configure NLS, set up Data Archive Process and execute Data Archiving process
Capture2.JPG
To learn more about sizing, check SAP Note 1736976 - Sizing Report for BW on HANA
Also check the below blog on Sizing BW on HANA:

Best Practice # 5: Lower TCO by Leveraging  Non-active Data Concept and Off-loading Data to  Near-line Storage (or Archive)

As we all know that non-active data concept was introduced for BW on HANA last year

Non active tables are loaded into RAM only when they are accessed and are displaced from the RAM with highest priority in case of RAM shortage
In BW on HANA, PSA tables and Write Optimized DSO tables are automatically marked as "Non-Active"

To learn more, check the SAP Note 1767880 - Non-active data concept for BW on SAP HANA DB
After that we were told a bit about Near Line Storage with Sybase IQ
To learn more about it, check the below documents
Also check SAP Note 1796393 - SAP BW near-line solution with Sybase IQ

Best Practice # 6: Keep Your System Lean and Fast by Performing Housekeeping Task Regularly

Go to Housekeeping tab
HouseKeeping.JPG
As we all know Housekeeping activities are an integral part of BW as they ensure optimum utilization of system resources and increase system performance
Some of t he most common activities are:
Capture4.JPG
To learn more about Housekeeping activities, check the below document:
We can set automated Housekeeping using Task Manager and use "Housekeeping Tasks"
Check SAP Note 1829728 - BW Housekeeping Task List to generate a a task list with several common tasks associated with housekeeping/upkeeping an BW system
We can also extend this task list
Check the below document on how to install Housekeeping task list:
Also check the below document:
For Task Manager Configuration, check SAP Note 1589145 - Task Manager for Technical Configuration

We can also perform few housekeeping tasks manually present in the cockpit as shown above, such as
IDoc Archiving
Idoc.JPG
OLAP Statistic Deletion
BWStatic.JPG
For cleaning Large tables, check SAP Note 706478 - Preventing Basis tables from in creasing considerably

No comments: