SAP HANA Based Transformations (Processing transformations in HANA) aka ABAP Based Database Procedure (AMDP)

SAP BW/4HANA, BW (SAP Business Warehouse), BW SAP HANA Data Warehousing, BW SAP HANA Modeling Tools (Eclipse)

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 […]

Continue reading


SAP BW/4 HANA Integration with Microsoft Azure Cloud leveraging SAP Business Objects Data Services

SAP BW/4HANA, BW (SAP Business Warehouse)

With the rapid advancement and developments in system landscapes within the corporate information technology, clients are leveraging the best of technologies to benefit from the IT investment, there is a continuous need for integration between different technology stacks. In this blog post I would like to discuss a step by step process of loading data […]

Continue reading


Material Ledger Mass Loading in BW on HANA

SAP BW/4HANA, BW Data Modeling (WHM), SAP HANA, SAP S/4HANA

ERP transaction CKMLQS has been designed to display the multilevel valuated quantity structure for one material. The aim of the multilevel valuated quantity structure is to provide an overview of the actual quantity structure of the multilevel processes, valuated with the actual prices from the actual costing. I will try explain the steps, how to […]

Continue reading


How to Optimize BPC Model in SAP BPC 11, version for SAP BW/4HANA

SAP BW/4HANA, SAP ERP

Cube-like aDSO is generated as basis provider (part provider) SAP BPC 11, version for SAP BW/4HANA (BPC 11) for each BPC model. Together with this change, process chain /CPMB/BUILD_INDEX and /CPMB/FULL_OPTMIZE are now obsolete, as result, there is no out-of-box way to optimize BPC model (aDSO) either from BPC web admin or data manager. Read […]

Continue reading