Consuming SAP HANA data into SAP Analytics Cloud through Live connection – End to End scenario

SAP Analytics Cloud, SAP Cloud Platform, SAP HANA

A lot of colleagues, partners and customers have been often asking me questions like following: “How easy it is to configure live connection between SAP HANA to SAP Analytics Cloud?” What are those precise list of privileges to be assigned to the user to be able to create a connection and to be able to […]

Continue reading


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


SAP Secure Network Communication (SNC) Encryption configuration from SAP Portal to ABAP systems and SAP Gui to ABAP systems

SAP HANA, SAP ERP

Background As per the client request to encrypt the SAP Portal traffic to SAP ABAP systems and SAPGUI encryption to ABAP systems as part of their Infosec policy. Encryption is implemented using the SAP Secure Network Communication (SNC). This document explains about step by step configuration of SNC Encryption on the existing SAP Gui to […]

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