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 greatly enhance runtime performance for certain scenarios, tested with BW 7.4 SP10 on HANA Revisions 85.02, 97.02 and 102.02.
Read more on: http://scn.sap.com/community/bw-hana/blog/2015/12/23/sap-hana-sql-execution-performance
#zpartner Bernhard interessanter Blog über SAP HANA – SQL Execution Performance. http://scn.sap.com/community/bw-hana/blog/2015/12/23/sap-hana-sql-execution-performance
Posted by ZPARTNER on Mittwoch, 30. Dezember 2015