Introduction: Currently it is not possible to pass an URL-Filter on Hierarchy Nodes for BW-Live Models with the standard options. In this blog I´ll show how this can be accomplished with some simple scripting and story setup. Use Case: There is one story which contains input controls (or story filters) for specific dimensions with hierarchies […]
BW SAP HANA Modeling Tools (Eclipse)
Step-by-step Financial Statement Version Reporting with Currency Type Characteristic on S/4 Hana + Embedded BW
Motivation During analysis of a business process for reporting, some of the required developments for the need and how to develop them are crystal clear. We tend to think of the required development elements on-the-fly/instinctively while analyzing the process. Almost in a visual way, but sometimes, even after working in BI environment for 10 years, […]
Optimizing models in BW/4HANA mixed scenarios
1. Introduction I’ve had the opportunity of trying some test in a customer with a SAP BW/4HANA in order to improve performance in his reports. This customer has a modern infrastructure with a SAP BW/4HANA (BW 7.5, HDB 2.0) with an intensive reporting with AFO, webi and other third-party tools. Also Read: SAP S/4HANA Management […]
Getting MAX/MIN Date on BW Query Designer (BEx), Compatible with BusinessObjects
Introduction: The maximum and minimum with regarding to date subject has been on my mind for quite a while. I searched for it a couple of years back and did not come to a significant answer but to make the date as a Key Figure then use the query conditions to retrieve the TopN based […]
Looking forward for the next available value in a table without using LEAD or LAG function or LOOPING in SAP HANA
REQUIREMENT This blog is regarding the calculation of “Production Ratio” in Supply Chain Management for the monthly bucket in SAP HANA. The client wanted to see, Production Ratio of a year for each month for a particular Product, Location and Product Version combination. In my case Production Ration was calculated as (Quantity / Total Quantity […]
SAP HANA Based Transformations (Processing transformations in HANA) aka ABAP Based Database Procedure (AMDP)
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 […]