BW Data Staging (WHM)

When your SAP BW system runs on HANA database, the cost of putting all the data in HANA in-memory is high. Also not all data from SAP BW is required in HANA database and only 30-40% of data from BW is actively required for reporting and operations.... Read More »

Requirements for POC: The requirement is to replicate S/4 HANA system changes with a real time using SLT configuration. The real time replicated data to be loaded into target system Azure Blob storage. The architecture diagram given... Read More »

Background Information With the migration to SAP BW/4HANA, source system of type “Web Service” is not available. And here comes a new capability “Write Interface” for DataStore Objects allowing to push data into inbound queue tables of... Read More »

Summary: Hierarchies are one of the most important elements in SAP BW which provides the Business users flexibility to navigate the hierarchy structure in the Frontend Reports. At times, a need arises where we need to flatten the hierarchy structure... Read More »

This blog post will explain a method to implement expert routine for column to row transpose on a table with huge number of columns. In a recent project I had a requirement to load a excel placed in SharePoint location to BW on HANA system. The data... Read More »

What Every BW/BI Developer Needs to Know About ABAP in BW Over time every BW developer needs to write ABAP in SAP NetWeaver BW to be able to meet user requirements. ABAP might be required in a start routine, end routine, expert routine, InfoPackage,... Read More »

Introduction: In past we did some fun exercise, where we tried to automate BW extraction via process chain and extractor under consideration only supported full extract. Goal was to figure out a way to extract delta only records without implementing... Read More »

Introduction: Invalid characters in BW data feed is quite common. Some time BW extracted data consist of special characters (!@#$%^&*()+_|}{“:;) etc. Some time business need to as part of text field so BW allow them by allowing special... Read More »

In this blog post we’ll see how to find if there’s lookup on any Infoprovider with just 5 simple steps. 1.Go to transaction SE16, give table name RSAABAP and hit enter. In the field EDIC: Program editor line enter your infoprovder name... Read More »

Excellent short video by Dearbhla Keenan on the different modes for the BW/4HANA starter add-on.