Friday 30 November 2018

SAP S/4HANA: Key Adoption Scenarios to Consider Webcast Recap

SAP S/4HANA, SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Learning

This was a SAP user group webinar from yesterday.

Interesting developments are planned next year for 1809 in terms of system conversion; read below.

Wednesday 28 November 2018

SAP HANA System Copy- Homogeneous On Multi Tenant Database – Refresh using SWPM

As explained on my last blog SAP HANA System Copy- Homogeneous On Multi Tenant Database that we have 3 Ways to do System Copy and i explain 2 Ways 1 and 3 according to the note -1844468 – Homogeneous system copy on SAP HANA, and i promised to add 2nd way as well , So below is the 2nd way to do system copy, For Pre checks and preparation please read the 1st blog,

Tuesday 27 November 2018

XSA and SAP Web IDE For SAP HANA 2.0 SPS 03 Feature Revision 1: New Developer Features

Normally when we introduce new features for HANA, it is only done via a new release version (HANA 1.0 or 2.0) or an SPS – Support Package Stack (ex. HANA 2.0 SPS 0, SPS 01, SPS 02, SPS 03). However the XSA runtime and the SAP Web IDE for SAP HANA actually have a rather independent technical infrastructure from the HANA DB itself. Up to this point we’ve never used this feature to deliver new features separate from a HANA release or SPS. But it was always possible.

Sunday 25 November 2018

Merge Multiple SCD Tables into A Single Dimension

Tracking historical changes within a dimension is a common task in data warehousing.  Achieving this in a HANA sidecar database (SCD) requires an explicit design focus.  In some cases, the data source system maintains dates and time stamps to denote a record or value’s creation, change, or validity threshold.  In SAP systems creation, change, or validity dates are often but not always maintained for a record, dimension, attribute, or value. One such example being SAP Human Capital Management (HCM) mini-master info-types, seen as below:

Wednesday 21 November 2018

S4HANA Cloud Key User Extensiblity scenarios: Field Extensibility and Report Extensibility

Extensibility covers a broad spectrum of topics that allows customers and partners to adapt standard business software to their business needs. It ranges from business configuration; layout adaptation of user interface (UI), forms, and reports; custom fields and logic; integration; and custom terminology and translation to customer-specific applications. Extensibility in the SAP S/4HANA suite can be categorized into two main parts: side-by-side extensibility through SAP HANA Cloud Platform and in-app extensibility through built-in capabilities.

Monday 19 November 2018

Building an App on SAP HANA Express – Part 1, Installing Linux

A while back, my friends at Intel were kind enough to give me a NUC. Thanks, Intel! Anyhow it was time to give it a whirl, so I got it out the cupboard and decided to put SAP HANA Express on it.

In this series of blogs, I’m going to take you through getting HANA Express running on a NUC and building an application based on a publicly available dataset. The same principals will work if you want to install HANA Express on any system.

Saturday 17 November 2018

HANA Fallback Snapshot – HANA 2.0 SP 03


This blog provide you an information on fallback snapshot, a new feature that has been introduced in HANA from HDB 2.0 SP 03 version.

Thursday 15 November 2018

Configuration and setup HANA XS Apps with HANA DB SSO (BASIS Activities)

This is a long time coming blog from me and below are some of the steps that I used to configure the SAP HANA XS apps (HANA live apps) such as KPI modeler, Analytics foundation apps and so on for which the content is in the HANA DB (In the form of the HANA delivery units we apply for those apps) but the apps are viewed in the FIORI URL. So to make this perfectly work we have below steps such as applying the delivery unit for the app, Web Dispatcher routing configuration, SSO between ECC ABAP and HANA DB and finally replication of ABAP users in HANA DB. Though these configurations are used less now a day, due to the introduction of S4 and its own FIORI apps but the different steps and configuration explained here can be used in different use cases.

Monday 12 November 2018

Table Functions in SAP HANA – step by step guide

SAP HANA Table Functions

Recently I spoke to multiple developers working on SAP HANA Native system for developing reports. What really surprised me was the fact, that most of them are still using calculation views of a SQL Script type instead of Table Functions. What is more, some of them were even not aware that these type of views are deprecated and replaced by Table Functions. I also haven’t found any step by step tutorial describing when to create Table Functions, how to do that, what are the benefits and how to consume them in calculation views.

Saturday 10 November 2018

Connecting Servlets to HANA as a Service on Cloud Foundry


This tutorial will help you creating in a servlet and deploy it to SAP Cloud Platform with a Cloud Foundry instance using Eclipse.  The Eclipse landscape has been updated since the aforementioned blog was written and some of the prerequisites have changed for Eclipse. Additionally, this tutorial will connect the sample application to a HANA database schema on SAP Cloud Platform.  The tutorial uses JNDI and traditional SQL which is a common means to access the database.

Tuesday 6 November 2018

Setting up a HANA Express Python Machine Learning API Demo VM

This is a step-by-step guide to setting up a HANA Express(HXE) VM for demonstrating the Python Machine Learning API with functioning demo application.

The goal is to eventually provide an automated script to perform all the required actions. Currently some steps require user authentication and can’t be performed automatically.

Friday 2 November 2018

Implementing HANA Information view to calculate distance between Cities Using Geo-Spatial Functions

This blog is intended to share my experiences on Geo-Spatial Functions implementation in SAP HANA. One of the implementation is implementing Information view to calculate distance between Cities Using Geo-Spatial Functions which I am sharing today.

Background: Geo- Spatial function used geospatial data which stored in a geographic information system (GIS). The geospatial data needs to be combined with data from the internet and sensor data, data from business partner to implement point to point implementation, to manage coordinates of different stores, warehouse, utilities of an organization, business for real-time analysis, reporting, forecasting, threat detection.

Thursday 1 November 2018

HANA Housekeeping using HANACleaner


The blog provide guidelines on the necessary steps that needs to be followed to automate housekeeping task using SAP HANACleaner script.