Monday 31 December 2018

Smart Data Integration: Increase Initial Load Performance for Replication Tasks

This Blog Post aim is to assist you in your daily work using Smart Data Integration and the Replication Task.

In some situations i faced performance issue and i want to use this Blog as a central sweat spot for Best Practices and Lessons learned about performance issues surrounding SDI and the initial Load Replication Task.

Saturday 29 December 2018

HANA Active Active System Replication – Configuration, Failover & Failback

Having worked with an Active-Active Read Enabled (R/E) System Replication scenario we wanted to share our experiences. The official documentation is good but does not provide many diagrams or overall setup, process flows for failover, failback and how the read-only queries can be handled. Working with a long-time colleague Paul Barker. This was used for a short evaluation of the Active-Active with Read Enabled capability.

Wednesday 26 December 2018

How to create XSOData from HANA Calculation Views with input parameters and Navigation properties

We have seen several blogs on how we can easily expose the results of a calculation view as XSOData service.

We can even define navigation properties in the XSOData between the entities. By defining the navigation – we can make use of the existing Smart templates in WebIDE to develop Master Detail kind of UIs.

Monday 24 December 2018

Implementing SLT configuration (for sidecar) in SAP HANA

In this blog I am going to discuss about one of the data provisioning technique in SAP HANA and how to implement it.

There are primary three types of data provisioning techniques in that can be implemented with SAP HANA Database. these are given below –

Thursday 20 December 2018

Implementation of Decision Tables with Return Values in SAP HANA

Introduction to Decision Table

Decision table creates the business rules in a tabular format for automating the business decisions. In this blog, I would like to show a step by step process of creating a simple decision table on HANA and how to execute the same.

Tuesday 18 December 2018

Emergency Access Management (EAM) for HANA Target Systems

Purpose of the Document

In the latest version of GRC 12.0,  SAP has extended the emergency access management (EAM) functionality to HANA database. This blog is to provide the details on how this new functionality can be configured and utilized to manage the firefighting access to HANA target systems.

Friday 14 December 2018

Query Automation on HANA

Business requirement :

When SAP implements SAP Enterprise HANA from other landscape, huge no of SQL query need to be transform to HANA graphical VDM as BI tool like Lumira, Webi design Studio in BOBJ and Tableau. In one scenario similar request (convert SQL to HANA Graphical VDM (Virtual Data Model) raised when the landscape transform to SAP HANA.

Wednesday 12 December 2018

SAP Data Hub and R: Time series forecasting

Read on if you want to know how R syntax can be deployed in SAP Data Hub. I will use time series forecasting to introduce this concept. Think of demand forecasting or sales forecasting, just to give a few examples for how this might be used in a business context.

Generally, you can choose from a number of technologies for time series forecasting. You can select a highly automated approach (ie with SAP Predictive Analytics), you can leverage conventional algorithms inside SAP HANA (Predictive Analytics Library) or you can bring in open source such as R or Python.

Tuesday 11 December 2018

HANA SDI | Smart Data Integration – Batch based Delta Load using Timestamps within a parameterized SDI FlowGraph

1. Introduction

HANA SDI can serve various needs when it comes to data extraction, loading and transformation. In terms of data loading flavors, it supports real-time replication and batch processing, push and pull based.

In this blog entry I would like to outline one option how pull based micro-batching can work with SDI in a simplified use case. The showcase leverages HANA XSC runtime (not state of the art but still applicable out there and therein mostly design time objects. Some material data sets will be loaded in a batch-based manner, using scheduled xs cron jobs, offering some kind of extended options.

Saturday 8 December 2018

How to Generate a HANA CDS Wrapper View

To generate from command prompt, please complete the following:

◈ Download and install the js application.
◈ Open the js command prompt.
◈ Install the dependent packages from the command prompt npm install.
◈ Open the folder hana-cds-wrapper-generator-master/view-generator and execute js.

Thursday 6 December 2018

Refreshing a SAP HANA Database using a database backup


One typical use case managed by SAP Landscape Management is refreshing a system – overwrite the content of an existing target system with actual data from the source system while maintaining system topology and configuration. General SAP Landscape Management functionality allows to manage such an exercise via a “Storage Based” or “Virtualization Based” approach:

Monday 3 December 2018

Create Time-Related Tables and Generate Time Data in SAP HANA XSA Platform


Time data is necessary almost in any kind of data manipulation process, as well as adding time-dimension to the calculation views. So, ways to go for the time-dimension has changed a bit with the release of SAP HANA XSA Platform. In this blog post, you’ll see how to create time-related tables if required, and generate time data through the steps on SAP WEB IDE.

Friday 30 November 2018

SAP S/4HANA: Key Adoption Scenarios to Consider Webcast Recap

SAP S/4HANA, SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Learning

This was a SAP user group webinar from yesterday.

Interesting developments are planned next year for 1809 in terms of system conversion; read below.

Wednesday 28 November 2018

SAP HANA System Copy- Homogeneous On Multi Tenant Database – Refresh using SWPM

As explained on my last blog SAP HANA System Copy- Homogeneous On Multi Tenant Database that we have 3 Ways to do System Copy and i explain 2 Ways 1 and 3 according to the note -1844468 – Homogeneous system copy on SAP HANA, and i promised to add 2nd way as well , So below is the 2nd way to do system copy, For Pre checks and preparation please read the 1st blog,

Tuesday 27 November 2018

XSA and SAP Web IDE For SAP HANA 2.0 SPS 03 Feature Revision 1: New Developer Features

Normally when we introduce new features for HANA, it is only done via a new release version (HANA 1.0 or 2.0) or an SPS – Support Package Stack (ex. HANA 2.0 SPS 0, SPS 01, SPS 02, SPS 03). However the XSA runtime and the SAP Web IDE for SAP HANA actually have a rather independent technical infrastructure from the HANA DB itself. Up to this point we’ve never used this feature to deliver new features separate from a HANA release or SPS. But it was always possible.

Sunday 25 November 2018

Merge Multiple SCD Tables into A Single Dimension

Tracking historical changes within a dimension is a common task in data warehousing.  Achieving this in a HANA sidecar database (SCD) requires an explicit design focus.  In some cases, the data source system maintains dates and time stamps to denote a record or value’s creation, change, or validity threshold.  In SAP systems creation, change, or validity dates are often but not always maintained for a record, dimension, attribute, or value. One such example being SAP Human Capital Management (HCM) mini-master info-types, seen as below:

Wednesday 21 November 2018

S4HANA Cloud Key User Extensiblity scenarios: Field Extensibility and Report Extensibility

Extensibility covers a broad spectrum of topics that allows customers and partners to adapt standard business software to their business needs. It ranges from business configuration; layout adaptation of user interface (UI), forms, and reports; custom fields and logic; integration; and custom terminology and translation to customer-specific applications. Extensibility in the SAP S/4HANA suite can be categorized into two main parts: side-by-side extensibility through SAP HANA Cloud Platform and in-app extensibility through built-in capabilities.

Monday 19 November 2018

Building an App on SAP HANA Express – Part 1, Installing Linux

A while back, my friends at Intel were kind enough to give me a NUC. Thanks, Intel! Anyhow it was time to give it a whirl, so I got it out the cupboard and decided to put SAP HANA Express on it.

In this series of blogs, I’m going to take you through getting HANA Express running on a NUC and building an application based on a publicly available dataset. The same principals will work if you want to install HANA Express on any system.

Saturday 17 November 2018

HANA Fallback Snapshot – HANA 2.0 SP 03


This blog provide you an information on fallback snapshot, a new feature that has been introduced in HANA from HDB 2.0 SP 03 version.

Thursday 15 November 2018

Configuration and setup HANA XS Apps with HANA DB SSO (BASIS Activities)

This is a long time coming blog from me and below are some of the steps that I used to configure the SAP HANA XS apps (HANA live apps) such as KPI modeler, Analytics foundation apps and so on for which the content is in the HANA DB (In the form of the HANA delivery units we apply for those apps) but the apps are viewed in the FIORI URL. So to make this perfectly work we have below steps such as applying the delivery unit for the app, Web Dispatcher routing configuration, SSO between ECC ABAP and HANA DB and finally replication of ABAP users in HANA DB. Though these configurations are used less now a day, due to the introduction of S4 and its own FIORI apps but the different steps and configuration explained here can be used in different use cases.

Monday 12 November 2018

Table Functions in SAP HANA – step by step guide

SAP HANA Table Functions

Recently I spoke to multiple developers working on SAP HANA Native system for developing reports. What really surprised me was the fact, that most of them are still using calculation views of a SQL Script type instead of Table Functions. What is more, some of them were even not aware that these type of views are deprecated and replaced by Table Functions. I also haven’t found any step by step tutorial describing when to create Table Functions, how to do that, what are the benefits and how to consume them in calculation views.

Saturday 10 November 2018

Connecting Servlets to HANA as a Service on Cloud Foundry


This tutorial will help you creating in a servlet and deploy it to SAP Cloud Platform with a Cloud Foundry instance using Eclipse.  The Eclipse landscape has been updated since the aforementioned blog was written and some of the prerequisites have changed for Eclipse. Additionally, this tutorial will connect the sample application to a HANA database schema on SAP Cloud Platform.  The tutorial uses JNDI and traditional SQL which is a common means to access the database.

Tuesday 6 November 2018

Setting up a HANA Express Python Machine Learning API Demo VM

This is a step-by-step guide to setting up a HANA Express(HXE) VM for demonstrating the Python Machine Learning API with functioning demo application.

The goal is to eventually provide an automated script to perform all the required actions. Currently some steps require user authentication and can’t be performed automatically.

Friday 2 November 2018

Implementing HANA Information view to calculate distance between Cities Using Geo-Spatial Functions

This blog is intended to share my experiences on Geo-Spatial Functions implementation in SAP HANA. One of the implementation is implementing Information view to calculate distance between Cities Using Geo-Spatial Functions which I am sharing today.

Background: Geo- Spatial function used geospatial data which stored in a geographic information system (GIS). The geospatial data needs to be combined with data from the internet and sensor data, data from business partner to implement point to point implementation, to manage coordinates of different stores, warehouse, utilities of an organization, business for real-time analysis, reporting, forecasting, threat detection.

Thursday 1 November 2018

HANA Housekeeping using HANACleaner


The blog provide guidelines on the necessary steps that needs to be followed to automate housekeeping task using SAP HANACleaner script.

Monday 29 October 2018

Solving the Knight’s Tour Problem with HANA Graph

The problem is best summarised as the following: “find a succession of moves of a knight piece on a chess board such that the knight visits each square exactly once”.

Thursday 25 October 2018

HANA Scale-Up HA with System Replication & Automated Failover using SUSE HAE on SLES 12 SP 3 – Part 1

This blog, will give you insight on System Replication and SuSE High Availability Extension overview. It will also provide you details on the various method, services and agents involved to setup automatic failover of HANA.


Below are the system version on which this document has been prepared. For more updated information, always use the latest SAP Notes and Guide to best implement High Availability for HANA.

Monday 22 October 2018

Creating Virtual Table in WEB IDE for Flat file present in Remote Source Part 2

In Previous Part – we have understood how to configure DP Agent and enable a connection from HANA to Flat File Reomote source.

Let’s create a virtual table for the object “FILECONTENTTEXT” present in the Remote Source ,FlatFile.

Friday 19 October 2018

SAP S/4 HANA 1809 complete Installation on SUSE Linux with screenshot step by step

This blog will help to install S/4 HANA 1809 installation, installation of SAP 1809 initial pack on SUSE 12 SP03 with HANA Database 2.0 REV33 Platform Edition.

Thursday 18 October 2018

SAP S4HANA 1809 Installation complete steps with snaps

Installation of SAP “S4HANA 1809” initial stack on SUSE 12 SP03 with DB SAP HANA Platform Edition 2.0 SPS03 rev33 S4HANA 1809 is the latest release of SAP on-premise edition. The current initial stack is released.

Installation of 1809 is similar to old installation just a few things are changed.

Tuesday 16 October 2018

Configuring DP Agent and Remote Source in HANA to read Flat Files Part-1

Setting up DP Agent and Remote Source in HANA

1. Download DPAGENT from SAP Service Marketplace as a SAR file

Extract the SAR file using the following command

SAPCAR -xvf  IMDB_DPAGENT200_03P_20-70002517.SAR

Monday 15 October 2018

Multi line Input Paramters with Scripted View

Creating multi-value or multi entry input parameter in HANA Graphical calculation view is soothing and works perfectly, however doing same in Hana Scripted view doesn’t work correctly (Checked on HANA 01 SPS 12, not sure if SAP has fixed this in later versions).

Friday 12 October 2018

Installing XSA & WebIDE for HANA 2

To use XSA, first you must download the additional XSA components from SAP Support – Software Downloads – these packages are in addition to the base HANA Platform.

Knowing exactly which files are required can be tricky, so I have captured those below.
I used HANA 2.00.23 (HANA 2 SP2 Rev 23).

Wednesday 10 October 2018

How to configure HANA network communication channels – Part2 Internal network


Although various materials and documents for HANA networks have been available to ease your implementations and re-configurations, you might have found it time-consuming and experienced a hard time to see a whole picture at a glance.

Monday 8 October 2018

How to configure HANA network communication channels – Part1 Public network


Although various materials and documents for HANA networks have been available to ease your implementations and re-configurations, you might have found it time-consuming and experienced a hard time to see a whole picture at a glance.

Friday 5 October 2018

Managing HANA system replication takeover with Spring and Hibernate

SAP HANA system replication provides the possibility to copy and continuously synchronize a SAP HANA database to a secondary location in the same or another data center. Usually system replication is used to support high availabilty and disaster recovery. SAP HANA 2.0 introduced the Active/Active (read enabled) system replication operation mode, which allows read-only access to the secondary site.

Thursday 4 October 2018

Combining spatial and sentiment analysis using SAP HANA

Taking unstructured data, extracting sentiments from it and then putting spatial data in the mix can yield valuable insights for any company.


Many companies have a large pool of unstructured feedback from customers (e.g. complaints). Most of the time, this data also has geographical information attached (e.g. the address).

Monday 1 October 2018

Monitoring HANA 2.0 with replication

I want to show a way how you can integrate your HANA 2.0 system in the Solution Manager System Monitoring.

Disclaimer: I made this document as neutral as possible, but I was out of demo landscapes.  All blacken out parts are hostnames, SID, system numbers, ports, etc….

Friday 28 September 2018

Terms and Conditions


This Agreement contains the complete terms and conditions that apply to you in joining, buying and all other activities you will make in our website. By using or shopping from this Website, you agree to be bound by its terms of use and shall comply thereof. This Agreement describes and encompasses the entire agreement between you and us, and supersedes all prior or contemporaneous agreements, representations, warranties and understandings with respect to the Site, the content and computer programs provided by or through the Site, and the subject matter of this Agreement. Amendments to this agreement can be made and effected by us from time to time without specific notice to you. Agreement posted on the Site reflects the latest agreement, and you should carefully review the same before you use our site.


The Site allows you to shop online. However, you are prohibited from doing the following:

  • Use our site, including its services and or tools, if you are not able to form legally-binding contracts, are under the age of 18, or are temporarily or indefinitely suspended from using our sites, services, or tools.
  • Collect information about users’ personal information.
  • Post false, inaccurate, misleading, defamatory or libelous content.
  • Take any action that may damage the rating system.


The has the sole discretion to provide the terms of payment. Unless otherwise agreed, payment must be received by prior to the acceptance of an order. Unless credit term has been agreed upon, payment for the products shall be made by credit card. Invoices are due and payable within the time period noted on your invoice, measured from the date of the invoice. has the discretion to cancel or deny orders. The is not responsible for pricing, typographical, or other errors in any offer by and reserves the right to cancel any orders arising from such errors. Satisfactory payment must be received prior to goods being shipped.

Our online payment processor, they collect your information at checkout to process your purchase. Upon checkout, there is also an optional check-box to allow us to contact you for marketing purposes. This is opt-in and is compliant with GDPR. If you would like your purchase history deleted please contact us.


The does not have to provide a refund if you have changed your mind about a particular purchase, so please choose carefully.


We promise our premium users for 100% Money Back Guarantee if the premium user fails to understand or not satisfied with our digital training service. No human interactions mandatory after purchase. We are liable to support/help to provide the digital training material in video formate after successful payment.

User required to provide the following details within 30 days of purchase if they are not satisfied with our service who claim for refund.
  • Statement of valid reasons/lists saying why you are not satisfied
  • Valuable feedback which supports your reason
  • Reference link or screenshot of authorized/trusted books/source which is biased to your reason of non-satisfaction.
  • Order date and order number

The List Price displayed for products on our website represents the full retail price listed on the product itself, suggested by the manufacturer or supplier, or estimated in accordance with standard industry practice; or the estimated retail value for a comparably featured item offered elsewhere. The List Price is a comparative price estimate and may or may not represent the prevailing price in every area on any particular day. For certain items that are offered as a set, the List Price may represent “open-stock” prices, which means the aggregate of the manufacturer’s estimated or suggested retail price for each of the items included in the set. Where an item is offered for sale by one of our merchants, the List Price may be provided by the merchant. In cases of mispriced in our catalogs in which the item’s correct price is higher than our stated price, we will, at our discretion, either contact you for instructions before shipping or cancel your order and notify you of such cancellation.

We do not warrant those product descriptions or other contents of this site are accurate, complete, reliable, current, or error-free. If a product offered on our website is not as described, your sole remedy is to return it in unused condition.


You hereby acknowledge that all rights, titles, and interests, including but not limited to rights covered by the Intellectual Property Rights, belong to the site and that you will not acquire any right, title, or interest in or to the Program except as expressly set forth in this Agreement. You will not modify, adapt, translate, prepare derivative works from, decompile, reverse engineer, disassemble or otherwise attempt to derive source code from any of our services, software, or documentation, or create or attempt to create a substitute or similar service or product through use of, or access to, the Program or proprietary information related thereto.


FRAUDULENT ACTIVITIES are highly monitored on our site, and if fraud is detected we shall resort to all remedies available to us, and you shall be responsible for all costs and legal fees arising from these fraudulent activities.


We will not be liable for indirect, special, or consequential damages, or any loss of revenue, profits, or data, arising in connection with this Agreement or the Program, even if we have been advised of the possibility of such damages. Further, our aggregate liability arising with respect to this Agreement and the Program will not exceed the total price of the subject products paid or payable by you.

We make no express or implied warranties or representations with respect to the Program or any products sold and offered on our website (including, without limitation, warranties of fitness, merchantability, non-infringement, or any implied warranties arising out of a course of performance, dealing, or trade usage). In addition, we make no representation that the operation of our site will be uninterrupted or error-free, and we will not be liable for the consequences of any interruptions or errors. This site and its information, contents, materials, products, and services are provided on an “as is” and “as available” basis. You understand and agree that your use of this site is at your own risk.


You agree not to disclose information you obtain from us and or from our clients, advertisers, and suppliers. All information submitted to by an end-user customer pursuant to a Program is proprietary information of Such customer information is confidential and may not be disclosed. Publisher agrees not to reproduce, disseminate, sell, distribute or commercially exploit any such proprietary information in any manner.


This Agreement will remain in full force and effect while you use the website. You may terminate your membership at any time for any reason by contacting us via email or the Contact Us page. We may terminate your membership for any reason at any time. Even after your membership is terminated, certain sections of this Agreement will remain in effect. We may delete the practice exam result history data at any time for registered users and after the expiration of premium membership for premium users. The may go down for maintenance purpose or due to any technical issue with/without prior notice. As part of our content moderation system, we may modify or delete any content/part of content submitted by users.


Members on this website are prohibited to use the services of the website in connection with any commercial endeavors or ventures. This includes providing links to other websites, whether deemed competitive to this website or not.

Upgrading HANA XSA & WebIDE

Obtaining the Software

It’s easy to forget exactly what’s been installed, so I have captured here the pieces I needed.

Search Words Description  Filename (as at 11-Sept-2018) 
EXTAPPSER Extended App Services – XSA server binaries EXTAPPSER00P_88-70001316.SAR
HRTT  HANA Run Time Tools, required for WebIDE  XSACHRTT06_62-70002322.ZIP 
XSACMONITOR  XSA Monitoring, required for WebIDE  XSACMONITORING06_5-70002324.ZIP 

Wednesday 26 September 2018

Difference in query results when run from HANA MDX and HANA SQL

SAP HANA offers multiple access options to query SAP HANA views available in database:

◈ The HANA SQL access, the primary HANA access, allows you to query HANA views using the SQL query language. This access is optimized for on-premise solutions.

◈ The HANA MDX access, that offers multi-dimensional concepts to HANA models, allows you to query HANA views as cubes (including HANA hierarchies) through the Multi-Dimensional eXpressions (MDX) query language.

Tuesday 25 September 2018

HANA SDI is super set of all, if and only if – HANA is the main data target.

Now a day’s lot of questions are coming around HANA SDI like HANA SDI is the only future data integration solution for the SAP?  Should we use SAP SLT or HANA SDI for data replication now? SAP Data services will be die in future?

To answer all these questions let me try explaining what is SDI technology and How it is different from existing data integration tools.

Friday 21 September 2018

Business Partner configuration while doing conversion from ECC to HANA.


While performing SI check, we normally get the error for Business Partner as shown below :

The major errors we usually get is CVI_MAPPING and CHK_CONT_MAP.

Wednesday 19 September 2018

How to import the ST05 trace file into HANA Studio and display as a graph

Some ABAPers might have already noticed this button “Graphical Explain” in tcode ST05 but do not know how to use it properly.

SAP HANA Studio, SAP HANA Certification, SAP HANA Tutorial and Material, SAP HANA Learning

Monday 17 September 2018

Build database objects/services in HANA service using SAP WebIDE Full-Stack : Part 2

This blog is part of a blog series which shows to build HANA database artefacts using the SAP WebIDE Full-Stack and the new HANA service on Cloud Foundry.

Create Nodejs. Module

In this section, I am going to show how to create a nodejs module and add an OData service within it. This OData service will be used to expose the contents of the table/view modeled earlier.

Friday 14 September 2018

Build database objects/services in HANA service using SAP WebIDE Full-Stack : Part 1

I walked through the steps to install and configure the HANA service on SAP Cloud Platform Cloud Foundry environment, In this blog series, I will focus on how to get started with building database objects using SAP WebIDE Full-Stack service. One of the main advantages of using SAP WebIDE is that you can now build a full-stack application (Database object, services with business logic and UI components etc). In this blog series, I am going to focus on how to create database objects and expose them as XSOData services. I have come across several requirements where data needs to be stored in SAP HANA service and needs to be exposed for other cloud platform services to consume. Hence, I will start by showing how to create DB artefacts and end by showing how to expose contents of a table using an OData service.

Thursday 13 September 2018

Sneak peek into HANA as a Service: Database artifacts and Calculation Views

If you are lucky to come to TechEd, I have plenty of instances to share for you to configure and deploy yourself. We will be using the Cloud Application Programming model to build a little something on top of them.

Monday 10 September 2018

The SAP HANA JSON Document Store – Use Case Part-2

Example Use Case for the Document Store


In part one of this blog series the Document Store was introduced. The most interesting part about this is the possibility to interact with the relational world inside SAP HANA, e.g. joining a collection with a table. Since this is a very abstract feature, the following sections will introduce an example use case including SQL queries for a better and deeper understanding of the SAP HANA JSON Document Store.

Friday 7 September 2018

Schedule HANA 2.0 backup using SAP HANA Cockpit 2.0 SPS 06

As we are aware that SAP HANA Cockpit is the new web based tool for SAP HANA Administration, recently I have been involved in BW/BPC HANA implementation migration project and I installed the latest SAP HANA Cockpit 2.0 SPS 06 patch 04 release to monitor and administer the non production and production HANA databases.

Wednesday 5 September 2018

SLT Replication Logging and Replay To Retrieve Lost Data

We know SLT used for real-time replication to HANA but if we face below situations then SLT logging and replay is useful.

1. Table replication shows fine but some data fields not updated correctly(Due to product bug or any other reason) – example cases are flag fields where data changed multiple times in particular time.

Tuesday 4 September 2018

Multiple SAML2 Identity Providers for HANA XS Artifact – How It Works

SAML 2 Single Sign-On (SSO) is usually a must-have for live HANA connections in SAP Analytics Cloud (SAC). In such a setup, the InA service, which is a HANA XS artifact, is configured with a SAML 2 Identity Provider (IdP), typically the same IdP as the one used by SAC. This IdP is often the corporate SAML 2 Identity Provider.

Friday 31 August 2018

Building Location-Aware XSA Web Applications using Python

Visualization is the key to effective communication. If you can paint a picture for your audience that is easy for them to visualize, it becomes so much easier to get your point across. When it comes to communicating enterprise data, what better tool to use than a map that can intuitively show complex data in a graphical way that is both useful and interesting for the audience. In this blog, I am going to introduce you to the geospatial processing capabilities of SAP HANA and how you can leverage them in a web application involving maps.

Wednesday 29 August 2018

Update SAP B1 rates using HANA XS and ServiceLayer

In this post we will do the same but using HANA XS as the development and administrating tool and B1 Service Layer as the data interface. This approach is applicable to SAP Business One version for HANA since SQL Server version doesn’t support neither XS nor ServiceLayer. After you have performed all steps you can schedule currency rates updating using standard HANA tools to update your rates regularly. This application updates rates for all currencies in your company using ECB (European Central Bank) web-service. Rates are updated according to company rate direction (Direct/Indirect rate) and using Euro cross-rate (in case the local currency is not Euro). Company details are passed in job settings.

Monday 27 August 2018

Upgrade HANA Express and optimize memory usage

As every few months an updated release of SAP HANA Express Edition is available a regular task is upgrading the own HANA Express to gain bug fixes and new features and simply stay up to date.

Thursday 23 August 2018

Service Channel:Consume HANA databases on HCP from OnPremise tools


Consider the following scenario:

CompanyX has been a SAP customer in the Business Intelligence (BI)/Analytics space for quite some time now. They have purchased licenses for many of the BI offerings from SAP like SAP Business Objects Lumira. CompanyX plans to embark on their digital transformation journey and have decided to go with the SAP HANA Cloud Platform (HCP) and SAP HANA.

Monday 20 August 2018

Setting up the new HANA service in SAP Cloud Platform Cloud Foundry

So what is actually new with the HANA service?

HANA as a service has been available for a long time in the Neo environment of SAP Cloud Platform. There are plenty of customers who have subscribed to the HANA service to create applications that leverage the core capabilities of HANA or implement data mart scenarios in the cloud.

Friday 17 August 2018

Develop, Deploy & Debug a Hana Node.js app (xsjs) using Hana DBaaS on cloud foundry.

This blog will cover 4 steps in end to end development and deployment of the app to cf.

1. Create the Hana database using the Hana Service (DBaaS) on cloud foundry (CF)
2. Configure Web IDE Full stack to work with cloud foundry.
3. Deploy the App on CF.
4. Debugging using webide fullstack.

Wednesday 15 August 2018

Developing Speech Interface for XSA Web Applications using Python

In this blog, I am going to talk about how to build conversational interfaces in XSA applications by integrating speech-to-text and text-to-speech APIs. I am also going to briefly cover how web sockets work in python for XSA applications. For those that are not familiar, web sockets are used for live bi-directional communication between clients and a server. Numerous clients can be connected to the same server through which they receive live updates as events. They do not need to make explicit HTTP calls to check for status updates. In addition, the Server can also initiate communication with the client and send updates as opposed to simple HTTP where a client must always initiate communication often leading to polling interfaces.

Tuesday 14 August 2018

Example Optimize Join Columns

In this example we will demonstrate how the usage of option Optimize Join Columns influences query processing. The example makes use of two tables.

Friday 10 August 2018

Examples Using Input Parameters with Calculation Views

Input parameters provide a means to influence query execution with values that are entered at runtime by the end user. In contrast to variables, input parameters can be mapped between different views so that an input parameter from one view is filled with values of the mapped input parameter of another view. In addition, it can be controlled at what node the input parameters are processed which provides precise control about the semantics of the input parameter. While variables are evaluated using the normal WHERE-filter Syntax, input parameters offer more options and have an own syntax. We will demonstrate this syntax of input parameters with different examples in this blog.

Thursday 9 August 2018

SAP HANA 2.0 Cockpit Installation and Configuration How to Guide

In this blog, I would like to provide a step-by-step procedure to install and configure new SAP HANA 2.0 Cockpit to monitor and maintain multiple SAP HANA databases.  SAP HANA 2.0 Cockpit is a native web based centralized HANA administrator tool used to perform all database management and monitoring of multiple SAP HANA 2.0 and SAP HANA 1.0 SPS 12 databases.

Monday 6 August 2018

India Geo Model from HANA live with SAP Analytics Cloud

Hence, I tried a quick POC to represent India data on geo map from HANA live. This was further enhanced to actually include drill up/down capabilities on the states. I thought it would be useful for many India customers who intends to achieve similar usecases.

Saturday 4 August 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 6

In this Part of blog we are going to install SAP S/4HANA Frontend server.

◈ Installation of SAP S/4HANA IDES Frontend Server

1. Follow from Step 1 to Step 7 in the Part 5 of this blog.

Wednesday 1 August 2018

Working with HANA spatial data in Javascript

Over the years, I’ve done a fair amount of technical proof-of-concept applications, most of them on HANA or the SAP cloud platform. All of these have been written up into step-by-step “how-to’s”, but precious few of them have found their way here, to the public realm.

Monday 30 July 2018

Use Case to S/4HANA Smart Data Integration (SDI)

Every new technology or platform is developed as a need to address the challenges faced by older technologies, cater to the unmet needs of the consumer or to facilitate a change by making the processes easier and/or economical. Smart Data integration is no exception.

Friday 27 July 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 5

In this Part of blog we are going to install SAP S/4HANA Application server.

◈ Installation of SAP S/4HANA IDES Application Server

1. Open Terminal and use cd /HANAIDESSetup/SAP_Software_Provisioning_Manager/ command to go to SAP Software Provisioning Manager Directory (Figure 5.1)

Wednesday 25 July 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 4

In this Part of blog we are going to install SAP HANA Database

Install SAP HANA Database

1. Open Terminal

2. Go to HDB_SERVER_LINUX_X86_64 Directory using cd /HANAIDESSetup/SAP_HANA_Platform_Edition_2.0_SPS03_rev30/51053061/DATA_UNITS/HDB_SERVER_LINUX_X86_64/ command (Figure 4.1)

Monday 23 July 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 3

In this part of blog we create the partition of disks /dev/sdc and /dev/sdd, create directories for both HANA Database and HANA IDES Setup files, mounting both directories to relevant disk is also part of this blog, finally we extract and copy the setup file to the HANA IDES setup directory.

Saturday 21 July 2018

HANA Procedure performer XS JS Project

In this post I want to share the way how to call HANA Procedures via XS JS. This is not a how-to guidepost, I want to share the end functionality that we use in our work. This approach might be very convenient in integration projects when the data extraction rules can be changed during the UAT, so you won’t need to change anything in your integration solutions you just need to apply this requirements in your procedures and change will be committed on the fly.

Thursday 19 July 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 2

In this part of SAP IDES S/4HANA installation we will install SUSE Linux in the Virtual Machine which we created in the Part 1 of this blog.

◈ Install SUSE Linux Enterprise for SAP Applications in the Virtual Machine

1. Select S4HANA IDES Virtual Machine from the left panel of VMware vSphere Web Client and click the Power on the selected virtual machine icon  SAP HANA Study Materials, SAP S/4HANA, SAP IDES S/4HANA, SAP HANA Certifications (Figure 2.1)

Monday 16 July 2018

SAP WebIDE for HANA 1.0 SPS 12

SAP WebIDE for HANA 1.0 SPS 12

SAP Web IDE for SAP HANA is a browser-based IDE for the development of SAP HANA-based applications comprised of web-based or mobile UIs, business logic, and extensive SAP HANA data models.

Saturday 14 July 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 1

In this first part of SAP S/4HANA 1610 IDES installation we download all the required files for installation and create a virtual machine in VMware vCenter Server.

◈ Download all Required Files for Installation

For installation of SAP IDES S/4HANA, we have to download ISO file for installing SUSE Linux from SUSE Downloads and SAP installation files from SAP Software Downloads.

Monday 9 July 2018

Hana Hadoop Integration with Federated Access

Data Lake analytics have become real. But the challenge is to access the data quickly and provide meaningful insights. There are several techniques to access the data faster. In this blog we see how we can integrate Hana with Hadoop to get insights for larger data sets quickly.

If you have both Hana & Hadoop in your eco-system. SAP has provided an option to integrate HANA and Hadoop using Hana Spark controller. Where power of In-Memory processing can be used for real time insights and we can in parallel use Hadoop ability to process huge data sets.

Saturday 7 July 2018

Accessing Data using REST APIs with Python on XSA

My previous blogs have been focused on setting up Python on HANA XSA, connecting applications to HANA Databases, and configuring security and routing settings for applications. In this blog, I am going to delve deeper into accessing a HANA Database within a Python application and creating REST APIs to query data.

Wednesday 4 July 2018

How to Expose a HANA Table via oData

With IOT gaining traction and SAP’s HANA DB as well as applications becoming warehousing tools, we’re seeing a greater need to integrate IOT data into HANA. One method of achieving this is by allowing sensor data from IOT devices to publish or post data directly into HANA database tables. Once data is in HANA, additional data modelling can be carried out and formatted data exposed for end user consumption to front end tools such as SAP Analytics Cloud or Business Objects.

Tuesday 3 July 2018

Myth and truth about cluster & pool tables on HANA

In general nearly everyone knows that with new installations based on NW750 there are no cluster tables anymore. When you migrate to HANA one prerequisite is that all cluster and pool tables have to be declustered/depooled.

But is this really correct? In my last projects there were a lot of issues regarding cluster and pool tables. SUM and SWPM have not worked as expected and so some data was not migrated / depooled / declustered automatically in cause of bugs.

Saturday 30 June 2018

Provisioning data from web services with custom adapter using SAP HANA SDI SDK

We’ve encountered several situations recently where it was required to acquire information from external systems that already had an API to expose data with web services.

The usual way would be writting a script or using an ETL, but those options had some disadvantages:

Wednesday 27 June 2018

Inventory Management in SAP BW/4HANA


The loading process of Inventory Management data in BW/4HANA is different than that in the predecessor versions (BW 7.4 and below). This blog will attempt to explain how to load Inventory Management data in BW/4HANA, and also how the data is saved in the BW database tables.

Monday 25 June 2018

Introducing the NDSO: Part Three – Integrating a NDSO with SAP BW/4HANA


As already mentioned in the first blog. SAP supports the application driven approach and the native, SQL driven approach to Enterprise Data Warehousing and offers corresponding applications and tools in its portfolio. Especially for customers using SAP BW/4HANA there is of course always the option to implement parts of certain scenarios natively on the SAP HANA database and use capabilities the SAP HANA platform provides in the context of EDW. In those ‘mixed scenarios’ integration is key so – here we go with blog three and take a closer look on how to integrate the NDSO (and its data) in mixed scenarios with SAP BW/4HANA.

Wednesday 20 June 2018

Setting Up App Router for HANA XSA with Python

In my previous posts, I have covered details on getting started with Python development on XSA. I am going to continue this series forward and now talk about setting up a central application router for your applications. Again, I am using the same pyapp project in this blog post as i did in the previous ones.

Monday 18 June 2018

Getting Started with Python on SAP HANA XSA

Currently, XSA only distributes a build pack for Python while the runtime needs to be installed manually by the developer. This is different from Node.js and Java for which XSA provides runtime as well. Similarly, the SAP Web IDE for SAP HANA, the main development IDE for XSA, only supports Java and Node.js development. All Python development needs to be done and deployed through command line interface (CLI).

Friday 15 June 2018

S/4 HANA Cloud – Adding a Custom field to Web GUI for HTML

This blog will provide you the information about, how to add a custom field to Web GUI for HTML and access it in the assigned business context.

The below procedure steps you need to follow in S/4 HANA on Cloud Version.

To open the app, select the Custom Fields and Logic tile as shown in below snap shot.

Wednesday 13 June 2018

How to implement Function Import in HANA XS

It is all about a feature that I found missing in HANA XSODATA — support for OData Function Imports.  While this feature can be implemented in a custom way through XSJS, I would like to have this custom implementation compliant with OData V2 specification in order for the consumer application (which is SAPUI5) to be able to leverage the existing ODataModel V2 library.  This is my journey for achieving this requirement — by creating a custom function import utility through XSJS.

Monday 11 June 2018

How To Get SAP ERP Data Into HANA

The key element we need to explore in order to see how we can migrate ERP data into HANA is a built-in feature of the SAP system called Smart Data Integration. Smart Data Integration is a feature of HANA that administrators can use to transfer data into the SAP install with relative ease. The details of the procedure may require some basic explanation, but the process itself is as simple as we can find in any sort of system as complex as SAP.

Friday 8 June 2018

How to create FlowGraphs in HANA Web IDE with SDI connection

In this Blog, I am going to show “How to” create a Flowgraphs in HANA Web IDE with SDI (Smart Data Integration) connection.

SAP HANA flowgraph helps you to transform data from a remote source (SDI) into SAP HANA either in batch or real-time mode. In this case, I am using Hadoop database as remote source and loading the data into HANA Database tables.

Wednesday 6 June 2018

Migration Guide: Moving to Version 2.0.0 of the SAP S/4HANA Cloud SDK

With the release of version 2.0.0 of the SAP S/4HANA Cloud SDK, along with dropping support for Java 7, we were able to incorporate several improvements and add some great new features to the Java libraries of the SDK based on your feedback! Along with the modernization of the technology stack, we took the chance to clean up our code base and remove obsolete and unwanted functionality that – in a few cases – required breaking changes to our API.

Tuesday 5 June 2018

Deploy HANA Express database on Google Kubernetes cluster

This post will guide you through the creation and configuration of a Kubernetes cluster on Google Kubernetes Engine (GKE). You will then learn how to connect to SAP HANA, express edition running on the pods. The configurations provided here should also work on other Kubernetes orchestrators such as Azure Kubernetes Service or Amazon EKS.

Thursday 31 May 2018

Integration of External Data Structures with Open ODS Views

Integration of External Data Structures with Open ODS Views:

◈ Modelling options with Open ODS Views.
◈ Consuming external data in SAP BW.
◈ Combining external data with data in SAP BW.

Monday 28 May 2018

SAP HANA and R hands-on: From freestyle to deployment

Learn how to script R in your preferred editor with SAP HANA data and how to deploy the code directly in SAP HANA.

If you are a Data Scientist, there is a good chance that you enjoy working with R. You can bring in your creativity, choose from thousands of R packages and script some very agile data analysis and predictions.

Saturday 26 May 2018

The SAP HANA JSON Document Store – Introduction Part-1


The SAP HANA JSON Document Store (also known as DocStore or Document Store) is a new feature which has been introduced with SAP HANA 2.0 SPS 01. The new store combines a relational and document-oriented database to a hybrid innovative technology which is unique for a variety of reasons, namely, its ACID compliant, fully integrated with SAP HANA in terms of access/query and administrative capabilities.

Thursday 24 May 2018

A short overview of What’s New for the SAP HANA Performance Management Tools in SAP HANA 2.0 SPS03

SAP HANA capture and replay

Testing database workload is still a large effort for administrators, testers, developers and consultants alike when looking to upgrading from one release to another. Especially when it comes at larger scale scenarios, the amount of work can grow exponentially.

Monday 21 May 2018

Use JDBC to connect to HANA database instance in SAP Cloud Platform

This blog is divided into two parts.

Part 1

1. Introduce how to create a HANA database instance in SAP Cloud Platform (called SCP for short in the remaining part of this blog)

Friday 18 May 2018

Setup S/4HANA 1610 IDES On-Premise – Part II

As we successfully completed OS Setup and HANA DB Install in Part I, we will further see the installation steps to build S/4HANA ABAP Instance.

Wednesday 16 May 2018

Setup S/4HANA 1610 IDES On-Premise – Part I

We installed our first SAP S/4HANA systems – IDES S/4HANA 1610 in premise. To setup this environment we purchased 2 Servers of following configuration.

Tuesday 15 May 2018

SAP Fiori App on HANA XS/SAP Cloud Platform/Mobile Devices, Consuming SAP Business One HANA Service Layer


Utilize SAP tools to ease development efforts in packaging & deploying SAP UI5 Applications on Mobile/SAP Cloud Platform/Hana Platform.

Show a very simple Loosely-Coupled end-to-end Hybrid App solution utilizing SAP Business One Service Layer

Friday 11 May 2018

HANA Partitioning – 2 billion rows limitation – Part I: BWoH / BW/4HANA

Some of you may already know the limitation of 2 billion entries in a single table / partition.
Another hint regarding this limitation is the alert ID 17 ‘<table> contains xxx records’. The default threshold of this alert is 300,000,000 rows. This limitation applies to BSoH / S/4HANA and BWoH / BW/4HANA => general HANA limitation. But both have its own distribution rules. So I will split this blog into two parts BWoH and BSoH.

Wednesday 9 May 2018

Generating and Deploying HANA CDS Wrapper Views

Overview of Data Replication in S/4HANA Cloud

In the S/4HANA Cloud environment, data can be replicated with these three options:

◈ Whitelisted APIs
◈ Legacy APIs
◈ Data Models

Monday 7 May 2018

HANA SLT(System Landscape Transformation) Archived Files(SARA) Replication to HANA

In this blog we are going to discuss how to replicate the data which had been archived on source systems through SARA files.

In every project based on agreement we will go for archiving either it will be to keep only last 12 months data or last 24 months based on business agreement.

Sunday 6 May 2018

Make your HANA Express impersonate Cloud Foundry

When I help partners set up their HANA Express servers for development use, I want to configure them to impersonate the behavior of Cloud Foundry so that they get used to how the XSA generated URLs work.  This approach also tends to promote a more deployment target agnostic behavior and leads to projects that deploy into both HANA XSA on-prem and Cloud Foundry environments without any code differences.

Friday 4 May 2018

HANA Spatial Demos: Geocoding, Clustering, Aggregation

Business story

Let’s imagine a purely fictional story to back-up our applications:

◈ Our customer is an insurance company specialised in house insurance.
◈ Currently, they have all their data in Excel files.
◈ They want to move it into a dedicated system capable of grouping houses in the same area together.

Monday 30 April 2018

Exploring the SAP HANA XS Advanced Secure Store functionality with NodeJS


Recently a question was raised here in the community how the secure store functionality can be used in a XS Advanced application without using the $.security.Store API available via the XSJS compatibility layer. Until HANA 2.0 SPS02 there was no official information available although the functionality was already part of the system, but not officially released, at least to my knowledge. With HANA 2.0 SPS03 in the SAP HANA Developer Guide for XS Advanced the Application Security chapter was enhanced by a new sub-chapter Maintain Values in the SAP HANA Secure Store which adds the information that the secure store can be used by new procedures:

Thursday 26 April 2018

SAP HANA 2.0 SPS 03 Installation – Preparation for HANA Migration using DMO

A lot of SAP customers have been migrating their existing SAP landscapes from traditional database platforms to SAP HANA. OS/DB migration using SAPinst (SWPM) has been in place since long, however the migration to SAP HANA database requires certain minimum SAP release/SPS level as a prerequisite for the existing SAP systems in the customer landscape.

Sunday 22 April 2018

How To Integrate Hana Database with Excel

Connecting to SAP HANA with Microsoft Excel

Microsoft excel is most widely used BI tool across the globe, with excel we can explore well versed SAP Hana data.SAP HANA supports the query languages SQL and MDX where as JDBC and ODBC are used for SQL-based access. ODBO is used for MDX-based access. MDX (Multi-Dimensional Expressions) is a query language for OLAP databases. It has been defined as part
of the ODBO (OLE DB for OLAP) specification from Microsoft.

Saturday 21 April 2018

Angular 2 on HANA XSA

From the day I heard SAP HANA will support Node.js, I was curious to experiment what all we can develop on HANA using the new platform. Just few days before I was able to run Angular 2 apps on HANA XSA and thought of sharing the same. So lets start with the prerequisites.

Wednesday 18 April 2018

Analysis of Memory Management & Host/Resource Utilization Statistics in BW ON HANA and above

Many a times users of SAP face performance issue on the system which in turn impact their daily tasks and business. One of the common cause behind such performance issues can be less efficient memory management analysis or improper load distribution which leads to high host/resource utilization. I am going to write series of blog on this issue and will share with you.

Monday 16 April 2018

SAP HANA 2.0 SPS 03: New Developer Features; Database Development

In this blog, I would like to introduce you to the new features for the database developer in SAP HANA 2.0 SPS 03.   We will focus on the database development topic including Core Data Services, as well as SQLScript.

Friday 13 April 2018

S/4HANA Cloud Integration | Commercial Project Part 2


Consume S/4HANA Cloud APIs indirectly via SAP Cloud Platform Integration

In this blog we will focus on indirect S/4HANA Cloud API consumption via SAP Cloud Platform Integration (in this blog referred to as CPI).

Wednesday 11 April 2018

S/4HANA Cloud Integration | Commercial Project Part 1


In a professional services project you might use S/4HANA Cloud in combination with other solutions to apply the relevant business processes for professional services such as opportunity to cash. Scenario could be that project opportunities are managed in another solution, once the opportunity gets realized and priced, a project in S/4HANA Cloud will be created.

Monday 9 April 2018

Create Resource Group and Resources in SAP HANA Cockpit 2.0 SP 06

As we are aware that SAP HANA Cockpit is the new web based HANA administration tool to monitor and manage HANA 2.0 databases, recently we installed the latest release SAP HANA Cockpit 2.0 SP 06 patch 04 for a client so as to monitor the BW/BPC HANA landscape.

General Availability of SAP HANA XS Advanced Cockpit

The new release of SAP HANA 2.0 SPS03 is around the corner and we are excited to explain our new features. In this blog, we are specifically going to look into SAP HANA XS Advanced Cockpit. This will replace the old SAP HANA XS Advanced Administration Tools, which is announced as “Deprecated” in this release. We will refer to SAP HANA XS Advanced Cockpit as XSA Cockpit and SAP HANA XS Advanced Administration Tools as XSA Admin Tools in this blog. One of the major reasons for us to move to XSA Cockpit is to provide users a consistent, unifying user experience in cloud and on-premise. The XSA Cockpit includes all functionalities of the XSA Admin Tools and it also provides a lot of additional capabilities. The UX and design of the XSA Cockpit is very similar to the SAP Cloud Platform Cockpit to provide users a seamless experience in the cloud and on premise.

Friday 6 April 2018

Managing large SAP BW on HANA systems: SAP HANA Enterprise Cloud (HEC) perspective

As a cloud architecture and advisory member, I frequently come across several customer cases related to existing SAP Business Warehouse(BW) systems. Large customers usually have large data footprint (often in several terabytes) and a variety of data source systems. Additionally, several reporting/analytic tools are connected to existing SAP BW systems.

Wednesday 4 April 2018

SAP Hana 2.0 hybrid Landscape Management with LaMa 3.0 & Solution Manager 7.2 Part-2

Configure Microsoft Azure connector for SAP LaMa

The Azure connector for SAP LaMa will allow me to perform several operations directly onto Azure such as activate or power off VMs, do SAP system relocate or perform SAP system copy/clone.
However, not all Azure resources are supported, only VMs deployed by ARM with managed disks are supported, VMs deployed in availability zone are currently not supported.

Monday 2 April 2018

SAP Hana 2.0 hybrid Landscape Management with LaMa 3.0 & Solution Manager 7.2 Part-1

I will explain and detail how to manage SAP Hana 2.0 SP2 instance with SAP LaMa 3.0 SP5 in the context of hybrid landscape between on-premise and Microsoft Azure.

In order to monitor my hybrid solution i will explain how to configure Solution Manager 7.2 accordingly.

Friday 30 March 2018

Technical details about data aging Part II

To understand the data aging in detail we will go a little bit deeper in this part of the blog series.

As example we will use table CDPOS. Data aging is in use and aging runs already were executed. As result we get this data distribution.

Wednesday 28 March 2018

Business Partner in S4 HANA – Customer Vendor Integration

It’s been almost 2 years I have started my journey in SAP world. I started with Technical domain for some time and I landed in Functional domain SAP SD (Sales and Distribution).

I must say that even after learning and practising it’s still feels like there is lot to learn. My office colleagues helping me a lot to learn things every day.

It always exciting whenever you come across new technology.

Monday 26 March 2018

Your SAP on Azure: SAP HANA Express on Azure Kubernetes Cluster (AKS)

Using a docker image to install SAP HANA express edition can shorten the deployment time and ensure the consistency between environments. The easy way to use it is to build a Kubernetes cluster using Microsoft Azure Container Service and deploy containers in the cloud.

A docker container is a package of libraries and system settings required to run an application. It allows to save the time needed to provide a working environment and you can focus on the target database configuration. It’s great especially in environments where you need to provide separated HANA instances for many developers.

Saturday 24 March 2018

S/4HANA – What to do about Planning and Consolidation – The Options

As organisations continue to convert their SAP ERP systems to S/4HANA, one area that pops up as a roadmap item is how to handle requirements for Planning and Financial Consolidation.

In some cases, this provides an opportunity to simplify the landscape and in others prompts a review of what organisations require from a planning solution and what they require from a financial consolidation tool. These discussions are made more confusing for SAP customers, because SAP provide a number of different solutions that cover the topics of planning and consolidation, and at first glance it can be difficult to understand which should be used.

Thursday 22 March 2018

Mircosoft Dynamics 365 CRM adapter for SAP SDI

1. Overview

The Advantco Dynamics 365 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  Dynamics 365 CRM to the SAP HANA tables.

Monday 19 March 2018

S/4 Embedded Analytics – The Virtual Data Model

In this post, I will discuss the architecture of building a virtual data model (VDM) in S/4 HANA, using CDS Views (Core Data Services).

With the availability of the SAP HANA platform there has been a paradigm shift in the way business applications are developed at SAP. The rule-of-thumb is: Do as much as you can in the database to get the best performance.

Saturday 17 March 2018

Custom Rule Set – SAP HANA Text Search

In this blog, I’ll discuss how to create custom rule set in SAP HANA.  To implement certain custom use cases, customers have to implement their own rule set for performing Text Search Operations.

Search Rule Set

Figure 1 below shows the structure of Rule Sets stored in XML/Tree Like Formation.

Thursday 15 March 2018

Connect a SQL client to HANA Express on Google Kubernetes Engine

I showed how to setup a Kubernetes cluster with three HXE containers running in single pods. As I continue to explore different possibilities with my new favorite toy, I thought I could document some extra steps to connect from an external, local SQL client.

Monday 12 March 2018

Setting up communication channel between SAP Cloud Platform (Neo) & HANA XSA (On-Premise)


Recently, I came across a situation where I had to consume an OData service that’s deployed in HANA 2.0 on-premise following XSA paradigm in a SAPUI5 application running in SAP Cloud Platform – Neo environment. In this blog, I’d like to take through the concepts and the various configuration steps that are involved in setting up communication channel between an application deployed in SCP to and HANA XSA on-premise. I’ll also describe in detail the security configuration to allow a user logged in SCP HTML5 application to access a protected resource in HANA XSA, for example an OData service that requires specific scope to access.

Saturday 10 March 2018

Upgrading Web IDE in HANA Express

One of the housekeeping tasks I generally perform in the instances I use to develop actual applications is to upgrade the Web IDE. Not only because some minor bugs are swept away, but also because there’s always some additional functionality that makes development easier.

You would generally need access to the marketplace and a proper license for this. However, the engineering team has made this patch available for download in the download manager in revision 23. If the following rings a bell, you might want to give this a try:

Thursday 8 March 2018

How to free Hana System on Public Cloud from I/O performance issue?

How to free Hana System on Public Cloud from I/O performance issue?

Apart from memory, storage performance plays a major role in safeguarding HANA performance. Storage system used for SAP HANA in TDI environments must full fill a certain set of KPIs for minimum data throughput and maximum latency time for Hana data and log volume. Cloud vendor need to pass the KPI checked using HWCCT (Hardware Configuration Check Tool) for SAP to certify their cloud platform to run SAP HANA. The reason is to safeguard customer HANA system from any possible I/O performance that’ll lead to performance degradation up to system standstill and irresponsive.

Monday 5 March 2018

Table redistribution and repartitioning in a BW on HANA system

In this blog, I am providing step by step details about how to perform table redistribution and repartitioning in a BW on HANA system. Several steps described in this document are specific only to a BW on HANA system.

Thursday 1 March 2018

SAP HANA Text Mining Functions – Part 2

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

Document Classification or Categorization

One of the category of Text Mining function is Document classification or categorization. SQL Function in HANA for performing this operation is TM_CATEGORIZE_KNN.

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).

Monday 29 January 2018

SAP HANA Express Edition on AWS for XSA development space issues

I launched the SAP HANA, Express Edition on AWS through CAL.

Once it ran, I ran across many issues.

A few things to help out so that I could get start developing:

◈ started nodejstools explicitly.
◈ create a space and explicitly redeployed the builder using the di-space-enablement tool

Sunday 28 January 2018

SAP S4HANA Business Partner: Same Number Range for BP and Vendor

Since the advent of S/4HANA we have seen a lot of changes/simplifications in the application, one of them being – Business Partner.

Today I would like to talk about a scenario where we need to maintain same number for Business Partner and Vendor.

Saturday 27 January 2018

SAP PI/PO & your 0 issues philosophy (yes is possible): Here just your own Analytics / BI via HANA OLAP / Lumira / Java / Excel or other technology that you decide

I will share a complete solution with the objective to achive the logic that will alow you to make corrective decisions for your solutions implemented or to monitor for preventive symptoms for current interfaces… After we can agree that a lot of companies suffer in their integration processes and don’t know the main reason, but this article will not cover that point here; because i just will share a “logical tool” to let you implement your own technology to monitor and decision making reports.

Wednesday 24 January 2018

SAP HANA 2.0 XS Advanced Installation – by the SAP HANA Academy


Recently, we have updated a number of SAP HANA Academy tutorial videos about installing SAP HANA components:

SAP HANA Installation and Update – SAP HANA 2.0 SPS 02

In this blog, I will provide some references and background information about the SAP HANA XS Advanced (XSA) runtime.

Tuesday 23 January 2018

SAP Hana Smart Data Access (SDA) – Basic Configuration

In this post, I have explained step by step configuration of  Smart Data Access for Hana Database with error resolutions.

One of main challenges that companies are facing today are

1. Get information in real time to make quick decision on time

2. At the same time, we need to keep control over cost for IT and Technology.

Sunday 21 January 2018

Create a value help (for input parameter / variable) in HANA Calculation view

Input parameters and Variables are two diferent mecanism that HANA provide us to get interaction with final users.

In some cases, we need to include an input parameters / Variables with value help with the propose of provide more information when user have to choose an input value.

Saturday 20 January 2018

SAP Analytics Cloud: Live Data Connection to HANA DB in SAP Cloud Platform using SSO

The SAP Cloud Platform (SAPCP) is a platform-as-a-service offering which supports customers’ digital transformation. It does not only provide an environment for the development of new applications but also allows the extension of existing cloud and on-premise systems. SAPCP has evolved as a central component in many enterprise landscapes for integrating data and business processes and for leveraging innovative technologies. By connecting a HANA database which is included in SAPCP with SAP Analytics Cloud (SAC), customers are equipped with advanced analytics and business intelligence features for their enterprise data.

Thursday 18 January 2018

Introducing enhancements to SAP HANA capture and replay in SAP HANA 1.0 SPS12 Revision 122.14 and SAP HANA 2.0 SPS02

SAP HANA capture and replay was first made available with the initial release of SAP HANA 1.0 SPS12. Since release, many enhancements have been added to SAP HANA 2.0 and are now also available on SAP HANA 1.0 SPS12 Revision 122.14. While it greatly simplified testing application workload, the testing of data- and system-related changes remains a challenge for many of our customers today, especially in large-scale and complex environments.

Tuesday 16 January 2018

Automate SAP HANA System Replication with SLES for SAP Applications

SAP HANA System Replication on SLES for SAP Applications

What is this solution about?

The solution created by SUSE is to automate the takeover in SAP HANA system replication setups.

The basic idea is that only synchronizing the data to the second SAP HANA instance is not enough, as this only solves the problem of having the data shipped to a second instance. To increase the availability you need a cluster solution, which controls the takeover of the second instance as well as providing the service address for the client access to the database.

Saturday 13 January 2018

Installing the Automated Predictive Library (APL) on SAP HANA Express 2.0

The Automated Mode of SAP Predictive Analytics allows the efficient creation of powerful predictive models. Installing the Automated Predictive Library (APL) on SAP HANA makes it possible to train these models directly in SAP HANA. The data does not have to be extracted into an external system, the architecture is simplified and agility is increased.

Thursday 11 January 2018

Your SAP on Azure – Part 4 – High Availability for SAP HANA using System Replication

In the today’s post, I would like to present you a solution for protecting the HANA database server.

SAP HANA database offers two solutions that are designed for High Availability:

a) Host Auto-failover – in this solution you need to deploy additional host to the current HANA database and configure it to work in standby mode. In case the active node failures, the standby host can automatically switch operations to the secondary node. This solution requires a shared storage, which we already know is a small problem for Azure

Monday 8 January 2018

BW HANA – BI Reporting Performance Benefits

I recently done a review of several client sites that have done a technical upgrade to a HANA DB. This article will cover how to create a BI statistics query for report performance and calculate the report performance benefits of a HANA DB upgrade.

Saturday 6 January 2018

Create a HANA Service binding in Cloud Platform CF

I am a developer in SAP and am working in project using SAP Cloud Platform Cloud Foundry hosted on Amazon Web service infrastructure.

Creating a HANA Service Binding in the global account via Cloud Cockpit :-


Thursday 4 January 2018

Creating a HANA calculation view for currency conversion providing exchange rates for all days including non-working days like holidays and weekends

There is sometimes a need to calculate the exchange rate for weekends and holidays in business use cases.  Since there is no exchange rate for these dates because they are non-working days, the business usually decides to take the most recent previous exchange rate and apply it to these dates.  For example, since December 30, 2017 is a Saturday, the exchange rate for this date will be the exchange rate for December 29, 2017 (Friday) – the most recent previous working day with an exchange rate.  This blog illustrates how to create a HANA calculation view that will provide the exchange rate from USD to EUR of any date in the period of the last 3 years.

Tuesday 2 January 2018

Creating SAP Analytics Cloud Live Connection to SAP HANA Database on SAP Cloud Platform

SAP Analytics Cloud (SAC) has the capability to connect to various types of cloud and on-premise data sources via live and import connections

In this blog post, we focus on connecting from an SAP Analytics Cloud tenant to a cloud data source that is an SAP HANA database on SAP Cloud Platform (SCP) via a live connection.