Monday, 26 June 2017

Making use of an Active/Active (read only) HANA database in S/4 HANA part 2: Architecture Overview

In the first part if this blog series I described the motivation to use a secondary SAP HANA database for executing expensive analytical queries. In block diagrams, I showed the major building blocks:

Friday, 23 June 2017

Making use of an Active/Active (read only) HANA database in S/4 HANA


At SAP, we thought about creating additional benefit for customers who run SAP S/4HANA on premise.

Many of them in fact run two SAP HANA databases in a SAP HANA system replication setup: the productive SAP HANA database (aka the primary SAP HANA database), and an additional ‘hot standby’ SAP HANA database (aka the secondary SAP HANA database). The latter is part of their high availability strategy and allows business continuity in case of a failure of the primary SAP HANA node.

Thursday, 22 June 2017

Configuring BI Platform to open Lumira discovery HANA document created using OLAP HANA HTTPs connection

Lumira 2.0 supports HANA live connectivity via INA over HTTP/HTTPS. Know more on how to get your user have the relevant rights and roles to get this connectivity working.

Lumira 2.0 Discovery can successfully leverage your HANA OLAP connections (managed connections in BI platform). This connectivity is over HTTP protocol and we recommend that you have it configured for secure communication i.e. HTTPS.

Wednesday, 21 June 2017

Step by step how to create a local SAP HANA connection with Analysis for Office 2.x

Create HANA local connection to an SAP HANA server with Analysis for Office 2.x version it easier and simple to configure. A local SAP HANA connection is created in the Select Data Source dialog.

With right click on the “select data source” you will be able to create the connection as you can see on the below images. Before create the connection you need a specific configuration that you can see below:

Tuesday, 20 June 2017

How to Subscribe to SAP Product Support “SAP HANA” WhatsApp Broadcast List

The new SAP Product Support “SAP HANA” WhatsApp Broadcast List is now available for SAP customers.  SAP customers can get the latest and most relevant SAP HANA updates.

Here are the instructions to subscribe to the list:

1. From your mobile device, click here to access to the Product Support “SAP HANA” broadcast list subscribe link. Make sure to have WhatsApp downloaded to your device.

2. After clicking on the subscribe URL, you will see below widget. Click on the WhatsApp box in the widget as shown here.

Monday, 19 June 2017

SAP HANA EXPRESS XSA Application Part 3

We will continue building our XSA application. To recap, we have created an HDI module and Node.js module. Please refer the below links for the same.

Part 1 : HANA XSA MTA project and HDI Module

Part 2 : Node.js Module

Right click on the project name and create new SAP Fiori Master Detail Module. Follow the wizard steps and provide the required information.  ODATA metadata will be of xsodata service from Node.js module.

Saturday, 17 June 2017

XSA Python Buildpack Generator

The following is to provide an example of an XS Advanced Buildpack in order to support an upcoming TechEd 2017 lecture :

HDB100 – SAP HANA Extended Application Services and BYOL (Bring Your Own Language)

Normally, this would be provided via a git repo(and may yet be), but for now I’m providing it as a bash script.  Open a new file called create_my_python_buildpack, edit it, paste the following script into it, chmod 755 it, and then run it with the name of a directory the will be created containing your python buildpack.

 ./create_my_python_buildpack my_python_buildpack

Friday, 16 June 2017

SAP HANA Cloud Smart Data Integration for Real World Implementation Scenario


Due to the intense promotion of SAP HANA (Cloud) Platform Smart Data Integration, I see that the easy integration of multiple sources and data utilization in the cloud has been growing in the market and therefore is sufficient justification to go for this tendency more and more.

Thursday, 15 June 2017

Connecting Insights for ArcGIS to HANA

Insights can reference data in databases, in ArcGIS (your content, your organization’s content, Esri supplied demographics and so forth), and in spreadsheets.  The connectivity from Insights to HANA incorporates specific optimizations to maximize performance.  This means Insights can, with ease, fetch and manipulate large data sets returned from HANA.

Wednesday, 14 June 2017

SAP HANA EXPRESS XSA Application Part 2

In this part, we will continue developing our XSA application with Node.js module for business logic.

HANA XSA MTA project and HDI Module

1. Right click on the MTA project name and create Node.js module New->Node.js Module. Complete the steps in the wizard.

Tuesday, 13 June 2017

SAP HANA EXPRESS XSA Application Part 1

SAP HANA EXPRESS 2.0 provides us with SAP WEB IDE for HANA , enabling us to develop XS Advanced application supporting Node.js as well as JAVA framework. With this series of blog, I will share my first XSA application having database module for database artifact, Node.js module for XSODATA services i.e. business logic as well as user interface module based on SAP FIORI Master detail template.

Monday, 12 June 2017

Remediation for HANA Migration

Before migrating to HANA platform, the custom developments in SAP need to be remediated for HANA compatibility as explained in SAP Note 1912445.

Steps to be followed:

1. Identify the code where modifications are required.

 Execute SCI for custom developments with check variants as ‘FUNCTIONAL_DB’ and ‘FUNCTIONAL_DB_ADDITION’.

Saturday, 10 June 2017

SAP HANA ABAP: SQLScript: Functions Part-1

The Goal of AMDP implementation is always to remove any additional logic required at the abap layer i.e. avoid loops, further joins, formatting or data conversions. To achieve this, we can leverage HANA SQL functions to ensure the that the data being returned from AMDP is complete and needs zero or a light touch while passing to the ABAP Layer.

Using the below explained functions we as a HANA developer can make our lives easier.

Friday, 9 June 2017

New SAP Help Portal Goes Live: What it Means for SAP HANA Dynamic Tiering Users

Getting to the Content

To find the dynamic tiering documentation, just search for “dynamic tiering” or “SAP HANA dynamic tiering” from the homepage.

SAP HANA Dynamic Tiering Users, SAP HANA Certifications

Thursday, 8 June 2017

Text join using pa0000 table in hana

I am sharing you concept called text join in HANA, which we mainly use to extract descriptive data from a table or language specific data from a table.

Text Join is used in order to get language-specific data.

Text Join is used to fetch the description based on user’s session language. Once we implement the text join in SAP HANA, it automatically find out user’s language and give description in that language.

Wednesday, 7 June 2017

Port Forwarding SAP HXE instance (VM) to allow connection from SAP BO 4.2 on the Cloud

In this post I will show you how I succeeded connecting SAP BO Platform 4.2 on the Cloud with my local SAP HXE instance (VM) for educational purposes only.


In my case, I do not have any of the SAP BI Client Tools, such as SAP BO IDT, SAP BO Webi Rich client, SAP Design Studio, and so forth installed on my devices. Reason is because I do not have authorization to download any software from SAP Download Center (which makes sense). So, my only gateway is the SAP BI Launchpad.

Tuesday, 6 June 2017

New Hana backup software

Hello, I would like to present a new backup software that we N’Ware Technologies have been developing to support our customer running on Hana.

We made this backup software because existing backup software were missing basic functionality or were complex to use.

linux Bash scripts/windows dos scripts to automate backups are complex to the normal user to manage. It requires specialized knowledge on how to use the command line, sometimes on linux that user might not know, and offer no other functionality than the basic 1 backup per day.

Monday, 5 June 2017

Calling HANA Stored Procedure from Abap class and scheduling it through Process chain (using AMDP – Abap managed database procedure)

This blog will explain below –
  1. Creation of Repository Stored Procedure
  2. Calling Stored Procedure through Abap class
  3. Calling Abap class in Abap program and scheduling through process chain
The environment here is BW on HANA. The data modelling was done in SAP HANA view and there was a need to read the output of the view and persist it in the HANA table. Stored Procedure was written to read the data from HANA view and insert the data into HANA table.

Friday, 2 June 2017

How Classify The Classes based on Percentage in SAP HANA

Degree classification has a long history in our universities. It is widely accepted by students, parents and employers as the measure of academic achievement.

In this blog I am classifying the Student classes based on there percentage. If Student get above 60 percentage then they will get “FIRST CLASS” or If Student get between 60 to 50 percentage then they will get “SECOND CLASS” or If Student get below 50 percentage they will get “THIRD CLASS”.

Thursday, 1 June 2017

How To Find Average In Calculated Column Using Calculation View In SAP HANA

Average : The sum of all of the numbers in a list divided by the number of items in that list.

In my calculation view I am taking student four subject marks and finding the average to that marks using Calculated Column.

Calculated Column : It is an additional column which can be created by us, the results of which are calculated at run time based on the existing column and using either functions, input parameters and constants.

Sunday, 28 May 2017

NVM – HANA game changer?

The topic non-volatile memory (NVM) was hot as hell. A lot of people defined it as a game changer in the context of HANA.

Friday, 26 May 2017

Core Data Services [CDS] in SAP S/4 HANA

A data model represents framework of what relationships are in a database. Data models are the foundation of software development. They provide a standardized method for defining and formatting database contents consistently across systems, enabling different applications to share the same data.
Professional data modeling tools provide a way to generate SQL from a modeled ER diagram although some developers often prefer writing SQL directly. Below is a look of a data model.

Thursday, 25 May 2017

How To Calculate Student Average Marks in SAP HANA Studio Using Calculation View

Scenario : In This Scenario I am going Explaining about Calculating Student Average Marks using Calculated Column in Calculation View.

Calculation Views are used to combine other Analytic, Attribute and other Calculation views and base column tables. These are used to perform complex calculations, which are not possible with other type of Views.

Wednesday, 24 May 2017

Hana DR – Replication of INI parameters

Before Hana SPS12 we always have to manually setup the INI parameters on the secondary site after a change in the primary. It is not a tough thing to do nevertheless SPS12 introduced a feature to get a synchronization between the systems in a DR scenario also for INI parameter changes. One more step in the Hana synchronization and in my opinion it’s welcome.

I’ll not go into the replication configuration steps just describe my findings on the INI replication subject. Hope you get it useful.

Monday, 22 May 2017

S/4 HANA Trial Balance CDS View

We were very excited when we discovered the standard SAP delivered CDS C_TRIALBALANCEQ0001 for displaying the Trial Balance as the calculation of opening and closing balances can be tricky and the Universal Journal ACDOCA table was new to us, as was S/4 HANA.

During our testing using the embedded BW we realised that the opening and closing balances it was returning was incorrect and upon consultation with SAP they confirmed that additional new Fiscal configuration is required on an S/4 HANA environment.

Friday, 19 May 2017

SAP HANA 2.0 SPS 00 What’s New: High Availability


we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA 2.0 Support Package Stack (SPS) 00.

Thursday, 18 May 2017

SAP HANA 2.0 SPS01 : What’s New for SAP HANA License Implemetation

Introduction: SAP HANA License keys are installed for uninterrupted usage of HANA database. You can install or delete HANA License keys using HANA studio, SAP HANA HDBSQL command line tool and HANA SQL Query Editor.

Types of License keys

SAP HANA system supports two types of License keys −
  • Temporary License Key − Temporary License keys are automatically installed when you install the HANA database. These keys are valid only for 90 days and you should request permanent license keys from SAP market place before expiry of this 90 days period after installation.

Wednesday, 17 May 2017

SAP HANA Security: Granting Object Privileges with Repository Roles

This blog explains how to use the SAP HANA Web-Based Development Workbench to grant object privileges with repository roles in SAP HANA.

SAP HANA Web-Based Development Workbench

The SAP HANA Web-Based Development Workbench editor, hosted within the XS engine, provides an interface that you can use to build and test development artifacts. From a security perspective, we can use this interface to create and manage repository-based roles. This interface offers all the advantages of repository-based roles without the need to define those roles using scripts. The interface is not exclusive, meaning that you can edit repository-based roles created using scripts with the GUI interface, and you can edit a repository-based role’s scripts, those created using a GUI, in SAP HANA Studio. This flexibility allows the security administrator to manage the repository role using either interface.

Tuesday, 16 May 2017

Consuming SAP HANA Express Edition information models in Microsoft Power BI using live connection

Initially I created my account at I also subscribed for the Microsoft Power BI YouTube channel.

so, I decided to play around connecting Power BI with my SAP HXE instance. Generally speaking there are two ways of connecting and consuming SAP HANA information models in Power BI: Import and DirectQuery. For this post, I will be showing my SAP HANA live data connection with Power BI (DirectQuery).

Monday, 15 May 2017

HANA Deep Insert

I have been very impressed with HANA and the ease in which you can expose an OData service for your entities and views. Since starting work on the platform I have found the need to store my entities using a deep insert. I thought surely this was possible, but like many I have been disappointed to find that this is not supported.

Currently the solution to this problem is to place the creates into a batch in the front end. My main issue with this is the parent Id is not returned to me to place into the child objects. I am then forced to place the child create in the success handler of the parent object create, losing the transaction functionality.

Friday, 12 May 2017

SAP HANA passing value from one input parameter to other for filtering table

I am going to explain how to pass value from one input parameter to other parameter and filter the underlying table without any process change in the view.

CV_xxx_BASE View before changes

Configuration of input parameter in current view was as under

Parameter Type : Direct

Semantic Type : Date

Data Type : Date

Thursday, 11 May 2017

SAP HANA Multitenant Database Containers (MDC) Features Chart

Starting from HANA 2.0 SPS01, Multitenant Database Containers (MDC) will be the standard and only operational mode for SAP HANA systems, and definitely one of the significant changes that will have greater influence, affect directly or indirectly on customers’ systems that are currently running on single container but plan to update to HANA 2.0 SPS01+ and above anytime soon or in near future.

Want to know the differences and the developed of MDC with more supported features and less limitations compare to years ago when it first introduced on HANA 1.0 SPS09+ ?

Wednesday, 10 May 2017

Avoiding HANA Enterprise Cloud Headaches!

A source told me that one of the largest SAP customers in the (ANZ) region is moving from HANA Enterprise Cloud (HEC) back to an on-premise infrastructure model. Well, this was not surprising for me as I already knew some customers in Europe also moved from HEC to on-premise or other cloud offerings, due to unexpected and unforeseen issues with the HEC model.

I am aware that the majority of the businesses still can’t simply justify the business case for HEC, and it is disappointing to see that some existing customers don’t get the expected business benefits from this model.

Tuesday, 9 May 2017

Restore SingleDB on 122.08 to Multi Tenant DB on HANA 2.0 SPS01

Just tested recover a single Database to Multi Tenant Database without the need to convert them to MDC beforehand with below scenario and thought it is a good idea to share.

This enhancement only work on target >= HANA 2.0 SPS01 and is particularly useful where it keeps your source/ productive database intact and allows you to to perform a series of testing before converting them to MDC, especially if you plan to upgrade to HANA 2.0 SPS01 since MDC would be the standard and only operation mode.

Saturday, 6 May 2017

The AWS IoT Button and SAP HANA express edition

I’m a sucker for new toys and tech and when I can take something new and within a short period of playing around actually connect it to SAP I’m on top of the world.

SAP HANA Tutorials and Materials, SAP HANA Certifications, SAP HANA Guide

Friday, 5 May 2017

HANA Backup and Recovery: Multi-streaming Data Backups with Third-Party Backup Tools

SAP HANA uses one channel for data backups, by default. With the introduction of SAP HANA SP11 we have new functionality available to make it possible to considerably speed up the backup time by distributing backup data in parallel to multiple devices by using third party back-up tools.

When multiple channels are used, SAP HANA distributes the data equally across the available channels. All the parts of a multi-streamed backup are approximately the same.

Thursday, 4 May 2017

SAP HANA High Availability and Disaster Recovery Series

My purpose is to deep-dive into the entire SAP HANA high availability (HA), fault recovery (FR) and disaster recovery (DR) concept including the high-level overview of ALL available HA, FR and DR options, different configuration and setup methods and key benefits and trade-offs of each technology. I aim to provide deeper, clear and broader information in SAP HANA HA and DR technologies unlike the majority of confusing and contradictory information available on the internet. At the end of the day, you will be able to compare all available DR, FR and HA options, learn how to ensure your system’s operational continuity and decide the most suitable approach for your own data center readiness scenario to meet the business requirements.

Wednesday, 3 May 2017

Migration of SAP Systems to SAP HANA


This document provides a starting point for the planning of your migration procedure of SAP systems to SAP HANA in an on-premise landscape. Beginning with an overview of available migration path options, we provide a general recommendation and further aspects and guidance how to identify the best procedure for your requirements. Take these aspects into the discussion with your cross-functional teams and use them as basis for an individual assessment based on the boundary conditions you are facing.

Tuesday, 2 May 2017

Migrating the SHINE Purchase Order Worklist Application from SAP HANA XS Classic to SAP HANA XS Advanced.


To perform a migration you need to be aware of the files that are not supported by the migration assistant und migrate them manually in advance. How to do this manual step, is described in the official documentation.

Prepare the XS classic source system.

Monday, 1 May 2017

A short overview of the SAP HANA Performance Management Tools in SAP HANA 2.0 SPS00

SAP HANA capture and replay

Testing application workload can be a huge effort for users, developers and consultants alike. Also, things do not get easier on a large scale, especially for moving from one revision or SPS of SAP HANA to another.

Initially released with SAP HANA1 SPS12, SAP HANA capture and replay offers semi-automated support for integrated testing in the context of SAP HANA., the goal being to simplify the manual effort needed for creating tests and performing a more accurate replays than what is possible with other approaches.

Sunday, 30 April 2017

Single sign on with Spring Security SAML and SAP HANA

SAP HANA provides users the ability to authenticate using a valid, trusted SAML assertion token. Recently, I was asked to demonstrate this ability to authenticate with a trusted SAML token from a Spring Security web application. So, I laid out a scenario as shown in the figure below.

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifications

Friday, 28 April 2017

Enterprise Readiness with SAP HANA – Storage & System Replication between data centers

Having covered the Build phase in our last blog on system replication within the data center, we will now cover in this blog the phase on running the data center. The run phase focuses on helping IT managers to operate and execute the data center readiness stages of disaster recovery, monitoring and administration, as well as security and auditing. In this blog, we will focus specifically on the storage and system replication technologies currently available for the IT manager.

Storage & System Replication

For large enterprises running multiple data centers, SAP HANA has two disaster recovery features: storage replication and system replication. These are based on the current offerings SAP HANA already has at the node level, which we covered in the previous blog. The table below provides a brief overview between the two offerings and their implications.

Thursday, 27 April 2017

Enterprise Readiness with SAP HANA – Host Auto-failover, System Replication, Storage Replication

Continuing on from the earlier blog on Backup & Recovery that we covered last year, we will focus on the Building phase for data centers as we continue this topic in 2017. This segment will focus on what happens inside the data center, and specificically the high availability capabilities and options by SAP HANA, which can be deployed according to the IT managers’ landscape requirements. Of particular focus would be the System Replication feature, which will be explained in detail.

Wednesday, 26 April 2017

Choosing the right HANA Database Architecture

I have realized that especially after the recent release of “more advanced” S/4 HANA products, the SAP community is now more focused on cloud, on premise or hybrid deployment options and it seems to me that the actual underlying SAP HANA database architecture is usually overlooked even though it is the core of the entire implementation. In case you end up with wrong HANA database architecture, it would be really hard to have a proper high-availability and disaster recovery setup in your landscape no matter where you deployed it – cloud or on premise. And remember, when it comes to architecting SAP HANA, there are 3 key elements must be considered carefully; scalability, effectiveness and fault tolerance. In this article, I aim to provide detailed information regarding the current available SAP HANA database architecture and deployment options.

Tuesday, 25 April 2017

Fiori Launchpad in SAP HANA 2.0 SP01

SAP Fiori launchpad is the strategic single point of entry for SAP business applications and analytics. It offers a role-based, personalized and real-time access for end users.

If you are not familiar with Fiori UX and Fiori Launchpad you can find more information here.

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifications

Monday, 24 April 2017

How to send data from Apache NIFI to HANA

NIFI is a great apache web based tool, for routing and transformation of data. Kind of an ETL tool. In my scenario, I am trying to fetch tweets from the Tweeter API, and after that, I wanted to save them to hadoop, but also, filter them and save them to HANA for doing Sentiment Analysis

My first idea was to save them to hadoop, and then fetch them to HANA, but after discovering NIFI, it was obvious that the best solution was to fetch the tweet, then format the json file, and then insert it on HANA.

Why nifi? the answer is simple, it is very intuitive and simple to use. Also very simple to install, and it is already integrated with twitter, hadoop, and JDBC. So it was the obvious choose for my idea.-

Sunday, 23 April 2017

New in SAP HANA, express edition: Streaming Analytics

SAP HANA smart data streaming (SDS) is HANA’s high speed real-time streaming analytics engine.  It lets you easily build and deploy streaming data models (a.k.a. projects) that process and analyze incoming messages as fast as they arrive, allowing you to react in real-time to what’s going on. Use it to generate alerts or initiate an immediate response. With the Internet of Things (IoT), common uses include analyzing incoming sensor data from smart devices – particularly when there is a need to react in real-time to a new opportunity – or in anticipation of a problem.

Friday, 21 April 2017

Using Data Management Strategies to Simplify the Move to S/4HANA

When it comes to considering the move to S/4HANA, many companies are concerned by the short-term pain points that accompany the transition – even though the future benefits are so clear. While SAP provides many tools and support to make the transition as seamless as possible, many companies prefer to delay the transition and wait and see what the future holds. But “wait and see” is not a very viable business strategy.

Organizations must look for ways to simplify the move to S/4HANA and increase the ROI. The same strategies are applicable when migrating BW and/or Business Suite systems from any legacy database to SAP HANA.

Thursday, 20 April 2017

Unpivot Data In HANA Using a Graphical Calculation View

UNPIVOT data is a common requirement especially when we try to covert MS SQL query into SAP HANA data model. I ran into one such requirement, we had ETL data from MS SQL server to SAP HANA Enterprise and while converting one MS SQL model into HANA model I came across a Select query in MS SQL server where they were using UNPIVOT in Select statement.

I am using a simple example to explain how we can UNPIVOT data in HANA using Graphical Calculation View.

Wednesday, 19 April 2017

What is really changing with SAP HANA 2.0 SPS 01?

This new release includes enhancements for database management, data management, analytical intelligence and application development.

This release also includes another important change which will have a greater influence on the landscape configuration and sizing of SAP HANA and will definitely encourage people to become more creative and flexible with the technical architecture.

Starting with SAP HANA 2.0 SPS 01, multitenant database containers (MDC) will be the only operational mode for SAP HANA systems. This means that if you upgrade to SAP HANA 2.0 SPS 01, you will no longer be able to run a single-container HANA system.

Tuesday, 18 April 2017

SAP HANA Express: Exposing Predictive Analytics through oData

The prerequisites for your SAP HANA instance:

  • A tenant DB, which you can create with the following command.


alter system start database DB1;

  • While we are abiding by better practices, it’s a good idea to create a Developer user instead of using the SYSTEM user for development.
  • A user with the proper permissions to execute the PAL functions and DROP/CREATE ANY in a schema (different from the AFL schema, please). The following is a sample list of roles taking into account what this blog needs, but you need to restrict permissions depending on your needs (you will also need CATALOG READ and the proper package privileges):

Monday, 17 April 2017

LEARN WITH US : S/4HANA Analytics!!

What it is?

S/4 HANA stands for Simple 4th Generation Business suite solutions from SAP which will run on SAP HANA. SAP HANA is one of the preferred product among the companies seeking for an optimized enterprise solution because the product has come a long way from its previous predecessors which had its transaction processing and analytical processing in different platforms, that meant more time on data output and decision making.

It is very well known as The Next Generation Business Suite and it is greatest innovation since R3 and ERP from the SAP world. It unites the software and people to build businesses to run on real-time, networked and in simple way. It has got built-in analytics for hybrid transactional and analytical applications.

Saturday, 15 April 2017

S/4HANA OP FIORI Apps: How to configure FIORI Apps?

At times, users come across many issues like system alias, services activation, server errors while testing Fiori apps in S/4HANA OP landscape. The issues are generally due to incomplete configuration.

Based on my learning, I am listing down the steps one can follow to setup Fiori apps in S/4HANA OP Landscape.

As OData services exists in gateway system, all the settings listed below are applicable to Gateway system.

Thursday, 13 April 2017

Multi-container database mode is the new default

Multi-tenancy features, also known as “multiple database containers” or MDC have been available in SAP HANA for several years already. With the new SAP HANA 2.0 SPS 01 release, all systems now run in multi-container database mode. All new systems are installed in multi-container database mode, and existing single-container systems are converted during the upgrade to SAP HANA 2.0 SPS 01.

Advantages of multi-container database mode

Systems running in multi-container database mode can very easily be extended by adding new tenant databases. Being able to run and manage multiple tenant databases in one system helps you to lower capital expenditure, simplify database management, or for example build multi-tenant cloud applications.

SAP PDMS 1.0 FP02 On-premise edition 1.0 (Configuration – Pt.2)

In the first part of my documentation (pt.1), I have explained and showed in detail how to proceed  with the mandatory landscape and component setup of the SAP Predictive Maintenance and Service solution.
In this second part (pt.2) I will explain and show how to configure the applications regarding:
  • Thing Model Service
  • Data Science Service
  • Insight Provider (Map, Asset Explorer, Components, Key Figures)

Wednesday, 12 April 2017

SAP PDMS 1.0 FP02 On-premise edition 1.0 (Installation – Pt.1)

SAP Predictive Maintenance and Service, on-premise edition supports customers with a unified solution for operators looking to identify issues in large fleets of machines as well as to improve after-sales services and optimize service planning for individual machines.

The following image gives you an overview of what business users see when they work with the asset health control center, to get further detailed information about an asset health status, business users can go to the asset health fact sheet:

Tuesday, 11 April 2017

The First Predictive BSM Solution for SAP HANA

SAP has reviewed and qualified Centerity Monitor as suitable for use in SAP solution environments

Technology cooperation between SAP Co-Innovation Labs and Centerity brings holistic Business Service Monitoring (BSM) capabilities to the entire SAP environment including SAP ERP, SAP Infrastructure, and SAP HANA. Centerity Monitor has been tested by SAP Labs and this post describes that testing process and SAP’s conclusions.

Monday, 10 April 2017

SQL Clients and SAP HANA 2.0

So recently I’ve been playing around a lot with our “Server Only” version of the SAP HANA, express edition (HXE). Now with that server only version I am mainly focused on just using more of the Database features than anything else. Trying SQL and working with the PAL libraries.

With our activities and ability to quickly load HXE into the Google Cloud Platform I also thought how else could I speed of some of my time. I mean I am only working with SQL on some of these things so could I use the JDBC driver and find a tool that would do nicely for it?

I’ve now tried a good half a dozen or so and decided that the current one I will play with the next few weeks would be DBeaver.

Friday, 7 April 2017

How to configure transports of XS Classic native applications

I recently needed to configure the transports of Delivery Units between a SAP HANA, express edition, (HXE)  instance in Amazon Web Services and one of my tenant databases in another HXE instance in Google Cloud Platform.

My destination HXE instance (some kind of QA environment) was originally a server-only to which I added the XS classic tools as explained in this how-to guide . The source instance plays the Dev environment in this scenario.  I wanted to transport from Dev into QA without manually exporting and importing Delivery Units.

In order to configure the transports and access the ALM tools you will need the following roles in the source/Dev system:
  • sap.hana.xs.lm.roles::Administrator
  • hana.xs.admin.roles::HTTPDestAdministrator
  • hana.xs.admin.roles::RuntimeConfAdministrator

Thursday, 6 April 2017

HANA Rules Framework (HRF)

HANA Rules Framework (HRF)

SAP HANA Rules Framework provides tools that enable application developers to build solutions with automated decisions and rules management services, implementers and administrators to set up a project/customer system, and business users to manage and automate business decisions and rules based on their organizations’ data.

In daily business, strategic plans and mission critical tasks are implemented by a countless number of operational decisions, either manually or automated by business applications. These days – an organization’s agility in decision-making becomes a critical need to keep up with dynamic changes in the market.

Wednesday, 5 April 2017

Paddling Upstream: How to find all HANA views that use a particular table/column


Find all HANA views that use a particular table/column.

If a field is dropped/modified from a table, identify the upstream model impacts.

Problem Faced:

Our team’s analytics was based on tables from multiple source systems.

There were instances where fields were being dropped from source tables as a part of continuous changes.

Tuesday, 4 April 2017

HANA Express Edition on an UBUNTU 16.04 LXC Container

I’m assuming you have a working Ubuntu 16.04 Server or Desktop installation, and you have the installation files by hand.
What we’ll do is:

  • Install required packages, 
  • create a network bridge, 
  • do some LXC config stuff, 
  • create a LXC container and 
  • install HANA Express Edition in that container. 

What we’ll get is:

  • A Hana Express Edition working in a Linux Contianer, 
  • all advantages of an isolated Virtual Machine, 
  • a much smaller VM memory footprint, 
  • and near bare metal speed.

Monday, 3 April 2017

R Integration with SAP HANA

Here are the prerequisites you must have before trying your hands on “R”



R-ODBC Package

R Studio

Setup the Data source (in this case SAP HANA DB Server)

Go to Service Marketplace -> Software Downloads -> Support Packages and Patches -> A-Z –> H–> SAP HANA PLATFORM EDITION” –> SAP HANA PLATFORM EDIT. 1.0” –> Entry by Component” –> HANA client

Saturday, 1 April 2017

HANA – table unload priorities

Many people still think all data in HANA which exists in the data area also loaded into memory all the time. Of course there are some techniques which influence the unload / placement of tables e.g. data aging and the non-active data concept of BW. Usually unloads happen based on a “least recently used” (LRU) approach, so the columns having not being used for the longest time are unloaded first. So HANA decides when it makes sense to unload some tables to free memory.

But what about your own tables? Can you also take influence when data are unoaded? For general information you can refer to 2127458 – FAQ: SAP HANA Loads and Unloads. Ok you can manually unload or load tables. But you want to do this automatically and want to understand when tables are loaded or unloaded.

Thursday, 30 March 2017

Replication setup using HANA cockpit 2.0 and testing Active/Active Read Enable


  • You have installed and configured two identical, independently-operational SAP HANA systems – a primary system and a secondary system.
  • The required ports must be available.
  • The same instance number is used for primary and secondary systems. The instance number +1 must be free on both systems, because this port range is used for system replication communications.
  • You have added both systems in the SAP HANA cockpit.
  • You have verified that the log_mode parameter in the persistence section of the global.ini file is set to normal for both systems.

Friday, 24 March 2017

S/4HANA – The engine to the Digital Transformation

Innovation Highlights

Our environment is changing, at an unprecedented pace and fast innovators hungry for success disrupted established markets. From 2000 to 2010, 52% of the Fortune 500 companies were gone and in the middle of last century, most companies though they would least forever. If you look back since 1955, the number is even bigger, +80% of the Forbes 500 companies have either gone bankrupt, been acquired or ceased to exist.

Wednesday, 22 March 2017

Google Sheets and Google Script calling SAP HANA Express

Of course, you will need to create a Google Spreadsheet. Once you are there, you need to create a Google script. It sounds complicated, but it is as easy as going into Tools -> Script editor.

SAP HANA Tutoerials, SAP HANA Materials, SAP HANA Certifications

Monday, 20 March 2017

Five stars to SAP HANA Express Edition on Google Cloud Platform

Ever since I installed my SAP HANA, express edition (HXE), instances on Google Cloud Platform I have been using them as my main platforms for development and different experiments. My experience has been so good that I feel it has to be shared so others do not miss on it.

What I like about Google Cloud Platform (GCP) is that it makes it extremely easy to get my SAP HANA instances up and running when and how I want them.

The web SSH client and GCloud console stand out as a star feature. Two clicks and you are logged in to the operating system, ready to cast some commands using the web interface.

SAP HANA Tutorials, SAP HANA Materials, SAP HANA Certifications
After building some applications and adding data into them, GCP warned me that my instances were overutilized and suggested a more cost-effective and better configuration. The statistics in the monitoring were in agreement, showing that the instances were hungry for more resources. Feeding more RAM and CPU to them was easy as sliding a bar or entering the exact amount of RAM I want and turning the machines back on.

SAP HANA Tutorials, SAP HANA Materials, SAP HANA Certifications

The only requirement to adding more resources is that the virtual machine is turned off.

This requirement also applies to taking a snapshot of your instance. Other than the traditional uses of HXE, I sometimes like to test different configurations or simply try what I would not dare do in a productive or even shared environment. A snapshot allows me to go back to the point where the virtual machine was up and running before, for example, locking myself out. The best part is that taking a snapshot and recovering it is almost as fast a CTRL+Z.

SAP HANA Tutorials, SAP HANA Materials, SAP HANA Certifications

Now, what you (and your wallet) have been waiting for: The Price. The basic instance can run on as low as 0.20 USD/hour. Because I keep three flavors of HANA Express Edition (server only, Server only + XS Classic Tools and Full XS Advanced installation), I tend to turn them on and off as I need one or all of them. I was expecting a big reduction of the free initial credit that I was lucky to get from Google Cloud Platform when I signed up, but no: Unlike many other providers, Google Cloud Platform bills you by the minute after a minimum of 10 minutes. In other words, not only is it unbelievably cheap but it also takes off the pressure of taking into account what time it is before you turn the instance off. You can take a look at the billing principles and estimate your monthly costs in their comprehensive pricing site.

SAP HANA Tutorials, SAP HANA Materials, SAP HANA Certifications

Google Cloud Platform also sends you weekly emails as well as the bill. Consequently, there are no surprises at the end of the month if, for example, you forgot to turn off one of your instances.

Do I need to remind you that SAP HANA, express edition, comes with a perpetual free license for productive use up to 32 GB RAM? In case this needs translation: You can have the transalytics, predictive, geospatial and real-time power of a world-class in-memory database licensed for free and a very low infrastructure cost.

Friday, 17 March 2017

How to have Predictive Analytics functions [PAL] embedded in sql scripted views and applied on data in HANA Modeling

Here we are going through how we can use the Predictive Analytics functions provided via PAL in HANA in the Scripted Calculated views .

We are following the SAP provided SAP HANA Predictive Analytics Library ( PAL ) guide to do this.

PAL provides a vast business opportunity and immense business value to cater the needs of Analytics domain in projects implemented on SAP HANA platform.

Wednesday, 15 March 2017

RFID Sensor Integration with HANA Cloud Platform

Business case: if there is any goods need to be track from warehouse, RFID technology might be a good choice. RFID sensors with HANA cloud platform will provide live tracking of goods.

Here is the below components being used to implement this business case,
  • RFID Reader : RFID RC522
  • RFID Tag
  • ESP8266 Wifi Module
  • Hana Trial Account

Friday, 10 March 2017

Five stars to SAP HANA Express Edition on Google Cloud Platform

Ever since I installed my SAP HANA, express edition (HXE), instances on Google Cloud Platform I have been using them as my main platforms for development and different experiments. My experience has been so good that I feel it has to be shared so others do not miss on it.

What I like about Google Cloud Platform (GCP) is that it makes it extremely easy to get my SAP HANA instances up and running when and how I want them.

The web SSH client and GCloud console stand out as a star feature. Two clicks and you are logged in to the operating system, ready to cast some commands using the web interface.

Wednesday, 8 March 2017

Internet of things in Manufacturing using SAP Hana

How Internet of things ( IoT ) are relevant to manufacturing space is a widely debated topic. As a goal of IoT  tries to deploy vast network of sensors, actuators and connect them with wire or wirelessly leveraging internet protocol. If you look at this basic goal or need then its obvious that there is major scope in manufacturing IT domain. Looking at the trends in manufacturing for two decades or so there is tremendous increase in usage of automation technologies or robotics. At larger context primarily all these IP enabled equipment’s and systems need to be integrated interms of data and hardware with larger SAP system. Its a interesting way to utilize SAP Hana in a cost effective way for real time manufacturing data.  I am proposing to utilize SAP Hana for collection and analysis of real time manufacturing data  and integrate the same with enterprise level SAP platform. I am sure seasoned enterprise architects  in manufacturing environment can put more light from technical perspective to make this solution work.

Sunday, 5 March 2017

Data Encryption Comparison between HANA 1.0 and HANA 2.0

Recently, I was dealing with the challenge whether I should implement server-side data encryption (with focus on data and logs) on our SAP HANA 1.0 SPS 12 system or I should wait with the implementation until the upgrade to latest release of SAP HANA, which is currently HANA 2.0 SPS 00.

For this purpose, I was analyzing the question what is possible to implement in SAP HANA 1.0 and HANA 2.0, regarded from a data and log encryption perspective. As many others might be exploring this, I wanted to share my findings with you.

Friday, 3 March 2017

Connecting From ArcGIS Desktop and Pro to SAP HANA

For starters, the HANA client you install depends on which ArcGIS product you’re connecting to SAP HANA. In these screenshots, I’m running HANA Express. Since HANA Express is a multitenant system, instance 00 in this case, the port used in the ODBC Manager is 30013.

If you want to connect ArcGIS Desktop to HANA, you will need to install the 32 bit HANA Client ODBC driver. For ArcGIS Server and ArcGIS Pro, you will need to install the 64 bit HANA Client ODBC driver. You will need SAPCAR.exe to unpack downloaded .SAR file containing the HANA Client.

Thursday, 2 March 2017

Best Practices for SAP HANA Application Life Cycle Management

Having worked with multiple customers in the Native HANA application development and analytics space, one challenge I have often seen is with migrating (or transporting – we use these interchangeably in this blog) the development objects to higher environments in the landscape. Before we get into the details of how to transport the objects, let us see how the development objects are organized in HANA.

Development content organization in SAP HANA:

The development content is organized as shown in Figure 1, the most granular element in the hierarchy is an Object – which can be a calculation view, xsjs code, xsodata code, hdbprocedure etc. These objects are grouped into Packages. A Delivery Unit (DU) can consist of multiple packages. Multiple DU’s make up a product.

Tuesday, 28 February 2017

Configuring SAP HANA One


  • Please note the IP address from aws marketplace and host name
  • Instance is running in AWS console and has passed 2X2 check.
  • Use Google Chrome (version 24 or higher) or Firefox Mozilla (version 18 or higher) web browser

Assign an Elastic IP Address

Assigning an Amazon EC2 Elastic IP Address (EIP) to your AWS instance eases the administration of SAP HANA One. Elastic IP addresses are static IP addresses that can be assigned to your instance and can also quickly be re-mapped to replacement instances if needed.

Thursday, 23 February 2017

The Road to SAP HANA & Beyond . . .

The Beginning!

I first heard about HANA when I was working with SAP in 2008 & then Around 2012, one of my Friends called me from BayArea to join his startup that is doing some work on SAP HANA, SAP’s in-memory database. I just remember it as a Database back then.

Then I heard about OpenSAP and I started taking courses on SAP HANA. I also took a course by Vishal Sikka, then SAP CTO.

Back then there was no such thing as S/4 HANA & many customers were just starting to hear about what HANA can accomplish for them.

Wednesday, 22 February 2017

Core Data Services – Standard Utilities / Reports


CDS Views can be created and viewed only from ABAP Development Tools (ADT) .The objective of this blog is to list down some standard utilities related to CDS Views which would allow us to gain information on these views from SAP GUI.

These reports will be useful for users who are not having access to ADT tools or not able to access the system from ADT due to missing authorization.

Tuesday, 21 February 2017

Supported SAP Product versions on HANA 2.0

“SAP has released SAP HANA Database 2.0 for SAP Kernel 7.49 64-Bit unicode and higher for certain operating system platforms. Therefore, SAP products that use these kernel versions, and are still in SAP Extended Maintenance after 2016 will be operated on SAP HANA Database 2.0.”

Above statement is from Note 2420699 – Release of SAP HANA Database 2.0 for older SAP Versions. Since Kernel version 7.49 is download compatible to SAP NetWeaver 7.4, Hence, we can assume below products are eligible to run on SAP HANA Database 2.0, with minimum version SPS0 Revision 001.

Friday, 17 February 2017

SAP HANA Authorization Tracing

This document will deal with issues regarding analytical privileges with SAP HANA.

So what are Privileges some might ask?

System Privilege:

System privileges control general system activities. They are mainly used for administrative purposes, such as creating schemas, creating and changing users and roles, performing data backups, managing licenses, and so on.

Wednesday, 18 January 2017

HALM Usage and Troubleshooting

What is HALM?

HALM stands for HANA Application Lifecycle Management, this image from the documentation explains the product lifecycle using HALM:

HALM Usage and Troubleshooting

Tuesday, 17 January 2017

How to Prepare for C_HANAIMP_12 Certification on SAP HANAIMP 12

All that you need to know about SAP C_HANAIMP_12

SAP launched HANAIMP 12 primarily based on in-memory expertise with which customers can analyze giant volumes of informations and data in flip of seconds. This post is about the certifications which can be obtained with on SAP HANAIMP 12. SAP certification builds on the fundamental knowledge gained through related SAP C_HANAIMP 12 coaching and ideally refined by practical experience within an SAP HANA project team, whereby the consultant applies the acquired knowledge practically in projects. SAP has made available only one Associate Consultant certification with code: C_HANAIMP_12. This exam primarily verifies that the candidate possesses the knowledge in the area of the SAP HANAIMP 12 for the profile of an SAP HANAIMP 12 consultant. Make sure you are able to gain complete understanding and firm knowledge on SAP HANAIMP 12 certification syllabus. That includes SyllabusTopic for excellence in certification exam. Learn and explore everything about the SAP HANAIMP 12 for the profile of an SAP HANAIMP 12 consultant Things that you should be aware of for C_HANAIMP_12
Get complete detail on The "SAP Certified Application Associate - SAP HANA (Edition 2016 - SPS12)" certification exam certification syllabus Below I have gathered all the data accessible to the very best of my knowledge related to the certification exam:
  1. How many questions are there in the exam?
      A: 80
  1. What is the duration of exam?

SAP HANA Tools-Modeler and Web IDE (New and Changed) – SAP HANA Platform 2.0 SP00

As of SAP HANA Platform 2.0 SP00, the following new features and changes are available in SAP Web IDE and integrated SAP HANA tools.

SAP Web IDE for SAP HANA is a browser-based integrated development environment (IDE) for the development of SAP HANA-based applications comprised of web-based or mobile UIs, business logic, and extensive SAP HANA data models. SAP Web IDE works in conjunction with the SAP HANA deployment infrastructure (HDI), the Application Lifecycle Management tools (ALM), the XS Advanced runtime platform, and various SAP HANA tools.

Friday, 13 January 2017

C_HANATEC_11 Certification Guide

All that you need to know about SAP C_HANATEC_11
SAP launched HANA Technology primarily based on in-memory expertise with which customers can analyze huge volumes of information and data in flip of seconds. This post is about the certifications which can be obtained with on SAP HANA Technology. SAP certification builds on the fundamental knowledge gained through related SAP HANA Technology coaching and ideally refined by practical experience within an SAP HANA project team, whereby the consultant applies the acquired knowledge practically in projects.
SAP has made available only one Associate Consultant certification with code: C_HANATEC_11This exam primarily verifies that the candidate possesses the knowledge in the area of the SAP HANA Technology for the profile of an SAP HANA Technology consultant.
Make sure you are able to gain complete understanding and firm knowledge on SAP HANA Technology certification syllabus. That includes topics like System Architecture, Users and Authorization, Security etc.

Thursday, 12 January 2017

Did you know you can add Spatial Reference Systems to HANA?

By default, HANA has 4 preconfigured Spatial Reference Systems (SRS).  Two of the preconfigured ones most used are 4326 (WGS 84 Spheroidal) and 1000004326 (WGS 84 Planar). However, there are over 3000 other spatial reference systems and many of our customers utilize some of them.  So how do you add additional ones?

Wednesday, 11 January 2017

Synonyms in HANA XS Advanced, Configuration, Templating, Service Replacement

In the previous post I showed the complete end-to-end scenario of using synonyms in XS Advanced. In this post I will show, how more flexibility can be achieved.

The flexibility options do not really depend on whether accessing a classical schema or a generated HDI Container. Everything that is different was explained in the previous post. I will therefore only use a classical schema OR an HDI container as target, not both. And I will focus on the things that are different with flexible synonym targets.

Tuesday, 10 January 2017

Synonyms in HANA XS Advanced, Accessing Objects in an External Schema

In the previous post I introduced synonyms in XS Advanced (XSA) and created a very simple synonym. Now I will create synonyms pointing to objects I defined by myself.
Accessing Objects in a Classical Schema

I assume, that the external schema I want to access is already existing. The example schema EPM_DEV can be created by using repo I also assume, there is already a project with a db module existing in the XSA Web IDE. We will insert the synonyms into this project. A git repo for the project with the complete coding can be found at

Monday, 9 January 2017

Synonyms in HANA XS Advanced, Introduction

Why Synonyms?

A complex HANA data warehouse might use several DB schemas in which tables, views and other
DB objects reside. E.g., there might be a replicated ERP schema managed by SLT, a Netweaver/BW schema managed by the Netweaver Stack, and a “native” HANA schema, all residing in the same HANA instance and all of them consumed by the same data warehouse application.

Friday, 6 January 2017

How to – Import SFLIGHT sample data into HANA from a local computer

As you discovered few seconds ago, HANA doesn’t come with any preloaded sample data.

So, before starting to play with your brand new system, you need to find and load some data.

Luckily SAP provides for free its flight data model (you can download it here unluckillly the previous link doesn’t work anymore; I will try to fix this issue asap) – it’s a good starting point since it contains a sufficient amount of data and a limited number of tables.

Thursday, 5 January 2017

Let’s Build an Analytical Card for a Fiori Overview Page (with a HANA Backend)

The Proposed Process

Step 1: Identify the need
Step 2: Design
Step 3: Back-end development
Step 4: Front-end configuration (or really development at this point)

Wednesday, 4 January 2017

Installing Hana Server (SP12) and XS Advanced Runtime Components

The main purpose of this blog post is to list the steps required to provision a Hana SP12 System as a development server, along with XS Advanced runtime components such as the Database Catalog Tool (HRTT) and WebIDE.

Note – In this blog post we will be using command line tools for the installation. However, the last few steps should be applicable to even if you used the GUI.

Tuesday, 3 January 2017

Constant Selection in SAP HANA Using Dynamic Join

In SAP BW, there is this concept of “Constant Selection” where you can mark a selection in the Query Designer as constant. This means that navigation and filtering will have no effect on the selection at runtime.

In SAP HANA, there is no feature that directly supports this functionality. We have to model it ourselves. One way to implement it is through “self joins” and “dynamic joins”.

Monday, 2 January 2017

Does your CFO need a real time geolocation report?

In a constantly evolving world, CEOs and CFOs must adapt continuously to their new market dimension. Having access to real time reporting gives a serious advantage on its competitors. Thus, CFOs can obtain the necessary information to have a real-time picture of their finance.
Real time reconciliation introduced by SAP Simple Finance solution increases the confidence index of financial reporting. In a more and more competitive world, CFOs can detect earlier business lines profitability decrease and take appropriate decision.