BW Data Modeling (WHM)

Abstract:  Though the Proliferation of Cloud Computing Technologies prevailed the paradigm shift of moving to Modern Data Warehouse Architecture and Technologies, this Blogpost still discusses one of the crucial task performance issues occurring in... Read More »

In this Blog Post we will understand how to handle a situation when Objects are not visible within InfoArea.   Problem Statement : Often when there are Role level and authorization related Changes from Basis or Security Team on User ID,... Read More »

I am a Senior BW Consultant working at NTT Data Business Solutions. I have recently worked on a customer project where we were challenged with implementing Data Tiering Optimisation (DTO) using Native Storage Extension (NSE) This blog is aimed at... Read More »

Hello There! This blog post is an extension of one of my previous blog posts regarding replication of the methods in p_r_request into AMDP TRFNs in BW/4HANA 2.0 context. As already stated in the earlier blog post,  a set of predefined parameters is... Read More »

Greetings ! As promised in my earlier blog post, in this article I will be explaining the possibilities of using the view for external access or the external SAP HANA SQL view for aDSOs or the generated ‘8’ view of aDSOs. The main idea... 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 »

Hello there! Context In this blog post, I would focus on some of the key aspects of the generated view for external access  or the external SAP HANA SQL View for aDSOs in BW/4HANA 2.0 by a use case scenario. The view is generated with naming... Read More »

Hello, For many of us existing BW consumers, while moving to BW/4HANA platform it’s quite common a scene these days that we change the existing BW transformation routines from ABAP to AMDP to leverage the HANA performance in better possible... 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 »