How to improve the performance of your SQL functions
- Sebastian
- 04.05.2023
- SAP HANA SQL
While other tools check the performance of the execution, i.e. the result of the written code, SQLScript Code Analyzer is used to check the code itself. This tool can be ...
More
SQL Performance Analysis with SAP PlanViz
- Sebastian
- 27.04.2023
- SAP HANA SQL
In our first post, Performance analysis and optimization of SAP SQL, we presented different approaches to performance analysis of SQLScript. While the EXPLAIN PLAN ...
More
Performance analysis and optimization of SAP SQL
- Sebastian
- 20.04.2023
- SAP HANA SQL
There are several ways to analyze SQLScript performance. In this article you will learn about the relevant tools. We will show you how to measure the runtime of your SQL ...
More
SQLScript Performance Tips
- Sebastian
- 26.01.2023
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
Performance is one of the main arguments for using SQLScript. With the introduction of the HANA database, SAP has introduced the "code pushdown" concept. With this new ...
More
Handling account & key figure model in SAP HANA SQLScript & CalcView
- Irvin
- 03.02.2022
- SAP HANA SQL
In this blog post, we look at several variants for transforming or pivoting/unpivoting a dataset between the account model and the key figure model. For this purpose, we ...
More
Generation of SQLScript for SAP AMDP transformations with ABAP
- Steven
- 20.01.2022
- SAP HANA SQL, SAP BW
Since SAP Release 7.40 SP05, BW transformations can be executed directly on the SAP HANA database if no ABAP routines are used. The use of SQLScript transformations can ...
More
Hana SQL DWH vs SAP BW vs Mixed Scenario - Quick Guide -
- Irvin
- 14.10.2021
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
Traditionally, the SAP Business Warehouse (BW) is the Data Warehouse (DWH) solution of choice. For companies with an SAP ERP system, this is the most obvious solution ...
More
How to use Window Functions in SQLScript
- Irvin
- 16.09.2021
- SAP BW/4HANA, SAP HANA SQL
In this article, we first define the term window function and describe how they work. Then we analyze the syntax elements of this function group and combine the shown ...
More
How to improve the performance of your SAP HANA database
- Chris
- 10.06.2021
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
Without a doubt, our daily lives become increasingly data-driven and the amount of data is continuously increasing every day. Thus, the amount of data that is generated ...
More
How to use IF ELSE statements in SAP HANA SQLScript
- Chris
- 12.05.2021
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
In the previous article, "CASE in SAP HANA - Control flow for SQLScript Transformation Routines", you learned that IF ELSE constructs are not possible within a SELECT ...
More
Subscribe our newsletter
Recent Posts
Posts by Tag
- SAP Analytics Cloud (46)
- SAP BW/4HANA (42)
- Machine Learning (40)
- Dashboarding (37)
- SAP HANA SQL (23)
- SAP HANA (22)
- SAP Planning (22)
- NextTables (17)
- Apache Airflow (14)
- Datasphere (10)
- Master Data & Data Import in SAP BW (9)
- NextTables Use Cases (9)
- SAP BW (9)
- SAP Lumira Designer (9)
- Tableau (8)
- Value Driver Tree (8)
- SAP Data Warehouse (7)
- SAC Application Designer (5)
- SAP Connector (4)
- Green AI (3)
- Power BI (3)
- RSADMIN (3)
- SAC Story (3)
- SAP Data Intelligence (3)
- project methodology (3)
- Bookmarks Lumira Designer (2)
- Introduction to Machine Learning (2)
- Projektmethodik (2)
- career (2)
- Airflow (1)
- SAP Partner (1)
- Visual Bi Extensions (1)