Friday 31 January 2020

Finding evacuation paths under real wildfire conditions – an application of SAP HANA graph and spatial


Global warming is affecting the temperature, precipitation levels, and soil moisture of our forest, turning them into kindling during wildfire season. To exemplify the severity of the problem, the 2018 wildfire season in the State of California USA was the most destructive and deadliest recorded thus far, with over 7500 fires burning an area of over 1,670,000 acres.

Wednesday 29 January 2020

SAP HANA of Persistent Memory using Intel’s DCPM or IBM’s vPMEM

In late 2018, when I first read this whitepaper on SAP HANA Adoption of Non-Volatile Memory it kept me hooked on Persistent Memory technology and its usage with HANA. Ever since then, I regularly followed the announcement of this persistent memory technology and on 2nd April, 2019 Intel announced the general availability of Intel Optane DC Persistent Memory. Later after that, IBM introduced Virtual Persistent Memory (vPMEM) in the virtualization platform of IBM Power Systems. So now we have two technology with which we can adopt HANA to enable the use of Persistent Memory.

Tuesday 28 January 2020

My Adventures in Machine Learning 2

My project literally starts from scratch. I have some experience in operating SAP BW systems and troubleshooting various performance issues, but that always was human experience applied to a specific technical problem. Now there is an (at least for me) completely new field: Applying Machine Learning to operations. During the last years I read a lot about the AI hype. AI was applied almost exclusively to business cases. This means to me stuff inside the SAP applications or some other business software layers. I haven’t really seen a case for trying to apply AI or Machine Learning below, in the ordinary operations. Sure, there is lots of automation in operations, but hardly anyone that I am aware of talks about AI or ML in operations. This makes it hard to use some best practices which might guide me.

Monday 27 January 2020

Common Errors and Fix – XSA Web IDE for HANA developments

When I started building objects in Web IDE for HANA on XS Advanced server, there are quite a few number of errors during build or deployment of the objects in HANA. I found answers to those errors in SAP Community forums and that was very helpful. Then I thought of consolidating those common errors and the resolutions at one place in this technical document.

Friday 24 January 2020

Cross-MTA Dependencies. Custom UI5 Library Reference Example.

While there is a lot of good information available on cross-MTA dependancies, I thought it would be useful to create a complete working example for loading a custom UI5 library cross-MTA.

To demonstrate the cross-MTA capability I will create two MTA’s containing UI5 applications

◉ Provider
◉ Consumer

Thursday 23 January 2020

SAP Hana 2.0 Revision Upgrade


One of the key responsibility of SAP administrator is to maintain HANA database. Hana database maintenance means variety of administration tasks like performance monitoring, enforcing security standards, patching & upgrade of database etc. In this blog I will talk about HANA revision upgrade from version to

Wednesday 22 January 2020

HANA 2.0 Running inside Docker


When I was searching for any SAP HANA 2.0 inside container, the only thing I was able to find was about SAP HANA Express edition, how to pull images from docker hub with express SAP HANA inside. Nothing about how to create your own image… So here is my try :).

Tuesday 21 January 2020

Good Things Come Together: DBeaver, SAP HANA Spatial & Beer

SAP HANA Study Materials, SAP HANA Leaning, SAP HANA Online Exam, SAP HANA DBeaver, SAP HANA Prep
German areas with high Biergarten density? Spoiler: The result won’t surprise…

SAP HANA Spatial offers in-database capabilities for handling and processing geospatial data. Furthermore, by leveraging the SAP HANA embedded machine learning capabilities developers are equipped with the ability to infuse spatial analytical models into their applications without the explicit need to actually visualize the geo-referenced input data.

Monday 20 January 2020

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


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 ABAP systems and SAP Portal Traffic to ABAP systems. SNC can be implemented in HANA On premise and Hana Cloud Landscapes as well.

Friday 17 January 2020

HANA ML DataFrame : End-to-end methods and it’s usage

A small write-up on HANA ML dataframe , it is really a learning , an exposure and a knowledge sharing process to write something beautiful you learn along with your day to day job so holding the passion for technology in both of my hands here come’s my first post of 2020 and topic is interesting enough , everyone’s favorite. HANA Machine learning & it’s about dataframe this time.

Thursday 16 January 2020

Wednesday 15 January 2020

Replicating Data from Oracle to HANA using SAP HANA Web IDE SDI


SAP Smart Data Integration provides real time, high speed data provisioning, bulk data movement, and federation. Replication task or flowgraph lets you set up batch or real-time data replication and transformation scenarios in an easy-to-use web application. Data Provisioning Agent hosts data provisioning adapters, enables data federation, replication, and transformation scenarios for on-premise or in-cloud deployments. Monitors for Data Provisioning Agents, remote subscriptions, and data loads are accessible from the SAP HANA cockpit.

Tuesday 14 January 2020

Non Equi join in SAP HANA 2.0 Web IDE


Purpose of this blog is to demonstrate the use of “Non Equi join” in SAP HANA Modelling. SAP HANA 1.0 modelling does not support the Non Equi join between two data set, however in hana 2.0 SAP Web IDE modelling new feature added to support Non Equi join.

Monday 13 January 2020

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


This blog post is regarding the validation of “Production Ratio” in Supply Chain Management for the monthly bucket in SAP HANA.

For the calculation of “Production Ratio” you can go through my previous Blog.

Saturday 11 January 2020

Minus set operation in SAP HANA 2.0 Web IDE


Purpose of this blog is to demonstrate the use of “Minus” set operator in SAP HANA Modelling.

SAP HANA 1.0 modelling does not directly support the Minus operation between two data set, however in hana 2.0 SAP Web IDE modelling new feature added to support Minus operation between two data set.

Friday 10 January 2020

Duplicating ASE Table Placement and Permission in HANA

I am comfortable with ASE. For HANA it’s a little different right now, so coming up to speed in HANA often means that I am comparing what I know in ASE with what I don’t know in HANA. Take table placement and permission for example. Here is what I have discovered so far, and it can get complicated very quickly.

Wednesday 8 January 2020

HANA – Linux staging

A lot of customers asking for the optimal operation strategy regarding Linux/HANA and how it will change their current operational processes. So, we talk about lifecycle management – patching of the different components of a system.

Monday 6 January 2020

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


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 * 100) for each month. The catch is when there is no value for Quantity and Totaly Quantity in a month, then we have to look forward to the upcoming months for values.

Sunday 5 January 2020

SUSE – Let’s migrate “saptune” to version 2

SAP HANA Tutorial and Materials, SAP HANA Learning, SAP HANA Online Exam, SAP HANA Certifications, SAP HANA Prep

In May, 2019 SUSE made an announcement on new saptune version, which looked promising as they eliminated the hard-coding of parameters and instead, they have listed in a configuration file. Also more SAP Notes will be included in saptune which results in less headache during system configuration. I got excited to use this new version of saptune but it was not generally available until July, 2019.

Friday 3 January 2020

HANA – analyzing runtime dumps

The description runtime dump means not only when you trigger it manually or when a system crashes.

In this blog I will explain with 2 examples (OOM dump and indexserver crash) which tools you can use to analyze them and what you have to watch out for.

Wednesday 1 January 2020

SAP HANA Backup via backint interface. Step-by-step guide for Veritas NetBackup.


You want config backup via backint interface for your SAP HANA multitenant database.
This step-by-step guide provides information about Veritas NetBackup solution
N.B .If you want to use other backup tools, for example, EMS Networker, Veeam Plug-in for SAP HANA, Spectrum Protect for Enterprise Resource Planning, etc this guide will be useful for you too.