News - sap hana Blog

How to import CSV with dynamic file names into 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 ...

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

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

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

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

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

How to Connect SalesForce and SAP BW with ABAP

Especially in the cloud era, flexible connectivity is becoming increasingly important. Cloud systems are to be integrated more closely with its on-premise counterparts. ...
More

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

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

SAP BW Transformations with SQL Script - When to Convert

"Code to Data" instead of "Data to Code" With the introduction of the HANA database, SAP has introduced the "Code Pushdown" concept whereby time-consuming calculations ...
More