Handling Non-Cumulative Measures in HANA Calculation Views with Multiple Cartesian Transformation and Single Conversion Matrix

SAP HANA, BW4HANA, Calculation Views

Introduction The COPA, the forecast and many other S4HANA, ECC and legacy tables contain hundreds of measures in their record structures. This format is not suitable for efficient processing in BI front end tools; e.g., WebI reports. The WebI P&L reports are performing the best when dealing with only one or few measures at most […]

Continue reading


Introducing the Data Protection Workbench of SAP BW/4HANA 2.0

SAP BW/4HANA 2.0, SAP HANA

Motivation In May 2018 the European Union enforced the laws on data privacy to protect its citizens in an environment which is increasingly based upon information and data. Following the media around topics like General Data Protection Regulation (GDPR) there are examples of major technology and social media companies who already were in the situation […]

Continue reading


Create Roles and Privileges from BW System for SAP BW HANA

SAP HANA, BW SAP HANA Data Warehousing

What this is all about? Within a company you have various user groups eg Users with full access, key user authorizations or end-user authorizations limited to for example one company code or one costcenter. With the addition of new applications like SAP Lumira creating powerful Dashboards, SAP Analytics cloud creating interactive stories from BW models […]

Continue reading