The Future of SAP Data Warehousing: Datasphere
- Irvin
- 25.11.2021
- SAP BW/4HANA, SAP Data Warehouse, 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 -
- 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 Datasphere
- Lutz
- 07.10.2021
- SAP BW/4HANA, Datasphere
The release of SAP Datasphere [formerly known as SAP Data Warehouse Cloud (DWC)] has unsettled many customers. Especially those who have focused their data warehouse ...
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
How to improve the performance of your SAP HANA database
- Chris
- 10.06.2021
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
Without a doubt, our daily lives become increasingly data-driven and the amount of data is continuously increasing every day. Thus, the amount of data that is generated ...
More
How to use IF ELSE statements in SAP HANA SQLScript
- Chris
- 12.05.2021
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
In the previous article, "CASE in SAP HANA - Control flow for SQLScript Transformation Routines", you learned that IF ELSE constructs are not possible within a SELECT ...
More
CASE in SAP HANA - Control flow for SQLScript Transformation Routines
- Chris
- 08.04.2021
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
In this article you will learn how to implement IF ELSE constructs in your SQLScript transformation routine. Actually, there are no IF ELSE statements in SQL SELECT ...
More
How to flag incorrect data records with SQLScript in SAP BW
- Chris
- 25.03.2021
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
After we evaluated the possible alternatives in the article "Two options for error handling with SAP BW and SQLScript", we found out that the way via the error stack is ...
More
Automatically correct erroneous data records with SQLScript in SAP BW
- Chris
- 18.03.2021
- SAP HANA, SAP BW/4HANA, SAP HANA SQL
In the earlier post "Two options for error handling with SAP BW and SQLScript" we looked in detail at the various error handling alternatives. We found out that the DTP ...
More
Subscribe our newsletter
Recent Posts
Posts by Tag
- SAP Analytics Cloud (66)
- Machine Learning (54)
- Dashboarding (50)
- SAP BW/4HANA (44)
- SAP Planning (33)
- NextTables (30)
- SAP HANA SQL (26)
- Apache Airflow (25)
- Datasphere (23)
- SAP HANA (22)
- SAP BW (13)
- NextTables Use Cases (12)
- SAP Data Warehouse (12)
- Master Data & Data Import in SAP BW (10)
- SAP Lumira Designer (9)
- Tableau (9)
- Value Driver Tree (8)
- SAC Application Designer (5)
- Power BI (4)
- SAP Connector (4)
- Green AI (3)
- RSADMIN (3)
- SAC Story (3)
- SAP Data Intelligence (3)
- project methodology (3)
- Airflow (2)
- Bookmarks Lumira Designer (2)
- Introduction to Machine Learning (2)
- Projektmethodik (2)
- career (2)
- SAP Partner (1)
- Visual Bi Extensions (1)