SQLScript Performance Tips
- Sebastian
- 26.01.2023
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
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
- Irvin
- 17.11.2022
- SAP BW/4HANA
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
- Steven
- 23.06.2022
- SAP BW/4HANA, SAP BW
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?
- Irvin
- 12.05.2022
- SAP BW/4HANA, SAP Data Warehouse, Data Warehouse Cloud
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
- Sebastian
- 31.03.2022
- SAP BW/4HANA, Master Data & Data Import in SAP BW
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
- Irvin
- 25.11.2021
- SAP BW/4HANA, SAP Data Warehouse, 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 -
- Irvin
- 14.10.2021
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
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
- Lutz
- 07.10.2021
- SAP BW/4HANA
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
- Irvin
- 16.09.2021
- SAP BW/4HANA, SAP HANA SQL
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
- Sebastian
- 08.07.2021
- SAP BW/4HANA, Master Data & Data Import in SAP BW
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
Subscribe our newsletter
Recent Posts
Posts by Tag
- SAP Analytics Cloud (41)
- SAP BW/4HANA (39)
- Machine Learning (38)
- Dashboarding (35)
- SAP HANA (22)
- SAP HANA SQL (20)
- SAP Planning (19)
- NextTables (17)
- Apache Airflow (12)
- Master Data & Data Import in SAP BW (9)
- NextTables Use Cases (9)
- SAP Lumira Designer (9)
- Value Driver Tree (8)
- Data Warehouse Cloud (7)
- Tableau (7)
- SAP BW (6)
- SAP Data Warehouse (6)
- SAC Application Designer (5)
- SAP Connector (4)
- Green AI (3)
- Power BI (3)
- RSADMIN (3)
- SAP Data Intelligence (3)
- project methodology (3)
- Bookmarks Lumira Designer (2)
- Introduction to Machine Learning (2)
- Projektmethodik (2)
- career (2)
- Airflow (1)
- SAC Story (1)
- SAP Partner (1)
- Visual Bi Extensions (1)