Looking forward for the next available value in a table without using LEAD or LAG function or LOOPING in SAP HANA

SAP HANA, BW SAP HANA Modeling Tools (Eclipse), SAP HANA Studio

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

Continue reading


Sum of Multiple Rows based on a condition (validation) without using LOOP in SAP HANA

SAP HANA, SAP HANA Studio

REQUIREMENT This blog post is regarding the validation of “Production Ratio” in Supply Chain Management for the monthly bucket in SAP HANA. Read More: SAP HANATEC 12 Certification Preparation Guide The client wanted to see “Production Ratio” of each month for a particular Product, Location and Product Version combination with validation. In my case, when […]

Continue reading