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


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