Skip to Content
Author's profile photo Michaela Pastor

SAP How-to Guides for SAP Business Warehouse powered by SAP HANA

How to-Set Up Hana Datasource (SDI)

This paper describes the SAP HANA Smart Data Integration capabilities and see how they can be leveraged within SAP BW based on the new SAP HANA Source system available with BW 7.5, Open ODS Views, CompositeProviders and Advanced DataStore Objects.

The SAP HANA Source System is the new simplified and unified source system connection to SDI, SDA and local SAP HANA sources with the SAP HANA Source system in BW.

The paper is based on an example on the Twitter Adapter which is only one adapter of many other possible adapters.

How to Create Dynamic Analytic Privileges in SAP HANA Based Upon Analysis Authorizations in SAP BW

This paper intends to describe a holistic solution for creating dynamic analytic privileges in HANA with filters based upon lookup procedures referring to a simple Authorization Model that exists and is maintained within BW.

How to Consume SAP HANA Models in SAP NetWeaver BW from Remote HANA Instances

This paper’s focus is the use case when BW consumes the data or information models of a remote SAP HANA system (e.g. standalone/native SAP HANA, Accelerator). Read about loading the data from HANA into BW via ODP (Operational Data Provisioning) and a direct access solution leveraging the BW VirtualProvider (modeling options for direct access). The BW system could be running on any database.

How To…Realize Easy In-Cell Calculations in SAP BusinessObjects Analysis for Office

SAP BusinessObjects Analysis for Office can be used as an Excel planning front end (in conjunction with BW-IP or PAK). When planners change their plan data they do not only want to enter the absolute number in the systems. Sometimes they want to raise the value in a certain cell by say 10% or want to raise the existing value by a certain increment. As PAK and BW-IP expect absolute numbers the user has to calculate the number in a little side calculation. In this paper we show how a simple solution can be realized where the planner can enter a simply formula and apply this to one or several cells in the worksheet. This functionality is often referred to as ‘pocket calculation’.

How to… Log Changes in Plan Data when using the SAP NetWeaver BW Planning Applications Kit

In the How to Paper – Log Changes in Plan Data Using DataStore Objects (see we have given an example how to use the Logging BAdI in SAP NetWeaver BW-IP.  This paper is building on this How to Paper and describes how the logging functionality can now also be used in conjunction with HANA and the Planning Applications Kit (in memory planning on SAP NetWeaver BW).

How To.. Consume HANA Models with Input Parameters in BW Virtual Providers
Input Parameters in SAP HANA Models enable user-specific parameterization of the model execution. This paper describes how such models can be consumed in SAP BW (using the VirtualProvider interface) thereby allowing BW Users to provide inputs to the models at runtime.

How-To…  Efficiently Prune SAP NetWeaver BW Queries
Query Pruning helps to optimize reading access for reporting scenarios in SAP BW. This guide will touch on existing techniques of query pruning and dive deeper into the new PartProvider Pruning possibilities mainly introduced with SAP BW 7.30 SP8, as well special treatments for SAP BW 7.30 on HANA.

How-To… SELECT in SAP BW transformations
Read about efficient approaches to use SELECT statements in transformation in SAP NetWeaver BW. The presented examples are valid for SAP BW 7.30 on HANA as well as for other database environments and later releases. Furthermore, conclusions and tips especially for SAP HANA as database and also SAP BW 7.30 are given.

How-To… Delta Merge for SAP HANA and SAP NetWeaver BW powered by SAP HANA
Get an overview of the SAP HANA delta merge process and the specific operations that affect applications such as SAP BW powered by SAP HANA.  In addition this HTG provides further insight for: Updating the column store – Delta merge concept – Delta merge process – Monitoring the merge process – Configuring the merge process – Implications for applications like SAP BW powered by SAP HANA.

How-To… Use the Enhancement framework for BW User Exits
When using BW, you will always be required to implement one or more enhancements. Some of these are a one-off enhancement. This means that one project can not easily be seperated and cross locking of the same object might occurs in the project. This “How-to” supplies an approach that uses the enhancement builder (SE18/SE19) to build a framework that enables you to create custom user exit variables and DataSource enhancements using the new BADI concept.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Vincent Ong Kok Wee
      Vincent Ong Kok Wee

      Nice compilation of the "How to"

      Author's profile photo Oscar A. Sánchez
      Oscar A. Sánchez

      Thank you Michaela, nice post.

      But what about Inventory Management and BI Administration Cockpit and Technical Content. The old post are not working anymore due to the repository migration. Are there any new How to's for these topics

      Best regards