Bulgaria is Switching to the Euro – What this Means for SAP BW Introduction Bulgaria will officially adopt the euro on January 1, 2026, a fixed conversion rate at 1 EUR = 1.9558 BGN will apply. That sounds simple, but in SAP BW it affects master data, key figures, currency translation logic, historical reporting, planning, and…
Kategorie: BW4/HANA
Playing Data Football: Understanding SAP Datasphere, SAP Analytics Cloud, SAP Business Data Cloud, and Databricks When talking about modern data and analytics, the landscape can feel confusing—different players, overlapping roles, and everyone claiming to be the “star striker.” To make it easier, let’s think of the data world as a football team. Each solution has…
Report Navigation in SAC with RRI SAP Analytics Cloud (SAC) helps users explore data easily. I recently had the chance to try out its support for SAP BW’s Report-to-Report Interface (RRI), officially available since the Q3 2024 release. With this feature, moving between related reports becomes much smoother. In SAP BW, RRI has been a…
Breaking New Ground: NCUM Data Modeling in SAP Datasphere (DSP) vs. BW/4HANA – Part 3: NCUM in SAP Datasphere (DSP) In Part 2, we explored how SAP BW/4HANA handles non-cumulative (NCUM) key figures through inventory-enabled aDSOs, leveraging built-in features like record types, time references, and automated delta handling to calculate accurate stock levels. The system…
SAP BW und Business Data Cloud: Jetzt umsteigen oder noch warten? In der sich schnell entwickelnden Welt von SAP Analytics stehen viele SAP BW Kunden vor einer entscheidenden Frage: Jetzt auf die SAP Business Data Cloud (BDC) setzen oder noch bei bestehenden BW-Lösungen bleiben? Die Antwort darauf ist komplex – sie hängt stark vom derzeitigen…
Breaking New Ground: NCUM Data Modeling in SAP Datasphere vs. BW/4HANA – Part 2: NCUM in SAP BW/4HANA In Part 1, we introduced the basics of inventory reporting with Non-Cumulative (NCUM) Key Figures and highlighted how record types help ensure accurate time-based aggregation. In Part 2, we focus on SAP BW/4HANA, exploring the technical setup…
Breaking New Ground: NCUM Data Modeling in SAP Datasphere vs. BW/4HANA – Part 1: Record Types Stock and inventory data present unique challenges for reporting because they don’t aggregate over time like traditional transactional data. For example, summing up stock levels across multiple periods doesn’t yield meaningful insights since stock values depend on both historical…
How to – incrementing Versioning/Scenarios (in planning solutions using SAP BW) Versioning concept In many of my BW/SAC Planning projects, there are requirements for a versioning and scenario concept. Since there are several good ways to implement the Actual/Budget/Forecast and Time Component, there is often the requirement for an incrementing dimension. It can be called…
How to – Custom Status management in SAP BW / SAP SAC with aDSOs (using BW-IP / BPC) Status Management – Introduction In BW there is often the need to track the status of a process. This can be a planning process or a regular data load/working process. In this Blog, I will show how…
Generating and Importing Synthetic Sales Data Using ChatGPT, Python and Excel – A Step-by-Step Guide In today’s data-driven landscape, access to high-quality, varied, and seasonality-aware datasets is crucial for training forecasting models, performing data analysis, and conducting simulations. However, real-world data is often incomplete, unavailable, or limited in scope. This is where generating synthetic data,…