BW Data Modeling (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 »

There might come a time when you have perhaps preformed SP level upgrade of your BW system and you notice some objects are throwing ABAP dumps when you try to open them. If these are standard objects then there are ways you can fix the issue. ABAP... Read More »

Scenario: The scenario is to transpose a table by a single transpose column and populate the new table with the data. PRODUCT_DATA: PRODUCT_TRANSPOSE:   Solution Approach: The solution is to create the dynamic SQL statement as below which... Read More »

Starting Point The query optimizer uses statistics to select the best query plan. The query optimizer may be unable to choose the best query plan if certain statistics are missing. If database statistics for HANA Virtual Tables have not yet been... Read More »

2023/3/14追記）External HANA Viewを利用するための権限についての情報などを追記しました。 はじめに このブログポストでは、最近Premium... Read More »

Life is forcing you sometimes to change the context of composite provider. Many times I had a situation when I have to replace the ADSO to CalcView. But what if somethings goes wrong and you have to recreate assignments for all object once again ?... Read More »

Hello There! Pretext : The more we lean towards AMDP based HANA transformations compared to good old ABAP these days, the more we feel the need of having substitutes of reusable standard ABAP function modules & programs. One such instance... Read More »

Business Case: Large gaps between SIDs. Due to this, if SIDs reach 2 billion records. Then, data load is not possible to dependent target. Execute a Program: ZSAP_SIDVALDISTRIB to find the Gaps by providing inputs as shown in below screen... Read More »

Dear  SAP BW/4HANA lovers ,   I have been part of SAP for close to 10 years and work mainly on SAP BW/4HANA topics. There were many enquiries about exceptional update feature  in SAP BW/4HANA  especially on enabling the feature for ADSO and... Read More »

Abstract: This Blogpost discusses the various migration strategies in fundamental Business and Technical sense. Disclaimer: In this blog post, the points that I brought are my own experience and thought process. It may vary from place to place.... Read More »