Share the Knowledge – 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:

To learn more about migration, check the below document:

SAP NetWeaver BW on SAP HANA Project Approaches – Webinar Presentation

Upgrade and Migration – BW on HANA | SAP HANA

Upgrade / Migration – General | SAP HANA

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

Best Practice # 3: Check 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 perform

Once the checklist is completed you get the below screen:

To learn more about the checklist tool, check the 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”

Check the below blog to learn more about it:

How to Check whether a Planning Function or a Disaggregation in PAK is executed in Memory

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

Go to Sizing tab

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

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:

How NOT to size a SAP NetWeaver BW system for SAP HANA

How To Size SAP BW on HANA | SAP HANA

Sizing | SAP 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

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/300347b5-9bcf-2d10-efa9-8cc8d89ee72c?overridelayout=t…

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

Data Management with SAP NetWeaver BW powered by SAP HANA in the SAP Real-Time Data Platform  – Webinar Presentation

SAP BW Near-Line Storage (NLS) Implementation f… | SCN

SAP First Guidance – SAP-NLS Solution with Syba… | SCN

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

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 the most common activities are:

To learn more about Housekeeping activities, check the below document:

House Keeping / Performance Tuning Activities in SAP BW Systems — PART 1

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:

Create #SAP #BW Housekeeping task list

Also check the below document:

Important Housekeeping Principles for keeping your SAP NetWeaver BW in good shape – Webinar Presentation

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

OLAP Statistic Deletion

For cleaning Large tables, check SAP Note 706478 – Preventing Basis tables from increasing considerably

Thanks for reading my blog.

Regards,

Vivek