Login

Bookmarks

BW on SAP HANA Cookbook

This cookbook provides recipes for success when migrating your business warehouse (BW) to the SAP HANA® database. It contains an overview of the SAP HANA platform, how it can impact your business information, hands-on step-by-step guidance through the data migration process, a guide to day-to-day system operations, and an introduction to the tools and techniques needed to get the most from your data models.

BW on SAP HANA Overview

An introduction to core concepts of SAP HANA in-memory computing, and how these concepts can help your SAP NetWeaver 7.3 Business Warehouse (BW) run better. We also consider some of the technical implications of upgrading your current data warehouse to version 7.3, and of migrating it to the SAP HANA database. Lastly, we cover what you might expect during the process of transitioning to this new technology.

Deploying BW on HANA Step-by-step migration

Starting with SAP NetWeaver 7.3 SPS05 and SAP HANA SPS03, you can replace the relational database underlying your SAP Business Warehouse (BW) system with the SAP HANA database.
This procedure involves migration of your existing SAP NetWeaver Business Warehouse data to the SAP HANA database, with no disruption to existing Business Warehouse content or processes. After data migration, BW simply uses HANA as the underlying database.

Operating HANA HANA administration and BW

Once you have the SAP HANA appliance software up and running, you will have to perform the same kinds of system administration tasks required of any system. SAP offers tools designed and developed especially for the HANA platform. You will need to download, install, learn and use these to support this addition to your system landscape.
Here we review how you license, configure, monitor and troubleshoot the SAP HANA appliance. We also cover updating and patching software, backup and restore, and user authentication, as well as system expansion and availability.

Modeling BW Data Optimizing your data models

Your current SAP Business Warehouse data models need not change to run on SAP HANA. But, to bring out the best in BW on SAP HANA, you will want to work with your data models to take full advantage of the HANA appliance software.
This section covers two important aspects of migrating your data to BW on SAP HANA:

• Changes to your current BW models that will get the most out of the SAP HANA database
• Basic principles and guidance for the creation of new HANA data models