How to fill the DTP Error Stack with SQLScript in SAP BW
- Chris
- 11.03.2021
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
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
- Chris
- 04.03.2021
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
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
- Jasmin
- 18.02.2021
- SAP BW/4HANA, 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
- Chris
- 14.01.2021
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
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
SAP HANA TO DATE - Date functions in HANA SQLScript explained
- Chris
- 19.11.2020
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
In this article you will learn some helpful HANA SQLScript date functions that you can use in your transformation routines. These functions make your work much easier ...
More
Machine Learning in customer segmentation with RFM-analysis
- Jasmin
- 12.11.2020
- SAP BW/4HANA, Machine Learning
Due to increasing competitive pressure, it is becoming more and more important to know and address the individual needs of your customers. For a large and diverse ...
More
How to debug SAP HANA SQLScript in AMDP-Transformations
- Sebastian
- 28.10.2020
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
When using SQLScript in transformations, you benefit from an enormous performance increase. Since data is processed directly in the database, there is no need to ...
More
HANA SQLScript in SAP BW - you should keep these restrictions in mind
- Sebastian
- 08.10.2020
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
In the previous article you have learned about the advantages of SQLScript. While SQLScript transformation routines are undoubtedly beneficial then it comes to ...
More
How to import CSV with dynamic file names into SAP BW
- Sebastian
- 21.09.2020
- SAP BW/4HANA, Master Data & Data Import in SAP BW
For larger companies with a broad system landscape, it is sometimes necessary to import data into BW via the flat file interface. The file names have a timestamp and ...
More
SAP planning - flexible data slices in SAP BPC with ABAP and SQL ...
- Chris
- 14.09.2020
- SAP HANA, SAP BW/4HANA, SAP Planning, SAP HANA SQL
A frequent requirement in SAP planning, be it Business Planning and Consolidation (BPC) or BW Integrated Planning (BW IP), is the ability to use flexible data slices. ...
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)