Generate certificate and add to SAP HANA Certificate Store

Introduction

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.

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.

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

Overview

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.

Prerequisites

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

Data Tiering Options in SAP HANA Webcast Recap

This was another great SAP User Group webcast this week.

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

Overview

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.

Develop Simple on HANA Express in AWS Cloud 9

Introduction

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.

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.

SAP HANA & Data Warehousing for non-experts

Introduction

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”?

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

Introduction

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.

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.

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).

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.

LDAP Based Authentication for SAP HANA 2.0

Purpose

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 –

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.

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!

BW/4 HANA Query Creation on Composite Provider using variable for selection

BW/4 HANA  Query Creation on Composite Provider using variable for selection

1. Create a query