Saturday 30 July 2016

My first experiences with the on premise Web IDE for HANA


Creating a XS Advanced (XSA) project is supported by templates, but currently only one template for Multi-Target Application Project exists that simply creates a Multi-Target Application (MTA) Descriptor file. Templates like the Fiori Master Detail Application, that I like because it fits the requirements for many simple out of the box scenarios, are currently missing and the MTA Descriptor file has to be edited manually for the application configuration.

Friday 29 July 2016

How to return value XS OData using XSJSLIB and Stored Procedure


This document contains code of a small test. This logic allow us to return the Id with XS OData. A stored procedure is used to insert records into a table.
A structure is used specifically as input. This highlights, that I only insert directly from the stored procedure into the table. In this way, data can be validated before inserting into the table.
A XSJSLIB file is used to generate the new Id. In this post you will see an example, how to combine a XSJSLIB with a Stored Procedure and some validation inside the stored procedure.

Thursday 28 July 2016

How to Consume HANA XS Odata in ECC


In this blog we will discuss how can we consume HANA XS-Odata services in ECC system. In this scenario we will set up an RFC connection between HANA and ECC system and the XS Odata services can be consumed. The data coming from the XS-Odata services can be populated in an internal table for further processing.


  • This scenario has to be implemented in ECC system.
  • An RFC connection should exist between HANA and ECC.

Wednesday 27 July 2016

Troubleshooting Dynamic Tiering Connections to SAP HANA

Sometimes you may get a connection error when converting a table to
extended storage:


[4863] {207439} [95/10731633] 2016-05-06 17:50:26.455132 e FedTrace
odbcaccess.cpp(03672) : ODBC error: connected:  1 state: HY000 cide: -65 [SAP]
[ODBC Driver] Unable to connect to server 'HANA': [SAP AG] [LIBODBCHDB SO] [ HDBODBC]
General error;1033 error while parsing protocol

Tuesday 26 July 2016

SAP HANA Developer Edition 1.00 SPS11

SAP HANA Developer Edition 1.00 SPS11

After several months we finally have the SPS11 SAP HANA Developer Edition live with the brand new SAP HANA XSA configured and running, unfortunately being early meant we had a few problems along the way so hopefully you'll all be happy with the results - we are that is for sure!

Monday 25 July 2016

All about Joins using SQL in HANA

Lets do it in HANA studio and cover below points :
  • Overview of HANA studio
  • Joins concept
  • Creating Schema
  • Creating Tables
  • Insert Values into Tables
  • Using SQL to understand below Joins in HANA Studio
             - Inner Join
             - Left Outer Join
             - Right Outer Join
             - Full Outer Join

Saturday 23 July 2016

SAP HANA Analytical view

SAP HANA Analytical View

Now we will create an Analytic View which combines purchase order table data with the product attribute view we created in the previous step.
In your models package create a new Analytic View.

SAP HANA Analytical view

Friday 22 July 2016

SAP HANA TDI on Cisco UCS and VMware vSphere - Part 2

ESXi Host

UCS Service Profile

The ESXi host provides the platform where virtual machines are running on. The service profile contains the configuration of the hardware in a Cisco UCS environment. Service Profile Templates or vSphere Auto Deploy can be used to ease the ESXi deployment process. In this example, a standalone service profile creation is shown.

For each vSwitch, it is recommended to configure two uplink interfaces with MTU 9000 as trunk. The VLAN assignment takes place in the port group configuration of the vSwitch.

Thursday 21 July 2016

Understand HANA SPS and supported Operating Systems

HANA Revision Strategy

 SAP is shipping regular corrections and updates. Corrections are shipped in the form of Revisions and Support Packages of the product’s components. New HANA capabilities are introduced twice a year in form of SAP HANA Support Package Stacks (SPS). The Datacenter Service Point (DSP) is based upon the availability of a certain SAP HANA revision, which had been running internally at SAP for production enterprise applications for at least two weeks before it is officially released.

Understand HANA SPS and supported Operating Systems

Wednesday 20 July 2016

DB Refresh of HANA Based systems using HANA Studio Backup/Recovery without SWPM

DB Refresh using HANA Studio DB Restore  with SID Modification -  NON SAPinst

HANA Studios DB restore option and hdbuserstore there after makes the whole process of a  System copy a lot simpler . The only limitation would be that the target schema would still remain as source.

The idea of this blog is to explain the process of performing  a simple homogeneous system copy of a HANA based system using the recovery of the source backup on the target HANA DB using HANA Studio.

In this case ,we will be  considering a situation of copying a Prod backup and refreshing it in a already running quality system

Tuesday 19 July 2016

Execution management by HANA Graphical Calculation View

SAP HANA, An appliance with set of unique capabilities has provided wide range of possibilities for end user to perform data modeling. One among them is 'Graphical Calculation View', which helps in leveraging the fullest potential of SAP HANA in data modeling sector.

This Document helps in understanding the nature of execution management by HANA Graphical Calculation Views by utilizing the allowed set of properties in it. So as to reveal out the effectiveness in handling the properties to manage the execution flow.

First among the property set under discussion is

Monday 18 July 2016

Smart Data Access- A new feature by HANA

In Today's world, Companies are facing challenges to optimize cost and processes in order to sustain in this grim economic condition. Business has to be dynamic and agile to keep pace with the market and technology. Business has to get information in real time to make quick decision on time and at the same time, we need to keep control over cost for IT and Technology.

Keeping Business need in view, SAP has recently introduce Smart Data Access in SAP HANA which is a Virtualization Technique. This feature is introduced from SPS6 in SAP HANA. Smart Data Access enables SAP HANA to combine data from heterogeneous sources like Teradata, Sybase IQ, SAP Sybase Adaptive Service Enterprise and Hadoop.

Saturday 16 July 2016

A closer look at tables that contain LOB data type columns


Since SPS06, SAP HANA offers a flexibility around how it manages data type LOB (Large Object Types) columns, namely Hybrid LOBs. Data types, CLOB, NCLOB and BLOB are used to store a large amount of data such as text documents and images. The current maximum size for an LOB on SAP HANA is 2GB.

In the following blog, we will go through some examples of how Hybrid LOBS are defined, specifically around the memory threshold value and the effect that has on keeping the LOB column data on disk versus allowing it to be loaded into memory.

Friday 15 July 2016

How to Perform Garbage Collection in HANA

The process defined below can be executed on daily basis during off peak hour or after every 3 days. Also it can be repeated on specific HANA Node if memory utilization on specific HANA node server is more than 85%.

The following SQL statement needs to be executed in HANA studio to know the current resident memory at the start and after each Garbage collection process to verify it's effect:


Thursday 14 July 2016

Dynamic Currency reporting in HANA

In many reporting scenarios, it is often required to display the financial figures in multiple currencies. For example, most of the systems capture the "Net Sales in the Stores" in the local currency of the Store. For the Country level local reporting, it is often required to report the Net sales in the Local currency. But for the Regional Head Quarter reporting, the Net Sales values need to be converted to the Regional currency. The same figure at the Global Head Quarter might be required in the Global currency.

Wednesday 13 July 2016

New Hierarchy SQL enablement with Calculation Views in SAP HANA 1.0 SPS 10

SQL enabled hierarchies with SAP HANA Calculation Views

Modeling SAP HANA Calculation Views is the key approach to successfully exploit the power of the SAP HANA Platform and leverage key SAP HANA capabilities. With SAP HANA SPS 10, calculation views provide a deeper integration of hierarchy objects and their exposure for usage within SQL. By leveraging the SQL integration of hierarchy objects, hierarchy-based filters, aggregations and hierarchy-driven analytic privileges are enabled.

Enabling hierarchies for SQL access

Within the SAP HANA calculation view general properties, there is a new checkbox “Enable Hierarchies for SQL access”. With that hierarchy views from shared dimensions used in a Star Join Calculation View are enabled for SQL access.

Tuesday 12 July 2016

The Best-run Organizations Prefer SAP HANA

Only recently, a German television magazine unveiled that no others than the U.S. security agencies CIA and NSA are using software solutions based on the SAP HANA® platform. This is especially remarkable since most people would expect that particularly U.S. authorities prefer a database made in the U.S. Well – they don’t, for obvious reasons. SAP HANA is a database platform that is currently unparalleled. It enables companies and organizations to analyze large amounts of data, both structured and unstructured, in real time. And consequently, more and more of these companies and organizations replace their legacy databases with SAP HANA, realizing incredible cost and performance benefits while simplifying their IT infrastructure as well as exploring innovative business processes and new business models at the same time. Let me present just a few:

Monday 11 July 2016

MDC conversion on HANA System Replication configured

MDC system can only be replicated as the whole system, it means that the system database and all tenant databases are part of system replication. A take over happen for the whole Hana database (system database + all tenant databases) and is not possible to take over just for a particular container.

In our scenario, we have system replication setup for single container systems running on 112.02, and we decided to convert them into MDC. As we know that primary and secondary must be identical (N+N, nodes (except Standby) and services) during system replication setup, there's no exception for MDC.

Saturday 9 July 2016

Cumulative Sum / Running Total in HANA Calculation View

Requirement :

Most of the popular reporting tools can handle cumulative sum or running total , but still there have been lot of posts in SCN about whether it is possible to do it in HANA itself.  So, just wanted to see , if it can be easily done via Graphical Calculation view and it seems to be working .

Note: This might still be easier to do in Scripted View or Reporting Tool .

In Figure 1, our base data is in Column 1 and 2 and we want to add Colum 3 ( "C UM_SUM" ) to existing data set.

Friday 8 July 2016

How to scheduling XS Job to call stored procedures

This tutorial try to explain how to schedule a XS job to call strore procedure.

We need to change the SAP HANA perspective to SAP HANA Development.

How to scheduling XS Job to call stored procedures

We create a XS Project with a new package as follow

Thursday 7 July 2016

Adjust SLT connection to HANA MCD

After convert HANA to MCD (MultiTenant) some tasks must to be executed in SLT to connect with MCD Database.

In addition to Note 2101084 please check the SAP Note relevant for your DMIS version from the list below and ensure all corrections are applied to both source and SLT server where indicated in the note.
  • 2016511 - Installation/Upgrade SLT - DMIS 2011 SP7
  • 1958809 - Installation/Upgrade SLT - DMIS 2011 SP6 / DMIS 2010 SP10
  • 1882433 - Installation/Upgrade SLT - DMIS 2011 SP5
  • 1824710 - Installation/Upgrade SLT - DMIS 2011 SP4 / 2010 SP9
  • 1759156 - Installation/Upgrade SLT - DMIS 2011 SP3 / 2010 SP8
  • 1709225 - Installation/Upgrade SLT - DMIS 2010 SP7 / 2011 SP2
  • 2191214 - Installation/Upgrade SLT - DMIS 2011 SP9 & SP10 

Wednesday 6 July 2016




Standard hierarchy is a tree hierarchy which is used to organize business processes of a controlling area. The highest node of a standard hierarchy is normally the first business process group. The groups created thereafter make of the remaining nodes of the standard hierarchy.
The standard hierarchy is assigned directly to the controlling area and has itself a set of business process groups assigned to it. This ensures that all business processes belonging to a controlling area are grouped together.

Monday 4 July 2016

[HANA System Replication] end-to-end Client Reconnect

I've seen many posts on how to setup Hana System Replication and its takeover, however, none or few of the post that covers client reconnect after sr_takeover.

In order to ensure the client is able to find seamlessly the active HDB node (doesn't matter primary or secondary), we can either use IP Redirection or DNS Redirection. In this blog, i'll emphasize on simple IP redirection as it is much easier, faster and less dependancies compare to DNS redirection.

First of all, we need to identify a virtual hostname/ip, create them in your DNS. Below is the sample virtual hostname/ip and physical hostname/ip used:

Virtual IP/Hostname: [10.X.X.50 / hanatest]
Primary Physical IP/Hostname: 10.X.X.20 / primary1
Secondary Physical IP/Hostname: 10.X.X.21 / secondary2

Saturday 2 July 2016

Predictive analytics using SAP Design Studio and SAP HANA – Part 2

In part 1, we discussed the 101 of predictive analytics in SAP HANA using SAP HANA PAL and HANA flowgraph modelling. The drag and drop interface allows us to focus on the analysis without spending too much time writing out complex SQL scripts.

In this blog, we will understand how we can integrate flowgraphs with SAP Design Studio and provide a readily consumable output to the decision makers.

Extending our example from the previous blog, we would like to select different store and product combinations, to be able to view the sales forecast at a granular level. This kind of analysis will help in inventory planning, promotional offers for low selling products and so on. We would also like to choose the number of periods of forecast as well as be able to modify the forecast parameters to ensure a good fit.

Friday 1 July 2016

Predictive analytics using SAP Design Studio and SAP HANA – Part 1

With advanced analytics finding a place in every business function, scripting and programming is too much of a hassle when you are bound by deadlines and tough competition. This is where SAP makes a difference by providing a minimal scripting approach to predictive analytics.
This is a two-part blog where part 1 discusses the fundamentals of SAP HANA PAL & HANA flowgraphs and part 2 discusses how flowgraphs can be integrated with SAP Design Studio to derive actionable insights on the fly.

SAP HANA PAL – Predictive Analytics Library, which is a part of HANA AFL (Application Functions Library) is a large collection of functions to implement predictive modelling. These are the same set of functions that are made available in SAP Predictive Analytics Expert Mode when connecting to a HANA data source. Earlier on, these functions could be used by means of a several-step process using SQL scripts – manually creating all of the artefacts required.