sap hana Blog

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
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 improve the performance of your SAP HANA database

How to improve the performance of your SAP HANA database

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

How to use IF ELSE statements in SAP HANA SQLScript

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
CASE in SAP HANA - Control flow for SQLScript Transformation Routines

CASE in SAP HANA - Control flow for SQLScript Transformation Routines

In this article you will learn how to implement IF ELSE constructs in your SQLScript transformation routine. Actually, there are no IF ELSE statements in SQL SELECT ...
More
How to flag incorrect data records with SQLScript in SAP BW

How to flag incorrect data records with SQLScript in SAP BW

After we evaluated the possible alternatives in the article "Two options for error handling with SAP BW and SQLScript", we found out that the way via the error stack is ...
More
Automatically correct erroneous data records with SQLScript in SAP BW

Automatically correct erroneous data records with SQLScript in SAP BW

In the earlier post "Two options for error handling with SAP BW and SQLScript" we looked in detail at the various error handling alternatives. We found out that the DTP ...
More
How to fill the DTP Error Stack with SQLScript in SAP BW

How to fill the DTP Error Stack with SQLScript in SAP BW

In the previous article, Two options for error handling with SAP BW and SQLScript, we presented the different scenarios of error handling within SAP BW on HANA and ...
More
Two options for error handling with SAP BW and SQLScript

Two options for error handling with SAP BW and SQLScript

SAP BW loading processes are often terminated due to incorrect data records. To avoid these terminations, appropriate error handling is useful. Basically, there are two ...
More
Currency conversion with SAP HANA SQLScript in transformation routines

Currency conversion with SAP HANA SQLScript in transformation routines

Often in SAP BW HANA, the currency must be converted during the loading processes. For example, in a corporation with companies in different countries, the local ...
More