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 […]
I wanted to share my proof of concept about consuming data from SAP Datasphere into Power BI via ODBC connection (Open database connection) Required: Datasphere part: Login into Datasphere -> Space Management -> Choose the space and select Edit. Click Create and Make sure that you have enabled Expose for consumption by default Copy Database […]
Fields hidden by SAP in Standard BW Data Sources Many a times you would have observed that there are a few fields present in the extract structure of the SAP BW datasource but are not available in RSA6 or the data source which is replicated in BW. This blog talks about all steps as to […]
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 […]
Introduction As known from many articles and publications, SAP offers three solutions for data warehousing. The SAP Business Warehouse (BW) was first published in 1997 and has therefore been a constant figure in the SAP Data Warehouse range for more than two decades. BW / 4 HANA as a HANA-optimized variant integrates the old ABAP […]
Motivation During analysis of a business process for reporting, some of the required developments for the need and how to develop them are crystal clear. We tend to think of the required development elements on-the-fly/instinctively while analyzing the process. Almost in a visual way, but sometimes, even after working in BI environment for 10 years, […]
SAP HANA Based Transformations (New way of writing Routines) As majority of us has worked on SAP BW and have written ABAP routines in transformations in BW to derive the business logic, we often noticed the performance issue while loading the data into DSO, Info cube or master data info object. Also Read: SAP BW […]
