sap bw 4hana Blog

    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

    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

    Automated Time Series Forecasting using Machine Learning

    Forecasts and predictions of future values play an important role in various business areas to make better and more substantiated business decisions. For the ...
    More

    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