Nextlevel-Icon

Helfen Sie uns ein Level weiter. Nehmen Sie an unserer Umfrage teil.

sap bw 4hana Blog

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

A comparison of SAP BW, HANA Native and Data Warehouse Cloud

The release of SAP Data Warehouse Cloud has unsettled many customers. Especially those who have focused their data warehouse strategy on SAP BW/4HANA or HANA Native are ...
More

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

Master Data Planning with SAP BW/4HANA and Possible Alternative

Master data maintenance is one of the most common requirements in planning projects. Users should be able to independently adjust master data for their planning, without ...
More

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

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

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

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

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

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