The Operational Data Provisioning (ODP) Framework The operational delta queues are a new framework which enables multiple subscribers to replicate data from a set of queues of a provider. The standard BW Extractors (SAPI) present in ECC or S/4 systems have been made ODP compatible via the mass ABAP program ‘BS_ANLY_DS_RELEASE_ODP’ (SAP Note 2232584) (This […]
SAP BW/4HANA
Basis Daily Monitoring T-Codes
If someone is going to choose their career as “BASIS Consultant” We need to know the basics and daily activities of a basis person that needs to be performed on the system. I’ve listed a few activities which can help us to monitor the system performance. SM51: SAP servers Transaction code SM51 is to display […]
How-to Master Data Planning in SAP BW/4HANA
Introduction In a BW project a typical requirement is that business wants to change or enrich Master Data. Until now this was mostly done with customized solutions like having a special aDSO working as control table with a class for master data update or doing it in the BPC Master Data Administration. Since BW/4HANA 1.0 […]
Agile Data Warehousing with SAP BW/4 HANA
Intro Agile Approaches and organisations have been very present in the media for a long time and have been used in Software-Development for a long time. We encounter the result of agile software development every day when using Amazon, Spotify, but also SAP cloud solutions such as the SAP Analytics Cloud. The short time until […]
SAP Analytics Cloud Live Data Connection to SAP BW
This blog post will show you how to create a live data connection from SAC to an on premise BW system. Main feature of live data connection is that changes made to data in the on-premise data source is immediately reflected in the Stories and models based on that data source. Below is the architecture […]
Optimizing models in BW/4HANA mixed scenarios
1. Introduction I’ve had the opportunity of trying some test in a customer with a SAP BW/4HANA in order to improve performance in his reports. This customer has a modern infrastructure with a SAP BW/4HANA (BW 7.5, HDB 2.0) with an intensive reporting with AFO, webi and other third-party tools. Also Read: SAP S/4HANA Management […]
SAP HANA Based Transformations (Processing transformations in HANA) aka ABAP Based Database Procedure (AMDP)
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 […]