sap bw 4hana Blog

SQLScript Performance Tips

Performance is one of the main arguments for using SQLScript. With the introduction of the HANA database, SAP has introduced the "code pushdown" concept. With this new ...
More

How to use MAP function in SQL script

In a previous post, "How to Use Window Functions in SQL Script", we introduced the window function that allows you to generate partitions within the SELECT command.
More

SAP BW/4HANA & Data Tiering with NSE - a Performance Comparison

Today we are talking about data management in your HANA system and what simple Data Tiering option you have available to save valuable memory that HANA works with. Not ...
More

SAP Data Warehouse Cloud - too early to make the switch?

With the focus of SAPs Data Warehouse (DWH) strategy shifting from BW/4HANA to Data Warehouse Cloud (DWC), our customers face the question of likewise transitioning ...
More

Flatfile upload with SAP BPC EPM Add-In und possible alternatives

SAP Business Planning and Consolidation is geared towards business users. With the EPM Add-In for Excel, it offers users an easy way to upload data via flat files. In ...
More

The Future of SAP Data Warehousing: Data Warehouse Cloud

Data Warehouse Cloud is the future of data warehousing for SAP. This much became clear on November 16, 2021 at the latest, when Fabian Hartje, Head of Product Management ...
More

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