Remote Conversions from BW 7.3/7.4 to SAP BW/4HANA are a new tool in the toolbox adding to the In-Place conversion option. In this blog post I will focus on our firsthand experience with remote conversions and point out the steps needed for a successful migration. A remote conversion consists of 2 Steps. Step 1 the […]
SAP BW/4HANA
BW4HANA Workspaces
A BW Workspace is a dedicated area inside SAP BW/4HANA that is used to upload local data and combine this with central data. It exposes central EDW data in a logical way to be consumed and enhanced with local data by business users. BW Workspaces are integrated into BW4HANA, but in full control of business. […]
ABAP Code identification/Search in SAP BW or SAP BW/4HANA system
Introduction I need to search a piece of ABAP code in my SAP BW system or in the SAP BW/4HANA System over the Custom/Standard Class/Methods, Start Routine, End Routine, Expert routines, Transformations, Include Programs and on Custom/Standard Function modules. There was a situation for me to find a particular function module used in all of […]
Operational Data Provisioning – Simplified
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 […]
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 […]
CDS based data extraction – Part II Delta Handling
As promised in part one, let’s have a closer look at the delta handling in CDS based extraction. In cases, in which big data volumes with a frequent changes are expected, e.g. transaction data like sales orders or similar, the application needs to provide delta records. In most of the cases daily (nightly) full uploads […]