Saturday 30 September 2017

Search UI on HANA

To search on the data present in HANA, there are some applications already available.

Recently a blog was published on Enterprise Search UI on HANA which is built using SAPUI5 and is very simple to use.

Once the setup is done, the UI can be launched using the URL which looks some like:

Wednesday 27 September 2017

Install SHINE for XSA on SAP HANA 2.0 Express Edition SPS02

The installation of SHINE (SAP HANA Interactive Education) for SAP HANA XSA on SAP HANA Express Edition 2.0 SPS02 is now more or less straightforward in comparison to SPS00. Therefore it is time for an updated post about the installation process of SHINE for XSA.

SHINE for XSA is the reference implementation of SAP HANA XS Advanced Programming Model which is a Cloud Foundry compatible programming model implemented on SAP HANA Platform. Main programming languages are JavaScript and/or Java. Defintely worth a look for every developer on this possible future development option. If you interested in deploying SHINE on SAP Cloud Foundry and want more insights on single SHINE parts.

Monday 25 September 2017

Basis Engineers’ Ultimate Guide for SAP Debugging

I think that every Basis engineer and SAP developer will agree with me when I say:

It can be REALLY painful to find the root cause of an issue in a complex SAP system.

SAP HANA Certifications, SAP HANA Tutorials and Materials, SAP HANA Guides, SAP HANA Learning

Sunday 24 September 2017

CDS Associations and Propagation with SQL in SAP HANA

As Part of HANA 1.0 SPS11, the New feature called CDS Associations implementation with the help of SQL instead having the dependency of CDS to create association among Database objects like tables, views.

Later as part of HANA 2.0 SPS00, an interesting new feature and an enhancement of the above one where the user is allowed to propagate the association while creating views.

Friday 22 September 2017

Reducing workload on HANA hosts by routing end user query

SAP HANA is known for its versatile capabilities as a database as well as a platform by providing solution for varied end user requirements.

HANA appliance has evolved from storing data in column/row store fashion towards serving as a data container for unstructured data too and helping end user to transform data set like xml and JSON to relational data structure and vice versa with at most ease.

Being a hub of solution for all the end user needs, SAP HANA also helps end user to avail the flexibility in query handling and fine tuning the performance of his/her operations performed on the database.

Thursday 21 September 2017

SAP HANA Smart Data Integrator on SAP HANA, express edition (HXE)

High level architecture

Any data integration must procure data and output data or information. To address the procurement and output of data there are components that need to play in harmony. Primary components of SAP HANA Smart Data Integration are:

Wednesday 20 September 2017

Bring the Power of SAP HANA to SAP (Sybase) Adaptive Server Enterprise Applications

Legacy Adaptive Server customers totally understand and appreciate the technical and economic benefits of a reporting database. Using replication server, many Adaptive Server customers are replicating to an Adaptive server reporting instance and running their reports against the reporting copy. Some are replicating into analytical engines like SAP IQ or third party databases like Netezza. But this requires rethinking and re-writing their Transact-SQL reporting applications and procedures.

General information about Data Aging

Many people heard about data aging in context of HANA. You see it on a lot of SAP slides with DLM (Data Lifecycle Management) or in BoH / S/4HANA context, books about HANA and especially in the result of the HANA ABAP sizing reports. In my opinion the naming here – “clean-up” – is a little bit  misleading. It is a bit more than just housekeeping and lot of things you have to pay attention to.

Tuesday 19 September 2017

Technical details about data aging

If you successfully finished my last blog post about data aging ‘General Iinformation about data aging’ it is time for the deep dive. How SAP has implement it and how it works in detail.

As you already have read partitioning is an elementary part of data aging process to separate the current from the historical. Therefor range partitioning is used with an additional column called ‘_DATAAGING’:

SAP HANA Tutorials and Materials, SAP HANA Certifications, SAP Guides, SAP Learning

Saturday 16 September 2017

Going for the Gold with a New Data Management Platform for Digital Transformation

As an avid fan of the Olympic games, I was reminded by the 2016 Rio games of the Olympic motto “Citius, Altius, Fortius” (faster, higher, stronger). Since their inception in 1896, the goal of the modern Olympics has been to provide an international forum where the world’s elite athletes could come together and compete. That is why the founder of modern Olympics Pierre de Coubertin said that “athletes need freedom of excess. That is why we gave them this motto … a motto for people who dare to try to break records.”

Thursday 14 September 2017 adapter for SAP SDI: replication of Salesforce data into HANA tables.

1. Overview

The Advantco SFDC adapter is an adapter for SAP HANA Smart Data Integration (SDI), its purpose is to batch load or to replicate changed data in real time from to the SAP HANA tables.

This blog describes in detail how to replicate Account data from in HANA tables.

Working with the predictive analysis library in HANA 2.0 SPS02

HANA 2.0 SPS 02 is now available and there have been a number of important updates to the predictive analysis library (PAL). The focus is on ease-of-use rather than introducing a bunch of new algorithms (though there are a couple).

In this blog I’ll introduce the updates and show you where to find hands-on tutorial videos:

Wednesday 13 September 2017

General information about Data Aging

Many people heard about data aging in context of HANA. You see it on a lot of SAP slides with DLM (Data Lifecycle Management) or in BoH / S/4HANA context, books about HANA and especially in the result of the HANA ABAP sizing reports. In my opinion the naming here – “clean-up” – is a little bit  misleading. It is a bit more than just housekeeping and lot of things you have to pay attention to.

Tuesday 12 September 2017

Introducing SAP HANA Cloud Platform predictive services

Here at the SAP HANA Academy we’ve put together a series of hands-on video tutorials that show the basics of predictive services from both an admin and developer perspective.

The first video tutorial covers getting started topics such as where to find the documentation.

Tutorials 2,3 & 4 cover the one time setup process for new HCP landscapes – admin tasks.

If you just want to get a feel for how to develop with predictive services you can jump straight into tutorial #5 “First Steps”.

Sunday 10 September 2017

Size of log backup, complete data backup in HANA

Basic information:

Backup performed for


The data volume contains the data from the last completed Savepoint.

Friday 8 September 2017

Getting a Permanent License Key for SAP HANA Streaming Analytics

When you first install SAP HANA streaming analytics, a temporary license is automatically installed so you can run streaming analytics for 90 days. After that, you’ll need to request and install a permanent license, which you can do using HANA cockpit and the SAP Support Portal. Here’s how:

1. Log into SAP HANA cockpit and connect to your system as a user with the LICENSE ADMIN system privilege

2. From the system overview page, scroll down and click Manage system licenses. This will give you some important system info that you’ll need to request a license.

Change Master/Shadow role of cloud connector manually

High Availability configuration requires Master-Shadow cloud connector. While taking over, sometimes in exceptional situations, where both of cloud connector in High Availability configuration are shadow role/master role.  In case such bad-configuration occurs, SCP connection will be lost and Satellite systems cannot connect to SAP cloud platform (formerly known as HANA cloud Platform)

Thursday 7 September 2017

Calling SOAP Web Service from HANA XSJS

I am writing this blog to share my experience and code snippets for calling a SOAP Web Service from XSJS, creating a XML input (based on input parameters) and understanding the XML response to build a JSON output of your XSJS service.

Firstly, the xshttpdest file should be in the same folder, as your XSJS file (which has code calling the SOAP Web Service, in our case). It is not just the main package, but also the same folder/sub package.