Skip to Content
Technical Articles

SAP First Guidance Collection for SAP BW on HANA

SAP First Guidance Collection


The First Guidance documents is a Serie of documents that should help to better understand the end to end usage of SAP BW powered by SAP HANA and BW/4HANA. The documents are still “work in progress”, so these guides are not intended to be exhaustive.

Furthermore the SFG Documents deliver additional information besides SAP Help and SAP Blogs to better understand the implementation aspects of SAP BW on and for SAP HANA.

Replacement of the retired “SAP HANA Cookbook”: End-to-End Implementation Roadmap for SAP BW

This document provides a central starting point for planning the technical implementation of SAP Business Warehouse (SAP BW) running on the SAP HANA database. It specifies what needs to be considered when deploying SAP BW on the SAP HANA database. It also provides an end-to-end view of recommended implementation scenarios, outlines the steps required for implementation and guides you to more detailed information on the processes you need to complete the necessary tasks. See also the Customer Adoption Journey Map

SAP First Guidance – SAP BW on SAP HANA Installation/Systemcopy/HANA Revisions

This Document also reflects the released SAP HANA SP/Revisions so far and also contains details for selected HANA Revisions and the usage together with SAP BW.

This SAP First Guidance Document simplifies the existing Document to the current Version of SAP BW (7.50), SAP HANA (SP12, Rev. 122.x) and software provisioning manager (SWPM 1.0 SP2x). Furthermore the Instance Profiles reflecting the SAP Kernel 7.40 updates as well.
We call this – SAP First Guidance – SAP BW on HANA – Edition 2017

On base of this information this “SAP First Guidance” document is released to support Basis administrators in running and configuring a Business Warehouse on a SAP HANA system. SAP First Guidance – Business Warehouse on SAP HANA installation provides answers to major questions and issues as well as workarounds and additional details to complement standard SAP Guides and SAP Notes. This SAP First Guidance document has no claim of completeness, but it is the most complete starting point for a successful implementation.
For more information please contact

SAP First Guidance – complete functional scope (CFS) for SAP BW 7.50

SAP BW powered by SAP HANA was the very first SAP application that ran completely on top of SAP HANA and has meanwhile reached a great adoption. Customers will benefit not only from performance improvements for data load, query runtime and planning functions but also in simplified data modeling as the number of InfoProviders are highly reduced and all modeling is done within in a new, modern UI that is unique across all modeling tools.
This SAP First Guidance Document put´s is emphasize to the complete functional scope (CFS) to ensure the full functionality right from the start of the Implementation of SAP BW 7.50 SP04 and higher. For more information please contact

SAP First Guidance – complete functional scope (CFS) for SAP BW/4HANA

SAP BW/4HANA is a new SAP product that replaces SAP Business Warehouse in a logical way. BW/4HANA runs only on HANA platform, and will be the foundation for a new lineage of data warehousing solutions from SAP.

Furthermore it optimizes and simplifies a customer’s BW environment and experience (similar to S/4HANA). BW/4 HANA 1.0 (DW4CORE) is a new code-line on which all future BW enhancements will take place. Classic BW goes into maintenance mode.
This SAP First Guidance Document put´s is emphasize to the complete functional scope (CFS) to ensure the full functionality right from the start of the Implementation of SAP BW/4HANA 1.0 SP00 and higher. For more information, contact

New: This SAP First Guidance Document concludes the necessary Steps to implement SAP BW/4HANA to the Azure Cloud and also considers the additional tasks to connect the on-premise Systems to the Cloud Infrastructure.

SAP First Guidance – Implement SAP BW/4HANA in the Azure Cloud 

SAP First Guidance – Using the new DMO to migrate to BW on HANA

The database migration option (DMO) is an option inside of the software update manager (SUM) for combined update and migration: update an existing SAP system to a higher software release and migrate to SAP HANA database in one technical step. As the technical SUM steps are the same, this “SAP First Guidance” document should make all customer-specific documentation obsolete. It is the complementary documentation to the existing Notes and SUM/DMO Upgrade Guides.

DMO can be used with every BW Release starting from 7.0x and onwards. It makes the two step approach (upgrade/migration) and the usage of the BW post copy automation (BW-PCA) obsolete. It can also be used within a Release, e.g. to go from 7.40 SP06 on anyDB to migrate to 7.40 SP07 on HANA. For more information please contact

 SAP First Guidance – Implementing BW-MT as the new SAP BW Modeling Experience

SAP BW 7.4 SP08 powered by SAP HANA is the next milestone for enterprise data warehousing with BW on HANA and provides the next level of simplification for BW .In addition, SAP BW on HANA Virtual Data Warehouse capabilities have been enhanced for even more flexibility. In midterm the advanced DSO shall replace the main BW InfoProviders with persistency (InfoCube, DSO, and PSA). The classic InfoProviders are of course still supported and do co-exist with the advanced DSOs. For more information, please contact

SAP First Guidance – SAP NLS Solution with SAP IQ

This “SAP First Guidance” document provides all the necessary information to help quickly implement this newly released option: Store historical BW data on an external IQ server to optimize the system size when preparing to migrate to SAP BW powered by SAP HANA. The SAP NLS solution with Sybase IQ also helps to keep down the TCO for investing in the SAP In-Memory when historical (“frozen”) data is stored on a less sophisticated device, which acts like a “BW Accelerator on Disk”. SAP Sybase IQ is therefore the perfect smart store for this kind of data. Please note that the SAP NLS solution can be used with all database versions supported by SAP BW 7.3x. SAP HANA is not necessary. The document is a “work in progress” and is not intended to be exhaustive.  It does however contain all information required for successful implementation of the SAP-NLS solution with Sybase IQ. SAP-NLS can be used with every SAP supported database, where SAP IQ will be the secondary database for data reallocation.
For more information, please contact

New: SAP First Guidance – combining SAP-NLS with the PBS NLS Add-On

The SAP-NLS solutions offers core functionalities for the usage of the SAP IQ database for the storage of historical data, despite if you are using SAP HANA or any other supported RDBMS together with SAP BW.
However, when it comes to the implementation several functionalities are not delivered by SAP itself, as by the development Partner PBS. Furthermore, some of the additional capabilities developed sine Q1/2013 are only available with the latest SAP BW Releases 7.40/7.50. This is where the additional capabilities from the PBS NLS Add-On come into place as almost all of them are available from SAP BW 7.0x onwards.

 SAP First Guidance – SEM/BW Modelling in SolMan 7.1 with MOPZ

Due to constant Questions about the Upgrade to NetWeaver 7.3x and 7.40 including SEM Add-On Components, we created a SAP First Guidance Document which describes the successful Definition of a SAP BW 7.0/7.01 System with the SEM Add-On Installed on top.  With this Information you will be able to integrate the stack.xml in the SUM (software update manager) process and the DMO (database migration option) DMO process included in SUM as the first input is the location of the stack.xml which defines the download directory for SUM. Furthermore the interaction of the stack.xml in the upgrade process enables you a smooth Integration into the Upgrade Process included in DMO. For more information please contact

SAP First Guidance – BW Housekeeping and BW-PCA

The system copy procedure of SAP BW systems and landscapes is complex for a number of reasons. There is a large number of configuration settings (such as connections and delta queue handling for data loading) and system copy scenarios of SAP BW (each with different landscape aspects).  These have to be handled as part of every system copy, regardless of whether the system copy is part of the migration to SAP HANA or if you want to perform regular system copies of your SAP BW landscape. BW-PCA can be used from SAP BW 7.0 onwards depending on the SPS level.

Additionally see the usage and implementation of the BW Housekeeping Task List and the Pre/Post Task Lists for Upgrade/Migration. These are Included in the database migration option (DMO) as part of the software update manager (SUM). Additional Details also can be found on the BW ALM Page. For more information please contact


the second part of the SAP First Guidance Collection for Application Specific Topics can be found here – SAP First Guidance Collection for SAP BW powered by SAP HANA

This Page is a part of the Blog – Software Application Lifecycle Management for SAP BW

Roland Kramer, SAP Platform Architect for Intelligent Data & Analytics

You must be Logged on to comment or reply to a post.