Category Archive for: BWBLOG

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 →

Stefan Witteck hat seine S/4HANA Demo21. Ein Zertifikat für den abgeschlossen Kurs S/4HANA Demo 21.

ZPARTNER (Stefan Witteck) hat seine S/4HANA Demo21 erfolgreich aufgesetzt

#zpartner hat nun mit der #S/4HANA Demo21 eine super Sandbox zum Testen und Implementieren von neuen Ideen. SAP-ZPARTNER-DEMO21-CONFIRM

RSEC*-Tables and IO AUTH_HASH.


Old or Pre BW 7.4 Database-Tables for Hierarchy Entries within Authorizations RSECHIE Status of Authorization Hierarchies RSECHIE_CL Authorization Hierarchies Changes Change Log Database-Table after Upgrade to BW 7.4: All newly created Hierarchy Authorizations will be saved within this new table. RSECHIE_STRING Status of Authorization Hierarchies Old or Pre BW 7.4 Database-Tables for Value Entries within…

Read More →

Alternative Usage of RSDG_TRFN_ACTIVATE

Alternative Usage of RSDG_TRFN_ACTIVATE

Stefan Witteck hat einen neuen Blog gepostet, welches das BW-Leben erheblich erleichtern kann:

Technical content BEx 7.x.

Enhance technical content with BEx 7.x Bookmark calls

The scope of the document is to show a possible way to track BEx 7.x Bookmark execution and integrate the results into the technical content. Integration is done with the help of quite new SAP BW objects, like Open ODS View or Composite Provider. Tracking bookmark execution could be very helpful in case of housekeeping…

Read More →

BW system restore and one way to save the delta from source systems

This blog can help you to save the delta in case of a system restore. Read the full blog on SAP SCN: What happened? The productive BW system of one of our clients had a serious problem. Some tables (SID tables of several central InfoObjects) were deleted directly from the database and could not…

Read More →

Back to Top