SAP BW BLOG

Unsere Blogs rund um SAP BW und HANA

  • Which road to take to BW/4HANA?

    06 Nov 0 Comments

    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 →

    Read More →

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

    17 Okt 0 Comments

    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 https://www.zpartner.eu/how-to-changecreate-infoobjects-with-rsd1-as-of-bw-7-5-sp4-on-hana/) . 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 →

    Read More →

  • ZPARTNER S/4HANA Demo21 mit SAP Analytics Cloud Integration

    10 Aug 0 Comments

    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!

    Read More →

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

    18 Jun 0 Comments

    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 →

    Read More →

  • Usage of SAP HANA Exit Variables for a standard reporting scenario

    04 Okt 0 Comments

    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 →

    Read More →

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

    01 Sep 0 Comments

    Holger hat sich mal überlegt die Darstellung von SAP BW Hierarchien im graphischen 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 graphisch durch die Hierarchie navigieren – komfortable, schnell und graphisch ansprechend.…

    Read More →

    Read More →

  • Master Data Management with BPC Embedded

    28 Jul 0 Comments

    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 compoarison between different approaches can be found. Within the next chapter we will go into the details of the BPC Embedded…

    Read More →

    Read More →

  • HANA Views & SQL – Technical Performance Optimization

    07 Jul 0 Comments

    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 →

    Read More →

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

    03 Apr 0 Comments

    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 →

    Read More →

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

    03 Feb 0 Comments

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

    Read More →

  • RSEC*-Tables and IO AUTH_HASH

    01 Sep 0 Comments

    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 →

    Read More →

  • Alternative Usage of RSDG_TRFN_ACTIVATE

    14 Jul 0 Comments

    Stefan Witteck hat einen neunen Blog gepostet, welches das BW-Leben erheblich erleichtern kann http://scn.sap.com/docs/DOC-74131

    Read More →

  • Enhance technical content with BEx 7.x Bookmark calls

    29 Jun 0 Comments

    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 →

    Read More →

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

    04 Apr 0 Comments

    This blog can help you to save the delta in case of a system restore. Read the full blog on SAP SCN: http://scn.sap.com/community/data-warehousing/bw/blog/2014/01/20/bw-system-recovery-and-one-way-to-save-the-delta-from-source-systems 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 →

    Read More →

  • Comparison of SAP BEx Query Designer and eclipse BW Modeling Query

    12 Feb 0 Comments

    Comparison of SAP BEx Query Designer and eclipse BW Modeling Query This blog tells you about the differences between SAP BEx Query Designer and the eclipse based BW Query on BW 7.4 and should help you to understand how query design works with the eclipse based BW-Query if you have worked long time with the…

    Read More →

    Read More →

  • SAP HANA – SQL Execution Performance

    30 Dez 0 Comments

    BW can effortlessly expose data for external consumption e.g. by a third party tool, using the checkbox “External SAP HANA View”. Those automatically generated Calculation Views which are based on Composite Providers or even BW Queries are usually quite complex, so SQL access will probably perform poorly. This blog is about two parameters which can…

    Read More →

    Read More →

  • SAP HANA – Advanced DSO Features

    16 Jul 0 Comments

    This blog post describes the features of ADSO’s and how to use them. View details on http://scn.sap.com/community/bw-hana/blog/2015/07/10/sap-hana–advanced-dso-features SUMMARY Our experience with Advanced DSO’s is good; we did not encounter severe problems. Everything worked after we gain the knowledge how to use it. thx 2 mario

    Read More →

  • SAP HANA Security – Create Roles and Privileges from BW System in SAP HANA

    23 Jun 0 Comments

    This blog post explains how to create roles with privileges for SAP HANA Studio from BW for DBMS profiles in order to give the users the possibilities to see views on generated SAP HANA BW content (like calculated views generated out of new composite provider and SAP BW queries 7.4). View details on http://scn.sap.com/community/bw-hana/blog/2015/06/19/sap-hana-security-create-roles-and-privileges-from-bw-system-in-sap-hana thx…

    Read More →

    Read More →

  • Key figure selection in variable screen

    19 Jan 0 Comments

    If there is a requirement to restrict the key figures in the variable screen of a BEx Query, you have to work with some sort of workarounds ( formula variables, zero suppression and so on). With BW 7.4 SP8 another option is now available. It is called Visibility of Structure Members. Once activated a new…

    Read More →

    Read More →

  • Hierarchical Display of Calculated and Restricted Key Figures in BEx Query Designer

    19 Jan 0 Comments

    Calculated (CKF) and restricted (RKF) key figures are often used in BW mainly for re-usability and maintenance reasons. However, the handling in the Query Designer is not optimal in case of huge  number of CKF or RKF. Finding a certain CKF/RKF can be tedious and very time consuming. Using the sorting might help, but typically…

    Read More →

    Read More →

Back to Top