Monday, 20 May 2019

Develop Simple on HANA Express in AWS Cloud 9


This blog post started much simpler as a personal wiki set of notes on how to quickly set up a Cloud 9 IDE in AWS to use HANA. However, as I continued to document, the more I felt like this might be an interesting story/journey of mine to share. Probably the past 2 or 3 months, I’ve been on a personal journey of getting back into application/web development after many years of spending time in Analytics/BI/Design Studio SDKing etc.

Saturday, 18 May 2019

Reverse GeoCode HANA Data with Google API

We recently came across a scenario with a client, where we needed to Reverse Geocode their coordinate information. In essence what that means, is that they’d provide latitude and longitude data, and we needed to retrieve the geopolitical information surrounding that coordinate, like street name, number, city, state, country, etc.

Friday, 17 May 2019

SAP HANA & Data Warehousing for non-experts


A quick blog, triggered by 2 questions of a customer last week:

1. What exactly is SAP HANA?
2. What does SAP mean by “modern data warehousing”?

Wednesday, 15 May 2019

Split table column value into multiple rows using SQL in SAP HANA


In this post I would like to focus on the similar scenario, but this time the challenge will be to do the same not for variable but for table column. SAP HANA enables STRING_AGG function for concatenating values from multiple lines into single string, however doing opposite is quite challenging.

Monday, 13 May 2019

Using Dynamic Text in SAC Without Users Having to Input Prompts

Architecture: SAC using Live Connection to a HANA Database.

Many times in SAC we want to dynamically display a text based on some underlying values. In this scenario, we want to display the current Fiscal Year, Period and Quarter.

The underlying calculation view doesn’t have any optional or mandatory prompts, since the view itself was filtered to only return data for the current Fiscal Year, and the end users didn’t want any pop ups or filter bars to be displayed.

Sunday, 12 May 2019

SAP BW/4HANA Migration – Authorisation

The simplification of object types in SAP BW/4HANA has an impact on authorisation objects. When converting a SAP BW system to a SAP BW/4HANA, authorizations for object types that are not available in SAP BW/4HANA (like InfoCubes) must be replaced by authorizations for corresponding object types (like ADSO).

Friday, 10 May 2019

How To: Create Dataflow within BW/4HANA

What is a DataFlow Object?

The Dataflow object is a way to model your dataflow within SAP BW/4HANA within the Eclipse world.

It is a graphical feature which also enables you to create a dataflow from start to finish.

All created objects eg Datasource, ADSOs, InfoObjects etc are available for re-use within other dataflows.

Wednesday, 8 May 2019

LDAP Based Authentication for SAP HANA 2.0


This blog provides details on the steps required to configure LDAP based authentication for SAP HANA 2.0. LDAP based authentication is of great help for below two reason to the users –

Monday, 6 May 2019

BW4HANA Modeling Scenario Step by Step

The purpose of this document is to provide details on how to do modeling in BW/4HANA with steps. The reader would get the look and feel of the new eclipse based modeling in BW/4HANA and how to create a data model flow in BW/4HANA.

BW/4HANA modeling is eclipsed based and happens within the HANA Studio. The BW GUI still offers a representation of classical administrative workbench without the key modeling capability.

Friday, 3 May 2019

New R and enhanced Python API for SAP HANA Machine Learning – Released!

I am going to focus on two exciting capabilities – the new R and the enhanced Python API for SAP HANA Machine Learning.

Key Points

◈ The API’s are now generally available from April 5th with the release of HANA 2.0 SPS 04. You can download the packages multiple ways, for example with the HANA Express Download Manager and can get started straight away, for free!

Wednesday, 1 May 2019

Monday, 29 April 2019

LTMC for Master Data Step by Step Process

When We are Implementing SAP S/4HANA solution, We can migrate our master data and business data from SAP systems or non-SAP systems to SAP S/4HANA. By using  SAP S/4HANA migration cockpit.

Friday, 26 April 2019

S/4HANA 1709 FPS03 – back on the Mothership again …

Apply S/4HANA 1709 FPS03 …

Since I’m back at SAP SE as Platform Architect for Intelligent Data & Analytics, I also checked my “Innovation Landscape” for updates and new Software Stacks.

Thursday, 25 April 2019

Batch Insert and Update Processing with OData V2

In this blog, we’ll learn how to perform batch insert and update operation with OData version 2 and we apply to the contact persons list where user can add, edit and delete the person first name and last name. I have no issue when performing the single batch insert/update alone. But when it comes updating and inserting at the same time with batch, I think this is one of the easiest way. Do let me know if you have any better solution.

Wednesday, 24 April 2019

Hands on Tutorial PAL in HANA for Customer Churn Analysis for online retail

Predictive analytics encompasses a variety of statistical techniques from data mining, predictive modelling, and machine learning, that analyze current and historical facts to make predictions about future or otherwise unknown events.

Predictive analytics is an area of statistics that deals with extracting information from data and using it to predict trends and behavior patterns.

Monday, 22 April 2019

How to pivot/unpivot in SAP HANA


Currently there is no built-in pivot/unpivot function in HANA. In this blog you will find a workaround how to implement this in SQLScript.

Friday, 19 April 2019

TADIR object types and object descriptions via SQL


In our organisation we were upgrading SAP and neded a quick way to associate various objects with their object type and description, however these were not obviously available via SQL, so a solution was required. The primary table for objects was TADIR, but this only contained a code for obect type, so the description had to be determined from elsewhere. Note: this was required for some quick analysis; for ABAP developers there are standard methods for obtaining descriptions.

Wednesday, 17 April 2019

Developing with HANA Deployment Infrastructure (HDI) without XSA/CF or Web IDE

While I no longer work within SAP HANA Product Management, in my new role in SAP Cloud Business Group I am still developing on HANA and assisting teams that are doing so as well. Therefore I wanted to some research on “skinny” local development options for SAP HANA. The goal was to use HANA Express with as small a resource footprint as possible. This meant starting with the server only edition of HANA Express which does not include XSA nor Web IDE for SAP HANA. Yet I still wanted to be able to create database artifacts via HANA Deployment Infrastructure (HDI) design time approach. So that’s the challenge of this blog entry – “how low can I go”?

Monday, 15 April 2019

Handling Non-Cumulative Measures in HANA Calculation Views with Multiple Cartesian Transformation and Single Conversion Matrix


The COPA, the forecast and many other S4HANA, ECC and legacy tables contain hundreds of measures in their record structures. This format is not suitable for efficient processing in BI front end tools; e.g., WebI reports.

Friday, 12 April 2019

What’s New in HANA 2.0 SPS04 – SQL

I would like to provide deeper insight from a developer’s perspective of what is newly available for SQL & SQLScript language features. One of the strategic focus is becoming more general-purpose supporting various use cases and applications by extending the coverage of SQL standards functionality and easier development for SAP HANA. With SPS04, there is a long list of new features to support it.

Wednesday, 10 April 2019

SDI SDQ Geocoding & Address Cleansing

Have you tried using the HANA Smart Data Quality (SDQ), and found the transforms aren’t working?  Well this blog should help, there are country specific files required for both geocoding (latitude, longitude) and address cleansing.

Monday, 8 April 2019

SAP HANA, SAP Analytics Cloud, and Brexit: The Automation

In the last article we have discussed how we can easily get big data from the internet, convert it to the required format, massage it a bit, and report on it in SAP Analytics Cloud via SAP HANA which worked pretty well but lacked any sort of proper automation.

In this article we will create an automated flow which can be used to acquire data from the same Petitions website, convert it to the required format and load it to our SAP HANA system which in turn is connected “Live” to SAP Analytics Cloud. Therefore, the reported data in SAP Analytics Cloud would be as recent as possible, depending on our data acquisition flow settings.

Friday, 5 April 2019

XSA Accessing Remote Sources & External Objects (Schemas, etc)

When developing with XSA and the WebIDE you will likely need to access existing database objects, schemas, tables, remote sources or other objects from an HDI Container. This configuration has been captured before by Christophe Gilde, but the process has evolved with the latest feature release of the WebIDE (4.3.63 for HANA 2 SPS3).

Thursday, 4 April 2019

SAP HANA Startup

Have you ever wondered what SAP HANA is doing from the moment you trigger the start or restart until it’s finally available to be used by your application layer?

Or perhaps you have experienced a startup that has taken your system way longer to be available than you have planned for, and you are trying to understand, what it was doing all this time to avoid it, improve it or plan for it next time?

Monday, 1 April 2019

The tale of SAP HANA, SAP Analytics Cloud, and Brexit

This blog I wanted to show you an end to end example of getting unstructured JSON data, loading it into SAP HANA, enriching with geo-spatial attributes and exposing to SAP Analytics Cloud for further analysis.

The problem with most tutorials usually – they are focused on some randomly generated abstract data (like SFLIGHT or EPM Model data) and for some people this doesn’t really mean much, so I thought a real life example of a real up to date data analysis would be very beneficial for everyone.

Friday, 29 March 2019

Chatbot with Alexa + SAP Conversational AI + SAP Hana


In this bog you will learn how to create a Bot in SAP Conversational AI integrated with Alexa (using an Echo Dot 3rd gen) to get data in SAP Hana database.

Fiori application that was used here, is just to show all information that we are asking to Bot and give a visual feedback to user. Our focus here is not in Fiori development, but if you would like to see how this app works or use it for test, it’s available here. Special thanks to Danilo Jacinto that developed this app.

Wednesday, 27 March 2019

Back to Basics – SAP HANA and the Virtual Data Model

The SAP HANA intelligent data platform has been available for eight years, and with each passing year, we continue to see more and more innovation. You can expect the same in the next few weeks with the release of HANA 2.0 SPS04. However, I wanted to take an opportunity to step back and have a look at some “basics” of SAP HANA – what made it different back in 2011 and how this difference continues to add value in 2019 and beyond. This is part one of a two-part series, with another blog planned for next week. For now, I’ll focus on the in-memory and columnar structure of SAP HANA as well as the value it enables via a virtual data model.

Monday, 25 March 2019

SAP HANA Based Transformations (Processing transformations in HANA) aka ABAP Based Database Procedure (AMDP)

SAP HANA Based Transformations (New way of writing Routines)

As majority of us has worked on SAP BW and have written ABAP routines in transformations in BW to derive the business logic, we often noticed the performance issue while loading the data into DSO, Info cube or master data info object.

Friday, 22 March 2019

ArcGIS + HANA: GIS acceleration and increased agility for ArcGIS content creators and users

The number one question I have heard from folks over the past few weeks is why Esri + HANA together?  The short answer is increased performance, lower total cost of ownership and seamless integration. But how did we get here? And what have our customers experienced along this journey?

Wednesday, 20 March 2019

Advanced Available-To-Promise (aATP) with Back Order Processing in HANA 1809

In this blog will be seeing how to Activate aATP Process and How to Create BOP Job Run using Fiori Applications to Re prioritise Sales Orders based on Strategy in the BOP.

Now let’s Focus on what is aATP and BOP before going into Activation & Configuration parts.

SAP has introduced aATP with its 1610 release Advanced Available-To-Promise (aATP) with new functionality to execute order fulfilment and improve supply chain processes in a better way compared to classic ATP.

Monday, 18 March 2019

Calculation Engine Plan Operators (CE Functions) Vs SQL Code

In this blog, I’m going explain few CE Functions and also the alternative solution for CE Functions using three tables with sample data.

The reason why I’m talking about this topic is, still some people are thinking about CE Functions, so I just want to clear the myths about CE Functions. CE Functions are alternative to SQL Script. We have total 13 CE Functions, but out of 13 , we may need CE_VERTICAL_UNION CE Function (this is used to combine the columns of different tables though they don’t have any relation), because we don’t have simple alternative solution in SQL.

Friday, 15 March 2019

SAP BW4/HANA Migration Analysis

What is BW/4HANA

  • SAP’s New Data warehouse
    • SAP BW/4HANA is SAP’s next generation data warehouse solution
    • It is a new product and not a successor of any SAP BW

Wednesday, 13 March 2019

Working with Staging Tables in S/4HANA Migration Cockpit

S/4HANA migration cockpit is the migration tool which was initially designed for S/4HANA cloud edition but now it is also available for 1709 S/4HANA FPS1 on premises and later versions.

S/4 HANA Migration Cockpit is browser based (WordPro) interface. No additional setup or activation is required once we setup SAP S/4HANA system.

Monday, 11 March 2019

[HANA] Unleash the performance of your VM

Most performance issues which I was working on turned out to be basic issues regarding HANA / Linux parameter and configuration of the Hypervisor. Virtualization is regardless if big or small systems also in HANA environment an often-chosen architecture. If you want ensure good performance and how to check it in your environment keep on reading.

Saturday, 9 March 2019

How to: Integrate and Consume your S/4HANA Cloud Data on-premise using HANA Smart Data Integration ODataAdapter and Custom CDS View based OData Services

1. Disclaimer

This blog entry purely focuses on functional and technical aspects of the scenario. It does not address any license related aspects regarding the usage of the software components mentioned in this blog entry. In any case you must clarify the license and software usage side before implementing such a scenario with your SAP Account & License Expert to be on the safe side. Please also don’t raise any questions in relation to this context in the comments section.

Thursday, 7 March 2019

Use of Segmentation in S/4 HANA for Product Revisions

With S/4 HANA, SAP introduced a concept called Segmentation that was available in an Industry Solution prior to S/4 HANA. This blog provides an overview of how Segmentation can be used to track product revision levels with segregation of inventory for each of those revision levels.

In a B2B world, usually a product is assigned a new identification (new part#/material#) if there is a change to the form/fit/function. But if the change is minor (no change in form/fit/function), the customer assigns a revision level and may specify that product revisions are not interchangeable. One solution to solve this business requirement is Segmentation within S4/HANA that works throughout the supply chain. Segmentation can be used to assign revision levels and track these revisions (Inventory, Demand, Supply at these revision levels) throughout the logistics processes from Sales/ Procurement/ Manufacturing and Inventory.

Monday, 4 March 2019

Taming your SAP HANA Express (SE01E02). Hardening an SAP HANA Express 2.0 SP03 installation part 2. Securing the SAP HANA extended application services

This is the second blog of the season one of Taming your SAP HANA Express series, episode two.

In the SE01E01 we have seen how to implement a fully qualified XS Classic domain CA-signed SSL certificate.

This episode will tell the story of how to rename and secure the XSA domain.

Saturday, 2 March 2019

Taming your SAP HANA Express. Hardening an SAP HANA Express 2.0 SP03 installation part 1. Getting it ready for SAP Analytics front end tools.

Due to the fact that starting with the wave 2019.01 SAP Analytics Cloud (SAC) has stopped accepting the self-signed SSL certificates for HTTPS INA live connections I have ended up by replacing the self-signed HANA Express SSL certificate(s) with the equivalent CA-signed SSL certificate(s).

Wednesday, 27 February 2019

Building chat-bot with SAP Conversational AI & SAP Products


I’m going to show you a chat-bot which can help HR search employee’s salary by name and employee number on specific date.

Friday, 22 February 2019

Machine Learning with SAP HANA

AI and machine learning are the hottest trends in the current IT market. Everyone is talking about it and customers are adopting these technologies in day to day processes. Because of this, there is a need to have systems that will enable the processes to be scaled, governed and compliant to current business needs.

As part of digital transformation efforts, customers currently running SAP ERP applications are implementing innovative solutions to enhance operations. These innovative solutions range from RPA-robotic process automation, machine learning and enhanced analytics leading to an intelligent ERP aka iERP.

Thursday, 21 February 2019

SAP Data Services – Defining delta using hash functions

In section 34 Changed Data Capture of the SAP Data Services Designer Guide you can find a very good description of the various delta load capabilities in SAP Data Services. Isn’t that worth an attentive read?

Delta loads are commonly used to reduce overall ETL processing time. When the number of new and modified source records is relatively low compared to the full data size, overall performance will increase significantly. Not only the time spent in extraction will be much lower, also the transformation and load steps will run much faster because those operations will apply to a (minor) subset of data only.

Tuesday, 19 February 2019

How to install DWF on SAP Hana Express

I learned about SAP SQL Data Warehousing. This topic was even more exciting to me, because I’m an SAP BW Consultant, and I don’t knew before about possibility to build your own SAP Warehouse directly on HANA database. So why I can’t just install this add-on on my private Hana DB, to check this out by myself? This is so simple, and this article shows you how to do this, starting from fresh SAP HANA XSA installation.

Monday, 18 February 2019

Steps to create a HDI container type DB using SAP WEB IDE in the Cloud Foundry

This blog is for enthusiastic people who want to learn to create HDI container type Database using SAP WEB IDE and deploy the same in Cloud Foundry and can use SAP WEB IDE to perform DML/DDL operations on DB.

Wednesday, 30 January 2019

SAP HANA licensing models explained

SAP’s column-oriented, in-memory database, that combines OLAP and OLTP operations into a single system, or in other words, SAP HANA originated from a research started in 2006 by SAP’s co-founder Hasso Plattner while he was a computer science professor at the Hasso Platner Institute in Postdam, Germany.

Tuesday, 29 January 2019

SLT based HANA replication-FusionOps activity

This article uses as To perform SLT based replication in hana with ecc system

Login to D1H and execute LTRC T-Code

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

Thursday, 24 January 2019

Integrating SAP HANA XSA with Microsoft Office 365 Sharepoint Excel using Microsoft Graph API and NodeJS

I would like to show how to read data from Microsoft Office 365 using Microsoft Graph API and NodeJS and then write this data into SAP HANA XSA tables.  Our scenario requirement was to pull data from Excel files on Sharepoint on Microsoft Office 365 and write this data to SAP HANA XSA container tables.  We wanted to use the SAP HANA File Adapter which has a section for Sharepoint Configuration.  However, the Excel adapter as of HANA 2.0 SPS 3 can only connect to Sharepoint 2013 on premise systems and not Sharepoint on the Microsoft Office 365 Cloud.  So we had to come up with an approach to address this requirement and develop it.  This Blog describes the approach which will hopefully help other folks needing to accomplish this type of scenarios for integrating Microsoft Office 365 data with SAP HANA XSA .  There will be another Blog that describes how to trigger our custom developed NodeJS application from a virtual procedure through the file adapter through SAP HANA Smart Data Integration (SDI) layer.

Tuesday, 22 January 2019

Taming your SAP HANA Express. Hardening an SAP HANA Express 2.0 SP03 installation part 1. Getting it ready for SAP Analytics front end tools

First things first.

Due to the fact that starting with the wave 2019.01 SAP Analytics Cloud (SAC) has stopped accepting the self-signed SSL certificates for HTTPS INA live connections I have ended up by replacing the self-signed HANA Express SSL certificate(s) with the equivalent CA-signed SSL certificate(s).

Friday, 18 January 2019

Passing multi-value input parameter from Calculation View to Table Function in SAP HANA – step by step guide


In my previous post I demonstrated how to create Table Functions (TF) in SAP HANA XS Classic. One of the TF disadvantage, which I mentioned there was the fact, that they are not supporting multi-value input parameters – and this is official:

Thursday, 17 January 2019

Taming your SAP HANA Express (SE01E03). Learn how establish a HANA Live connection with SAML SSO to SAP Analytics Cloud

Let’s begin

Understanding SAML with SAP Analytics Cloud.

In order to understand SAML SSO (single sign-on) it is important to understand who is who, namely who is the SAML Identity Provider (=the authentication authority) and who is the SAML Service Provider (=the application).

Tuesday, 15 January 2019

Develop a full-stack multi module business application(MTA) by using java as middle-ware

In this blog, I will explain the step by step process to create a multi module business application(MTA) by using java as the middle-ware component with the help of SAP Web IDE full-stack and this application will be deployed onto the Cloud Foundry trail account.

Functionality of the Application :- Here I am going to display the list of employees of an organization.

Saturday, 12 January 2019

HANA Solution approach to implement different Business Use Case Part 1

In this blog I am going to discuss about the HANA Solution approach to implement different Scenario i.e which basis we will choose Native HANA or BWonHANA or SAP business suite etc to implement a client use case.

How to transport Calculation views with HTA with all Dependent objects in “One Click”

This blog is to explain our finding / solution to transport Hana Calculation views with dependent objects object with HTA – with classical transport.

Our main challenge was to move our Hana Development using HTA as we decided to apply LSA++ concept on our Hana modelling, by using Harmonization layers, Transformation Layers and Data Access Layer.

Thursday, 10 January 2019

Implementing Dynamic Currency Conversion Using Calculated Column Using Semantic Type Amount with Currency Code in SAP HANA


Currency Conversion is an important aspect of any data modelling and reporting software. SAP HANA software provides functionality for Currency conversion. Below we will see step by step process on how currency conversion takes place in SAP HANA. This article is completely based on my learning experience. I hope, this article will be useful for those consultants who are new to SAP HANA.

Tuesday, 8 January 2019

Introducing the NDSO: Part One – How to create a NDSO


When establishing an Enterprise Data Warehouse (EDW) there are two fundamental approaches which can be taken. Either an application driven approach can be chosen by opting for a solution which covers all tasks to be performed in an EDW out-of-the-box or the data modelling is natively performed directly on the database with a collection of separate tools to support the deployment and operations of an EDW.

Friday, 4 January 2019

Understand key watch outs and mitigations for your SAP S/4HANA Central Finance program

In this blog I have captured some of these key learnings and challenges along with potential mitigations based on our CFIN client implementation and Proof Of Concept (POC) experiences. I will classify these experiences and learnings based on primary four categories below:

I. Project Plan and Approach
II. Solution Architecture
III. Product Issues
IV. Skills and Resources

Wednesday, 2 January 2019

Smart Data Integration: Write Back to MS SQL Server

Prio 1 Use case for SDI is the Table Replication from a non-SAP Data- source into SAP HANA tables. For some Data- sources it is also supported to not only read data from it, it is also supported to write back to it.

Meaning having SAP HANA content as source and writing the Data into the 3rd Party Data- source. Source could be a table or a, even BW generated, Calculation View.