Category Archive for: BWBLOG

BW Modeling Tools.

How to create transitive navigation attributes in BW Modeling Tools

Introduction In traditional BW, modeling of transitive attributes (attribute of attribute) has been quite time consuming and also led to duplication of data, see explanation here. Transitive attributes – as an out-of-the-box feature – have been introduced in the BW Modeling Tools InfoObject editor with BW 7.5 SP4. Here you can simply enable the required…

Read More →


Which road to take to BW/4HANA?

Introduction BW/4HANA is available now for more than 2 years and I got the feeling that more and more BW users are starting to think how to get there. If you do not start from scratch with BW then the process to BW/4HANA from any previous BW release is a completely new experience since it…

Read More →

Change/create Infoobjects with RSD.

How to change/create Infoobjects with RSD1 as of BW 750 SP11 on HANA and BW/4HANA as of SP8

Introduction Before SAP BW 750 SP 11 it was possible to edit/maintain InfoObjects in RSD1 with the help of value nohdb in ok-code (see . This was switched off with SAP BW 750 SP11. In some cases, it could be helpful to change InfoObjects (for instance if you want to edit Master Data Read…

Read More →


ZPARTNER S/4HANA Demo21 mit SAP Analytics Cloud Integration

Hannes Kröner und Stefan Witteck haben zusammen erfolgreich die S/4HANA mit SAP Analytics Cloud Integration aufgesetzt. Gratulation und vielen Dank für den Einsatz!

HDB modeling in WebIDE.

HDB modeling in WebIDE – and why we are staying in HANA Studio for the time being

We are working with lots of mixed-scenarios, meaning that our data is stored in BW and exposed as Calculation Views for further HANA native processing. When we became aware that HANA modeling is moving away from HANA Studio and into Web IDE for SAP HANA with quite some new features, we were excited at first.…

Read More →

SAP HANA Exit Variables.

Usage of SAP HANA Exit Variables for a standard reporting scenario

The scope of the document is to show how SAP HANA Exit variables are working for column selection for standard YTD reporting and delta calculation using native SQL. As a result the native SQL statements on generated calculation views work nearly similar as a SAP BW Query. By using HANA Exit variables the Query can be…

Read More →

SAP BW Hierarchien mit D3.js

SAP BW Hierarchien mit D3.js und BSP im ZPARTNER Style

Holger hat sich mal überlegt die Darstellung von SAP BW Hierarchien im grafischen Sinne ein wenig zu optimieren. Dabei ist ein kleines Framework zur Darstellung von SAP BW Hierarchien mit D3.js und BSP geworden. Per URL Parameter wird die Hierarchie übergeben. Danach kann der User grafisch durch die Hierarchie navigieren – komfortable, schnell und grafisch…

Read More →

Master Data Management.

Master Data Management with BPC Embedded

Requirement A typical requirement within a BW Project might be to offer Master Data Maintenance to End Users. E.g. to maintain specific global BW hierarchies. Overview of Possible Approaches In the following figure a comparison between different approaches can be found. Within the next chapter we will go into the details of the BPC Embedded…

Read More →

SQL statements for HANA.

HANA Views & SQL – Technical Performance Optimization

BW on HANA can easily enable SQL data access for third party tools, using the “External SAP HANA View” flag to automatically generate Calculation Views out of BW objects. However, Consuming multidimensional BW scenarios through relational SQL paradigm can lead to quite some issues with performance. This blog is about a few basic technical tips,…

Read More →

InfoObjects with RSD1.

How to change/create InfoObjects with RSD1 as of BW 7.5 SP4 on HANA?

Introduction InfoObject maintenance in the BW Modelling Tools (BW-MT) was made mandatory starting with SAP BW 7.5 SP4 on HANA. Since then it is not possible to maintain/create InfoObjects from the SAP GUI using the transaction RSD1. Displaying though still works. This change surprised the one or the other as this is the first existing…

Read More →

Back to Top