Quick & Easy Datasphere – When to use Data Flow, Transformation Flow, SQL View?

SAP Datasphere, SAP BW/4HANA, BW SAP HANA Data Warehousing

Introduction In SAP Datasphere we can “enhance” a data set using different development artifacts like data flow, transformation flow or SQL view (Query/Table Function). In this blog article, I’ll share my point of view and decision process for development artefact selection. Datasphere Technical Limitations/Design Considerations Let’s first cover the most important factor; persistent data tables […]

Continue reading


SAP BW Bridge In SAP Datasphere : Connectivity Between S/4HANA System & BW Bridge

BW (SAP Business Warehouse), SAP Analytics Cloud, SAP BTP, SAP Datasphere, SAP S/4HANA, SAP BW/4HANA

Introduction: SAP BW bridge is a functional enhancement of SAP Datasphere and enables ABAP-based data extraction and staging capabilities within SAP Datasphere. It provides customers who are running SAP Business Warehouse or SAP BW/4HANA with access to the public cloud as it offers SAP BW capabilities directly in SAP Datasphere. SAP BW Bridge for SAP […]

Continue reading


Enhancing BW datasources based on ODP_CDS – useful for Datasphere too!

SAP Datasphere, SAP BW/4HANA

The need to enhance SAP Standard Datasources is a familiar requirement for a BW consultant. Traditional SAPI datasources are routinely enhanced using custom appends and exit/badi ABAP code or for Logistics datasources additional pool fields can be added via the LBWE LO cockpit. While SAPI DataSources remain the mainstay of most BW systems, ODP_CDS Datasources […]

Continue reading


Conversion to SAP Data Warehouse Cloud: Conversion Paths and Cloud Transformation Steps

SAP Data Warehouse Cloud, BW (SAP Business Warehouse), SAP BW/4HANA, SAP HANA, SAP HANA Cloud, SAP S/4HANA

Abstract Innovate your IT landscape with SAP Data Warehouse Cloud, which is SAP’s strategic target solution for all data warehousing use cases, in line with SAP’s data-to-value portfolio strategy. This blog post provides SAP BW and SAP BW/4HANA customers an overview of how existing on-premises investments can be converted to the cloud. More importantly, a […]

Continue reading


SAP Data Warehouse Cloud, SAP BW bridge: Overview and Technical Deep Dive

SAP BW/4HANA, BW (SAP Business Warehouse), SAP HANA, SAP HANA Cloud, BW SAP HANA Data Warehousing, SAP Data Warehouse Cloud

Abstract This blog post is about a strategic feature of SAP Data Warehouse Cloud, namely the SAP Data Warehouse Cloud, SAP BW bridge. SAP offers its customers through RISE with SAP, the opportunity to move with a business transformation as a service (BTaaS) to the cloud. For BW customers, this means SAP BW to SAP […]

Continue reading


ADSO Remodeling: Cases after implementation of notes 3006437 and 3019867

SAP BW/4HANA, BW (SAP Business Warehouse)

Scope of this blog post will delve in to details of below use cases: As explained in the blog posts from Frank Riesner, note 3006437 brings a new RSADMIN parameter RSO_ADSO_ONLINE_CONV_THRESHOLD, that allows us to control the threshold limit of the number of records, beyond which the system triggers a remodeling request. However, in large […]

Continue reading