2 Blog

SAP HANA TO DATE - Date functions in HANA SQLScript explained

SAP HANA TO DATE - Date functions in HANA SQLScript explained

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
How to debug SAP HANA SQLScript in AMDP-Transformations

How to debug SAP HANA SQLScript in AMDP-Transformations

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

HANA SQLScript in SAP BW - you should keep these restrictions in mind

In the previous article you have learned about the advantages of SQLScript. While SQLScript transformation routines are undoubtedly beneficial then it comes to ...
More
SAP planning - flexible data slices in SAP BPC with ABAP and SQL script

SAP planning - flexible data slices in SAP BPC with ABAP and 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
How the block formation of FOX formulas in SAP planning works

How the block formation of FOX formulas in SAP planning works

FOX formulas are a good solution in SAP planning if you are looking for a high-performance way to process data with SAP Business Planning and Consolidation or BW IP. It ...
More
Use Google API and ABAP to enrich SAP data with geoinfos

Use Google API and ABAP to enrich SAP data with geoinfos

Nowadays, geodata play an increasingly important role. If you want to exploit the full potential of your data, you have to put them into a spatial context. In this ...
More
Effective data analysis using geodata

Effective data analysis using geodata

Nowadays almost all data has a spatial reference. Whether it is sensor data or satellite data, social media posts or videos - they can all be put into a spatial context. ...
More
In-Database Machine Learning with SAP HANA Predictive Analysis Library

In-Database Machine Learning with SAP HANA Predictive Analysis Library

There is no question that data is the new currency in the digital age. However, only very few companies use the full potential of their data, for example to uncover ...
More
S4HANA - Do You Still Need SAP BW?

S4HANA - Do You Still Need SAP BW?

Nothing is as constant as change. Especially in IT, where new technologies are constantly evolving. While just about 10 years ago, the BW Accelerator was still the ...
More
How to create SAP BW Transformations with SQL Script

How to create SAP BW Transformations with SQL Script

In this previous article you got to know the advantages of SQL Script and the decision criteria for implementation of SQL Script routines. In this article, I will show ...
More