Thursday, 17 June 2021

Use Geospatial Methods and Predicates feature in SAP HANA

Business Example:

There is a requirement from a client where the client wants to calculate the distances between their customers and their stores. Typically, locations or addresses in a database are stored in text fields, making it difficult to pinpoint the exact geographical locations.

To be able to calculate distances accurately, you have decided to store the geographical locations of the customers and stores, using the SAP HANA geospatial model and its related functions.

Wednesday, 16 June 2021

Scheduling Python code on Cloud Foundry

This blog starts with a very simple example to schedule a Python file on Cloud Foundry, just to introduce the most important steps. That concept is then extended to schedule a Python file, which applies a trained Machine Learning model in SAP HANA.

Run Python file locally

We would like to schedule a Python file, not a Jupyter Notebook. Hence use your preferred local Python IDE or editor to run this simple file, helloworld.py.

Monday, 14 June 2021

Piecewise Linear Trend with Automated Time Series Forecasting (APL)

If you are a user of APL time series, you probably have seen models fitting a linear trend or a quadratic trend to your data. With version 2113 the Automated Predictive Library introduces an additional method called Piecewise Linear that can detect breakpoints in your series. You don’t have to do anything new to take advantage of this functionality, the trend is detected automatically as shown in the example below.

For SAP Analytics Cloud users, note that Piecewise Linear Trend is coming with  the 2021.Q3 QRC (August release).

Friday, 11 June 2021

Using SDI FileAdapter to write to Azure file share

In this blog we will create an Azure file share and use it as a destination for SAP SDI FileAdapter.

Prerequisites

1. Azure Account

2. SAP HANA Data Provisioning Agent server enabled

3. SAP HANA Data Provisioning Agent installed

Let’s start by creating the Azure file share. Login to the Azure portal and create a premium storage account  as depicted in the below screenshot

Thursday, 10 June 2021

SAP HANA XS Advanced Administration, Deployment and Operations

1. Deployment Options

There are various ways of deploying the XS Advanced runtime. Before deploying the XSA many scenarios need to considered that will have impact on your landscape maintenance activity .For example the system refresh scenarios where you will need to refresh only a certain tenants instead of complete system this deployment plays a key role . I will go through the limitations in detail in backup restore section. In general, The following additional services run where XSA is deployed:

◉ xscontroller: Central management component of XSA. It has a view on all deployed and/or running applications, and persists configuration and status information in the database

Wednesday, 9 June 2021

SAP on AZURE/ SAP on AWS : Cost Optimized DR Solutions for HANA : Lean/Skinny DR

Running SAP on the HANA database is not only having multiple advantages, but also few cons as well. The hardware cost to run the HANA database is one of them. Since HANA is an in-memory database, customers must provision higher-size RAM and CPU to run their SAP on HANA. Even in hyper scaler environments like AZURE/AWS, HANA VM (M-Series) cost is huge comparatively and concern for most of the customers.

Keeping this in mind, designing a disaster recovery solution for HANA is a very challenging one.&To address this design challenge, we can consider multiple cost-optimized options like

Monday, 7 June 2021

The DMEEX Trace Tool

SAP HANA Exam Prep, SAP HANA Career, SAP HANA Preparation, SAP HANA Certification, SAP HANA Prep, SAP HANA Learning

With the release of SAP S/4HANA 2020 Feature Pack 1 (onPremise), DMEEX receives one of the biggest updates in its lifetime. We implemented a tool that opens and clarifies DMEEX Engine processing. In this tool, you can see and analyze how the DMEEX tree was processed in detail, without the need to debug its code. We call this tool the DMEEX Trace Tool.

Friday, 4 June 2021

How to Setup SAP HANA Multi-Target System Replication

SAP HANA System Replication is a reliable high availability and disaster recovery solution that provides continuous synchronization of a HANA database to a secondary location either in the same data center or remote site as a disaster recovery site.

More Info: SAP HANA Certification

In this article fI have tried to keep it simple on how to setup a system replication when you want to replicate single primary to multiple target which may be in same data center or at remote site.

For better understanding let us assume below.

Thursday, 3 June 2021

Solution Order Management in SAP S/4 HANA Cloud 2105

In the 2008 release, SAP S/4 HANA Cloud introduced Solution Order Management in response to market demand for a hybrid solution in which sales and service functions merge seamlessly. Solution Order Management helps customers grow their margins by transitioning away from selling individual products and services to providing bundled business solutions consisting of products, one-time services, and recurring service subscriptions. With the 2105 SAP S/4 HANA Cloud release, we have broadened the scope of Solution Order Management, and in this blog, I’ll take you through a few of the key updates.  

Wednesday, 2 June 2021

Update on Basic Shipping for SAP S/4HANA 2020

SAP’s strategy for Transportation Solutions in SAP S/4HANA

Since the introduction of SAP S/4HANA® some of the previous modules/solutions available in SAP ECC became available through something called “Compatibility Packs”. A Compatibility Pack (CP) is a version of a standard SAP Business Suite software product that is compatible with SAP S/4HANA.

Compatibility packs:

◉ Cover functionality from SAP ERP core or line-of-business (LoB) or industry solutions

◉ Comprise the complete or partial scope of the related SAP Business Suite product

◉ Will be phased out in favor of other strategic solutions that may have similar functionality to that within the CP software and may have a separate license.