Whitepaper: Performance Boost with SQLScript
Read our whitepaper to learn when it makes sense to make the switch and what pitfalls you need to avoid.
Shaping Business Intelligence
About us
Our Methodology
Data Science & Engineering
SAP Planning
Dashboarding
Over the last few years, the data volume in SAP systems has multiplied. And while the amount of information to be stored continues to grow exponentially, performance is becoming increasingly important. If you use customer-specific logic in a SAP HANA Data Warehouse, SAP BW on HANA (from version 7.5) or SAP BW/4HANA system, SQLScript can provide help.
You can use SQLScript in transformations, customer exits and BAdIs as well as HANA Analytic Views to benefit from enormous performance increases. In real life projects we have experienced cases with up to 15x faster runtime. Since the calculations are executed directly on the database level ("code to data" approach), you don't have to wait until the data is loaded. You can concentrate directly on implementing the knowledge gained and thus gain a competitive advantage.
Using SQLScript in your business logic allows you to fully exploit the potential of your HANA database. The calculations are executed directly in the database without loading the data into the application layer first. This way you can benefit from up to 15 times better runtime!
Don't wait any longer for the data to be loaded, make decisions! Because of the enormous speed advantage, you can focus on data analysis, gaining new insights and getting results instead of waiting for data to be processed.
Don't waste time waiting, but use the latest insights before competitors do. Take advantage of SQLScript to consolidate and expand your market position and increase existing competitive advantages.
The launch of the HANA database led to a paradigm shift in data processing. In order to fully exploit the advantages of the new database, SAP relies on the "Code Pushdown" concept. This involves transferring calculations involving large amounts of data to the database level. This prevents unnecessary data transfers from the database to the ABAP server. Instead, calculations are performed directly in the SAP HANA database, where the data is stored. The code thus is brought "to data" (so-called "code to data" approach). This saves a lot of time, especially with data-intensive calculations.
In a previous article, "SAP Datasphere Command Line Interface as Project Accelerator", we presented...
SAP Datasphere offers several ways to prepare data. For example, you can use views to combine local...
The most elementary requirement of SQLScript Code is that it works correctly. That already given,...
» Apr 1, 2024 Test automation with SQL in SAP Datasphere
» Sep 19, 2023 SAP Datasphere: SQL or Graphical Views? Making an educated decision
» Jun 13, 2023 Tips for readable SQLscript code
» May 2, 2023 How to improve the performance of your SQL functions
» Apr 27, 2023 SQL Performance Analysis with SAP PlanViz
More Blogs» Apr 1, 2024 Test automation with SQL in SAP Datasphere
» Sep 19, 2023 SAP Datasphere: SQL or Graphical Views? Making an educated decision
» Jun 13, 2023 Tips for readable SQLscript code
» May 2, 2023 How to improve the performance of your SQL functions
» Apr 27, 2023 SQL Performance Analysis with SAP PlanViz
+