Tuesday 27 February 2018

Compute Distance using a Calculation View – XS Advanced Model

We’re going to learn how to create a Graphical Calculation View to calculate the distance between two locations or coordinates represented by a longitude and a latitude. We assume that some of these locations or coordinates are already known and the other is an input from the user.

This is achieved by using the HANA spatial capabilities. HANA support three spatial reference systems (SRS) by default. For this blog we will use the WGS84 – SRID 4326 SRS because HANA supports it and the coordinates used are based off Google Maps.

Friday 23 February 2018

Use Excel to query and analyze HANA data


For decades, Microsoft Excel remains as the tool of choice to many users for data analysis. Even In the modern BI era, the “Export to Excel” is a must-have feature to many BI tools. In HANA world, we could hear the question from time to time inquiring how to connect Excel to HANA. This blog aims at introducing a new way, which is also completely free, to connect Excel to HANA. It overcomes the limitations of existing methods, and can be a great companion to HDBStudio to improve the interactive HANA data query and analysis through Excel.

Wednesday 21 February 2018

SAP HANA Text Mining Functions – Part 1

In this blog, we’ll discuss Text Mining Functions.  Functions available to find top ranked related and relevant documents and terms.

Figure 1 shows the permutations and combinations available for doing Text Mining.

Monday 19 February 2018

End to End Development – SAP HANA and Web IDE

In this blog, we cover end to end application development starting from creating a database table in SAP HANA, develop virtual data models on top of database tables and finally use Smart templates available in Web IDE to create a Fiori Application consuming virtual data models.

Smart templates, also known as SAP Fiori Elements, provide a framework for generating UIs at runtime based on metadata annotations and predefined templates for the most-used application patterns.

Saturday 17 February 2018

Installing SAP HANA database using self service on SAP Cloud Platform

A new capability was released on SAP Cloud Platform to allow customers to perform installation of SAP HANA/ASE database instance in a self-service manner. Prior to this, there was a manual process in place. If a customer has an existing SAP Cloud Platform subscription with several subaccounts and decides to subscribe to a HANA DB, they would have to raise a support ticket requesting the assignment of a HANA DB to a particular subaccount. Behind the scene, the SAP Cloud Platform DevOps team would install the HANA DB and assign it to the requested subaccount.

Wednesday 14 February 2018

Enterprise applications with optimized costs – SAP HANA-based systems on Hetzner Online

In this article I would like to share my experience  of building our company SAP infrastructure and hardware costs optimization that we  have managed to achieve. Currently we have over 20 internal sap systems in our internal  landscape, including about 15 HANA-based installations. We use a combined approach with Hetzner Online and Amazon web services, and our average monthly expenses  for hardware rental are about EUR 1,000.  In fact, this is not a productive landscape, so most of those tricks  will not work once you have mission-critical systems. However, in many production  scenarios serious costs saving can be achieved, and this is what I am going to describe below.

Tuesday 13 February 2018

HANA 2.0 SP1 on SUSE 12 SP02

This time I will show you how to install SAP HANA 2.0 SP01 with latest patch on SUSE 12 SP02. I am not using Redhat because they refused to give me a trial with SAP repositories, so SUSE for the win.

Required SAP Notes

1984787 – SUSE LINUX Enterprise Server 12: Installation notes

2205917 – SAP HANA DB: Recommended OS settings for SLES 12 / SLES for SAP Applications 12

Friday 9 February 2018

Execute SQL Statement in HANA Studio using Literals or Bind variables

There are two variants of SQL statement execution defined in SAP note 2000002 – FAQ: SAP HANA SQL Optimization. The difference is how the where condition is specified in SQL Statement.

Sometimes I prefer to call “Literals” as “Hard code”.

Monday 5 February 2018

Publish Analytical View in Webi in simple steps

This document explains step by step to publish Hana views directly into Webi Rich Client in a simple steps.

Since, We are using BOBJ 4.2, we don’t have to create Universes for deploying our Views & We can directly deploy our HANA views in WEBI

This document will also give basic understanding of the basic development/creation of webi reporting after publishing the Analytical view in Webi

Sunday 4 February 2018

Migration Cockpit Migration Object Modeler S/4HANA Basics


It is a part of the Migration cockpit which integrates Custom objects or  standard objects not provided in the S/4 Hana Migration Cockpit template.

NOTE: Its available only on On-Premise systems

Friday 2 February 2018

SAP HANA 2.0 editions (2018) – by the SAP HANA Academy


The Feature Scope Description for SAP HANA has been updated for 2018. In this blog, you will find a brief overview of the feature sets with references to SAP HANA Academy tutorial videos and playlists.

Thursday 1 February 2018

Establishing the Live HANA on-premise Connection from SAP Analytics Cloud using CORS

The HANA CORS (Cross Origin Resource Sharing) configuration is straight forward but as the old saying goes, a picture paints a thousand words.  Such a shame that the SAP documentation policy is does not allow screenshots.  I have therefore tried to capture the configuration steps here.

SAP Analytics Cloud Version 2018.1.0
SAP HANA Version 1.00.111 (SPS 11).