sap hana sql Blog

SAP Datasphere: SQL or Graphical Views? Making an educated decision

SAP Datasphere: SQL or Graphical Views? Making an educated decision

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

Tips for readable SQLscript code

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

How to improve the performance of your SQL functions

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

SQL Performance Analysis with SAP PlanViz

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

Performance analysis and optimization of SAP 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

SQLScript Performance Tips

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

Handling account & key figure model in SAP HANA SQLScript & CalcView

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

Generation of SQLScript for SAP AMDP transformations with ABAP

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 -

Hana SQL DWH vs SAP BW vs Mixed Scenario - Quick Guide -

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

How to use Window Functions in SQLScript

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