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


Creating a P-User in SAP Cloud Platform to Practise SAP HANA

SAP Cloud Platform, SAP HANA

This blog gives a clear picture of how to easily configure the SAP HANA cloud platform. To login to the SAP HANA Cloud Platform, you will need credentials. Also Read: SAP HANATEC 12 Certification Preparation Guide Steps to create user id: 1. Go to https://community.sap.com/. Click on login/sign up. Click on Register. 2. Enter all […]

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