Thursday 31 October 2019

The Ultimate Unofficial Free SAP HANA Starter Kit

I was recently working with a customer who was very interested in using SAP HANA as a data-mart for their SAP Applications. During our meeting, the customer expressed that the IT department was excited about the benefits that SAP HANA could bring to the organization. The next step in the internal process was to demonstrate the value of this project against other initiatives at the executive level. This customer needed a SAP HANA project to prove value, but the approval process required the value before the project could start – a frustrating chicken/egg scenario!

Wednesday 30 October 2019

SAP S/4 HANA for Dummies

With the proliferation of digital transformation and all of its associated technologies such as RPA, cloud, AI etc. software vendors are swiftly adapting their current product offerings to meet the new wave of business demands. SAP, the behemoth in the ERP space is no exemption. SAP’s core ERP product has always been ECC but over the years the software giant has invested in developing an intelligent ERP system. This new system is not an upgrade to its core ECC but a complete new business suite with a simplified core, an in-memory database designed by SAP, a grade-A role based user experience called Fiori, and additional flexibility to integrate and extend intelligent solutions in the cloud with SAP S/4HANA cloud platform. It is called S/4 HANA. Each new version has a simplification list. Simply type **** (product version e.g. 1909) SAP S4HANA SIMPLIFICATION LIST online to get the information.

Friday 25 October 2019

SQL vs HANA Integration in Bods


This Blog post explains step by step procedure. How to Load data to the SQL source to SAP HANA through SAP BODS.

Step 1:

1. First Need to give connection between MS -SQL and SAP BODS because of we can import data easily from Source by giving connection.
2. Create Data store between SQL source and BODS

Wednesday 23 October 2019

S/4 HANA CDS View Search and related Fields Information

We used to spend lot of time in identifying the SAP delivered CDS view(s) or Existing CDS View(s) in the system before starting the development which is very important so that we don’t create duplicate objects and also we can utilize SAP delivered objects. Personally I felt the process was really painful and time taking.

As a Coding Savvy I could able to identify the tables which has all the Meta data information about the CDS view(s). So I had created a table function in S/4 HANA system which makes CDS search is easy. I am hoping that developers could able to leverage this code so that they could save lot of investigation time.

Tuesday 22 October 2019

What’s New in SAP HANA Cockpit 2.0 SP 11

SAP HANA cockpit 2.0 SP 11 introduces numerous new features and enhancements to existing features.

Highlighted below are five features that have been enhanced to improve the functionality and the user experience of the SAP HANA cockpit.

1. Enhanced Support for Native Storage Extension

Check out the new Buffer Cache Monitor of the SAP HANA Native Storage Extension to find out which tables, partitions, and columns are using most of the cache. This allows you to avoid negative impact on workloads by catching out-of-buffer alerts.

Monday 21 October 2019

BEx Query based Fiori App

We all know BEx queries have been the traditional Sap BW reporting method to analyze the dataset of the BI system. Info Objects are combined in a query and data is evaluated in a tabular report.

Now Enterprise Reporting can be taken to the next level with the advent of Fiori and SAP UI5. Here are a few points why you should consider creating a custom SAPUI5 app to analyse BI data.

Sunday 20 October 2019

SAP HANA High Availability

SAP HANA system replication provides the possibility to copy and continuously synchronize an SAP HANA database to a secondary location in the same or another data center. Usually, system replication is used to support high availability and disaster recovery.

Friday 18 October 2019

Shaping BASF’s Digital Future with SAP Fiori and SAP HANA

BASF creates chemistry for a sustainable future. In line with this corporate purpose, approximately 122,000 employees contribute to the success of customers in nearly all sectors and almost every country in the world. Its highly skilled customer service teams are the customers’ key contacts for order progression, building lasting customer relationships for the BASF group.

Thursday 17 October 2019

SAP HANA revision upgrade step-by-step


Introduction.Basis Administration in the Age of SAP HANA require a new skills from SAP Basis Administrators. One of them HANA DB Maintenance & Upgrade. For example: DB-revisions should be installed at regular intervals to avoid errors and to keep your Database up to date

Wednesday 16 October 2019

HANA Cockpit with HA through a load balancer

In this article I will show how I’ve built a HANA Cockpit with High Availability for our production databases, through a load balancer. I recommend to start reading the SAP guide HowTo: High Availability for SAP HANA cockpit using SAP HANA system replication, as it describes most of the work required but does not cover the setup of the load balancer and the changes required in HANA Cockpit configuration. I’ve decided to write this article just because the time required to complete the setup and solve all issues appeared.

Tuesday 15 October 2019

SAP HANA Data Strategy


As database and business analytics professionals we have always struggled with implementing the business’s conceptual data model and analytics strategy given the limitations of traditional database technologies. We understand the data and the many attributes that allow us to view the data from many angles, but the traditional database technologies did not allow us to create very wide tables and limited the number of ways we could access the data. These limitations then drove the models to have multiple copies of data summarized for specific use cases. All of these traditional database limitations lead us to create very complex models for solving quite straight forward problems. The complexity of the data models then created limited flexibility and tremendous latency.

Monday 14 October 2019

Adding XS Tooling to your SAP HANA, express edition Server Image

Out of the box the SAP HANA, express edition (HXE) server only option is ready to go with a lot of basic functionality. However, to use it you need to install the SAP HANA plugin for Eclipse. This of course is not a bad thing, however you may also like the idea of using the browser based tools.

This guide will help walk you through the steps necessary to install the SAP HANA XS tooling allowing you to use a browser to interact with your server going forward.

Sunday 13 October 2019

Improvements of BW/4HANA Analytical Engine in Q1 2019 with BW/4HANA 2.0

Let us have a glimpse on each of the topics in detail.

Conditions evaluated in SAP HANA

With BW/4HANA 2.0 also the execution of queries with conditions can be pushed down to HANA. For this we introduced a new value 9 for query property ‘Operations in BWA/HANA’ (with technical widely known name TREXOPS). Setting TREXOPS to this value, the OLAP engine tries to push down the calculation of the query containing conditions to HANA.

Saturday 12 October 2019

Improvements of BW/4HANA Analytical Engine in Q3 2019 with NW BW SP16 or Q1 2020 with BW/4HANA 2.0 SP4

We are now with BW/4HANA 2.0 SP 4 and NW BW SP16 shipping those new features. The main driver for those innovations is the SAP Analytics Cloud integration. But a lot of features can also be used in SAP Analysis for Office or the BW/4HANA query preview.

Friday 11 October 2019

Memory Forecast for SAP HANA with SAP EarlyWatch Alert Workspace

It can be difficult to keep an eye on the memory consumption of all your SAP HANA systems in your landscape. There is a new overview and visualization available now.

SAP has released two new forecasts for the memory consumption for an SAP HANA database:

1. Main memory consumption forecast
2. Data footprint forecast

Thursday 10 October 2019

HANA startup tuning – part 2

Starting with HANA 2.0 SPS4 there is a new option called fast restart. This option allows the DB to keep the column store (main area of CS) in memory during a restart of the HDB. So there is a difference to pmem. Persistent memory keeps the data also after an OS restart or power outage. This means that the fast restart option is a bridge technology which can be used independant from CPU and memory type. There are no additional costs to use it. This means also that there is no reason not to use it.

Wednesday 9 October 2019

HANA startup tuning – part 1

One of the biggest challenges with SAP HANA databases are the duration of the startups. Here we have to separate the available time and the reload time.

In my career as consultant I’ve seen a lot of HANA databases with pretty long startup times with more than 1 hour. This is also the reason why SAP introduced the fast restart option with SPS4. But which possibilities are there to speed up which phase with which release? Because a lot of DBs are still not on SPS4 and can not profit from new features. How you can identify the bottleneck?

Monday 7 October 2019

Simulating my shared Food HDI container

The most valuable part of this are the opening talks that provide context, interesting demoes and interactions with other people as you learn your way into Cloud Foundry and HANA. However, if you couldn’t make it or if you want to do this again on your own, this blog post is for you.

Saturday 5 October 2019

SAP UI5 app on SAP HANA Cloud Trial Service

I just explored the SAP HANA service available in SAP cloud platform. Got to know many gears and finally came up with this noisy blog.

Below are the footsteps to chase UI5 app development in SAP HANA service provider.

Friday 4 October 2019

S/4HANA 1909 FPS00 Installation: Part 2 – Installation and Upgrade

S/4HANA 1909 FPS00 Installation: Part 1 – Maintenance Planner

This blog highlights the necessary step to install S/4HANA Server using Software Provisioning Manager (SWPM) and apply Fiori add-on using Software Update Manager (SUM)

NOTE: SWPM will only install S/4HANA Server 1909 and all the add-on installation i.e. Fiori Front End Server, Fiori for S/4HANA etc. will be part of Upgrade procedure (SUM)

Thursday 3 October 2019

Wednesday 2 October 2019

Integrating Amazon Simple Queue Service (SQS) with SAP HANA


Amazon Simple Queue Service (SQS) is a fully managed message queuing service that enables you to decouple and scale microservices, distributed systems, and serverless applications. To integrate SQS with a HANA database, Advantco developed an adapter SQS for SAP Smart Data Integration(SDI). The adapter enables bi-directional data exchanges between HANA databases and AWS SQS. This blog details the steps required to replicate data from a SQS queue to a HANA real table.

Tuesday 1 October 2019

How to send data from Apache NIFI to HANA

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

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