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,…
Kategorie: BWBLOG
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…
#zpartner hat nun mit der #S/4HANA Demo21 eine super Sandbox zum Testen und Implementieren von neuen Ideen. SAP-ZPARTNER-DEMO21-CONFIRM…
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…
Stefan Witteck hat einen neuen Blog gepostet, welches das BW-Leben erheblich erleichtern kann: http://scn.sap.com/docs/DOC-74131…
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…
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…
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…
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…
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…