Friday 31 May 2019

Generate certificate and add to SAP HANA Certificate Store


This blog helps to Generate Certificates and add it to HANA Certificate Store and Configure Certificate Collection while configuration of Principal Propagation to SAP HANA XS on SCP.

Am highlighting a section where we are unable to find the certificates after configuring the Trust in SAML Identity Provider.

Wednesday 29 May 2019

Understanding HANA has never been this easy

Though a lot of materials can be found online talking about HANA, its features/advantages and so on. This blog is for newbies in HANA and will brief about HANA in very simple words.

Before we embark on our journey, lets define 3 most confusing terms which often thought to be similar by beginner.

   HANA                  Suite on HANA                   S/4 HANA

HANA is a database and S/4 HANA is the application that uses this database.

Monday 27 May 2019

Develop Simple on HANA Express in AWS Cloud 9 Part 3 – The Frontend App


In the third part of this series, I will cover creating a basic Vue frontend to consume our backend service that we created in Part 2.


Cloud 9 set up and configured as described in Part 1
Backend created as described in Part 2

Wednesday 22 May 2019

Develop Simple on HANA Express in AWS Cloud 9 Part 2 – The Backend App


In the second part of this series, I’m covering how to create a simple backend NPM module that will run inside of a container and be added to our Docker Compose stack from the first part of the series. The end result will be the ability to issue an http POST call that is routed with the Node express npm module and get back some system metadata about the HANA Express instance. The Express routing will serve as a framework for similar API calls we will write in further parts of the series. Also in further parts, we will write Vue frontend web app to consume these calls and show in a web browser.

Monday 20 May 2019

Develop Simple on HANA Express in AWS Cloud 9


This blog post started much simpler as a personal wiki set of notes on how to quickly set up a Cloud 9 IDE in AWS to use HANA. However, as I continued to document, the more I felt like this might be an interesting story/journey of mine to share. Probably the past 2 or 3 months, I’ve been on a personal journey of getting back into application/web development after many years of spending time in Analytics/BI/Design Studio SDKing etc.

Saturday 18 May 2019

Reverse GeoCode HANA Data with Google API

We recently came across a scenario with a client, where we needed to Reverse Geocode their coordinate information. In essence what that means, is that they’d provide latitude and longitude data, and we needed to retrieve the geopolitical information surrounding that coordinate, like street name, number, city, state, country, etc.

Friday 17 May 2019

SAP HANA & Data Warehousing for non-experts


A quick blog, triggered by 2 questions of a customer last week:

1. What exactly is SAP HANA?
2. What does SAP mean by “modern data warehousing”?

Wednesday 15 May 2019

Split table column value into multiple rows using SQL in SAP HANA


In this post I would like to focus on the similar scenario, but this time the challenge will be to do the same not for variable but for table column. SAP HANA enables STRING_AGG function for concatenating values from multiple lines into single string, however doing opposite is quite challenging.

Monday 13 May 2019

Using Dynamic Text in SAC Without Users Having to Input Prompts

Architecture: SAC using Live Connection to a HANA Database.

Many times in SAC we want to dynamically display a text based on some underlying values. In this scenario, we want to display the current Fiscal Year, Period and Quarter.

The underlying calculation view doesn’t have any optional or mandatory prompts, since the view itself was filtered to only return data for the current Fiscal Year, and the end users didn’t want any pop ups or filter bars to be displayed.

Sunday 12 May 2019

SAP BW/4HANA Migration – Authorisation

The simplification of object types in SAP BW/4HANA has an impact on authorisation objects. When converting a SAP BW system to a SAP BW/4HANA, authorizations for object types that are not available in SAP BW/4HANA (like InfoCubes) must be replaced by authorizations for corresponding object types (like ADSO).

Friday 10 May 2019

How To: Create Dataflow within BW/4HANA

What is a DataFlow Object?

The Dataflow object is a way to model your dataflow within SAP BW/4HANA within the Eclipse world.

It is a graphical feature which also enables you to create a dataflow from start to finish.

All created objects eg Datasource, ADSOs, InfoObjects etc are available for re-use within other dataflows.

Wednesday 8 May 2019

LDAP Based Authentication for SAP HANA 2.0


This blog provides details on the steps required to configure LDAP based authentication for SAP HANA 2.0. LDAP based authentication is of great help for below two reason to the users –

Monday 6 May 2019

BW4HANA Modeling Scenario Step by Step

The purpose of this document is to provide details on how to do modeling in BW/4HANA with steps. The reader would get the look and feel of the new eclipse based modeling in BW/4HANA and how to create a data model flow in BW/4HANA.

BW/4HANA modeling is eclipsed based and happens within the HANA Studio. The BW GUI still offers a representation of classical administrative workbench without the key modeling capability.

Friday 3 May 2019

New R and enhanced Python API for SAP HANA Machine Learning – Released!

I am going to focus on two exciting capabilities – the new R and the enhanced Python API for SAP HANA Machine Learning.

Key Points

◈ The API’s are now generally available from April 5th with the release of HANA 2.0 SPS 04. You can download the packages multiple ways, for example with the HANA Express Download Manager and can get started straight away, for free!