sap bw 4hana Blog

External HANA Views - Where are the external HANA views stored?

External HANA Views - Where are the external HANA views stored?

Welcome to the last part of our three-part series on external HANA Views. In our first article "External HANA Views - Advantages of automatically generated HANA Views" ...
More
External HANA Views - How to generate external HANA views from BW objects

External HANA Views - How to generate external HANA views from BW ...

In the first part of our series, you learned about the concept behind external HANA Views. In the article "External HANA Views - Advantages of automatically generated ...
More
External HANA Views - Advantages of automatically generated HANA Views

External HANA Views - Advantages of automatically generated HANA Views

With the Workspaces concept, SAP allows users to independently load data into SAP BW and link it to the existing models. We covered Workspaces in our article "More ...
More
SQLScript Performance Tips

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

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

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 Datasphere - too early to make the switch?

SAP Datasphere - too early to make the switch?

With the focus of SAPs Data Warehouse (DWH) strategy shifting from BW/4HANA to Datasphere, our customers face the question of likewise transitioning their own BW system ...
More
Flatfile upload with SAP BPC EPM Add-In und possible alternatives

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: Datasphere

The Future of SAP Data Warehousing: Datasphere

Datasphere [formerly known as SAP Data Warehouse Cloud (DWC)] is the future of data warehousing for SAP. This much became clear on November 16, 2021 at the latest, when ...
More
Hana SQL DWH vs SAP BW vs Mixed Scenario - Quick Guide -

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