In this blog, I am going to walk through how you can create yourself a simple app to track the COVID-19 status in near real time with SAP HANA XS Advanced and display it in a web server or with SAP Analytics Cloud using custom widget. Also Read: SAP HANAIMP 16 Certification Preparation Guide Let’s […]
sap hana
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 […]
XSA Fiori Launchpad On-Premise Configuration With SAP Fiori Launchpad Plugins
Rest assured, it is possible to use SAP Fiori Launchpad Plugins with XSA On-Premise. Create the plugin Unfortunately there is no template available in SAP Web IDE On-Premise for the SAP Fiori Launchpad Plugin. But all is not lost, The Full Stack Web IDE provided by the SAP Cloud Platform has the template that we […]
NSE(Native Storage Extension) Data Tiering Options
NSE Whitepaper What is NSE ? HANA SPS 04 version has introduced the NSE. NSE is used to store the warm data. HANA was used to store the hot data in memory but as data growth occurred in some of the organization the need for another store came into picture and SAP came out with […]
How to trace widgets in SAP Analytics Cloud stories connected via HANA Live Data Connection
SAP Analytics Cloud is a powerful tool to visualize data. Even though it is a cloud framework, it could be very helpful in some cases to get a look behind the scenes. Objective In that blog post we try to analyse a story build in SAP Analytics Cloud with HANA Life Data Connection to a SAP […]
Consuming SAP HANA data into SAP Analytics Cloud through Live connection – End to End scenario
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 […]
Finishing and Printing SAP PowerDesigner Diagrams for HANA Database Schemas
If you have a great database schema, it is always good to promote it with a spectacular poster-sized ER diagram. I am part of the older crowd where, perhaps, having a working system is not the last step unless everyone knows you’ve put intense thought into the underlying database. The exact method for properly finishing […]
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 Secure Network Communication (SNC) Encryption configuration from SAP Portal to ABAP systems and SAP Gui to ABAP systems
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 […]
Sum of Multiple Rows based on a condition (validation) without using LOOP in SAP HANA
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 […]