Test automation with SQL in SAP Datasphere
- Irvin
- 04.04.2024
- SAP HANA SQL, Datasphere
In a previous article, "SAP Datasphere Command Line Interface as Project Accelerator", we presented various ways in which you can use the SAP Datasphere command line ...
More
SAP Datasphere: SQL or Graphical Views? Making an educated decision
- Dimitrios
- 21.09.2023
- SAP HANA SQL, Datasphere
SAP Datasphere offers several ways to prepare data. For example, you can use views to combine local or remote tables and other views. This allows you to link, filter and ...
More
Tips for readable SQLscript code
- Irvin
- 15.06.2023
- SAP HANA SQL
The most elementary requirement of SQLScript Code is that it works correctly. That already given, we must ensure readability, transparency and maintainability of our ...
More
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
Subscribe our newsletter
Recent Posts
Posts by Tag
- SAP Analytics Cloud (66)
- Machine Learning (54)
- Dashboarding (50)
- SAP BW/4HANA (44)
- SAP Planning (33)
- NextTables (30)
- SAP HANA SQL (26)
- Apache Airflow (25)
- Datasphere (23)
- SAP HANA (22)
- SAP BW (13)
- NextTables Use Cases (12)
- SAP Data Warehouse (12)
- Master Data & Data Import in SAP BW (10)
- SAP Lumira Designer (9)
- Tableau (9)
- Value Driver Tree (8)
- SAC Application Designer (5)
- Power BI (4)
- SAP Connector (4)
- Green AI (3)
- RSADMIN (3)
- SAC Story (3)
- SAP Data Intelligence (3)
- project methodology (3)
- Airflow (2)
- Bookmarks Lumira Designer (2)
- Introduction to Machine Learning (2)
- Projektmethodik (2)
- career (2)
- SAP Partner (1)
- Visual Bi Extensions (1)