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.