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…
Kategorie: BWBLOG
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…
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…
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…
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…