Linux – Memory Management insights

Nowadays the Linux memory management of a SAP system (application server) or SAP HANA system getting more important since the clear roadmap of SAP (Linux as only OS for HANA) is showing that the amount of Linux installations is rising steeply.

One of the worst things which could happen to such a system in context of performance is swapping or paging. But is swapping and paging the same?

Hana Development – Where are you going?

I have a question for you: Are you happy with the SAP Hana development tools?

If not, what can be done about it? I have a proposal…and would ask for your help

In case you find that an interesting thought, please comment, add your own ideas and requirements, spread the word, like it,… any help is appreciated. Without you, the idea will not progress.

HANA – Savepoint details

There are a lot of sources where you can find some rudimentary information about how a HANA savepoint is working or which event is triggering one. But not really how the different phases are working or which dependencies are there and how you can determine the thread details. In context of a customer issue I have done some researching and reengineering.

4 Best Practices for Securing Your SAP HANA Database

Databases hold the proverbial keys to modern business processes. These systems contain vast amounts of highly valuable and often sensitive data. This makes database systems a prime target for attackers. Comprehensive security processes and configurations are vital to prevent possible attacks.

AppToAppSSO between SAP Cloud Platform and SAP HANA DB

Introduction

HTML5 or Java based application deployed in SAP Cloud Platform fetch data from backend source, display it in application. There are different methods to establish connection between two applications in SCP. One such method is using destination which is a service offered by SAP Cloud platform.

Using Destination in SCP you can connect Application hosted on SCP with other application or DB using HTTP, LDA, MAIL & RFC.

Load flat file decimal values to ADSO (SAP BI) and access in SAP HANA Cal view ( eclipse/H Studio)

We had a requirement to load GAS emission data into SAP BI, as the business does a lot of manual calculations in excel, to get the emission factor which is dependent on multiple values. They first need to sum up the values, do a standard deviations, SQRT of some NO2, Co2, IC4 values, divide it by some factor etc., which is a heavy excel based lookups and calcuations.

How to Use SAP HANA Cockpit Capture APP and Workload Analysis APP Together

Introduction

SAP HANA Cockpit Workload Analysis APP is a very useful tool to analyze SAP HANA DB workload. By default, it utilizes the thread samples automatically collected with 10 seconds interval. On the other hand, Workload Analysis APP could also analyze workload collected by Capture APP. This post introduces an example to analyze the captured workload using Workload Analysis APP.

HANA Multitier System Replication – HOW TO Configure/ Take-Over / Fail-Back Setup

I was searching for step by step HANA multi-Tier Replication fail-over and fail -back procedure for DR scenario . I read all the blog post related to multi-tier Replication, but I could not find any blog post mentioning the steps for DR scenario where both primary and secondary will not be available at same time. so thought of writing my experience on this.

Flowgraphs in XSA (express edition H2SPS04)

Recently I was looking into flowgraphs in HANA 2 XSA SPS04. Since I have background in XS, HANA Modeling, and SAP BODS, I thought this may be an easy exercise to achieve.

Before getting into the solution, let’s see what is a flowgraph? A flow graph is the diagram representation of some logic executed with 0 or more filters (input params) in order to get some output.

Using SAP HANA as a service (HaaS) with Esri ArcGIS Enterprise 10.7.1 and Pro 2.4

This means ArcGIS Enterprise can use SAP HANA Service as the underlying database to support ArcGIS’s System of Record, System of Insight and System of Engagement.  HaaS is the first-ever database as a service that is fully supported by Esri ArcGIS technology.

Basically, the SAP Cloud Platform, SAP HANA service gives you cloud instances of SAP HANA on-demand, that are managed by SAP.  It’s great if you want to stand up HANA quickly and only want to pay for what you use.

CDS based data extraction – Part I Overview

Anyone interested in the state of the art extracting data in the SAP universe and beyond? This blog (series) is meant to provide a comprehensive overview of the topic, highlight the main features but also make sure you understand the meaning and implication of all available annotations related to the topic. I am aware of the fact that various documents/blogs have been published on the topic already, but for sake of completeness I will repeat parts here which you might already know.

SAP HANA XS Advanced - Cross-container access

You will learn how to set up the roles, synonyms and deployment configuration to access objects in a HANA Deployment Infrastructure (HDI) container from another HDI container.

Step 1: Create the target container as a resource

This tutorial uses the SAP HANA INteractive Education model as an example of a target HDI container. Create thistarget container by following the XSA-specific instructions found in the SHINE source code repository.

ABAP custom code adaptation for SAP HANA DB migration

Introduction

Objective of this blog is to provide a quick and short reference for custom code adaptation for SAP HANA database migration.

Scenario –  ERP system running on any DB to Business Suite on SAP HANA
Key Points to remember

HANA Studio – Convenient code snippet storage

This is a quick blog post to show a nifty place to store code snippets in HANA Studio. I’m thinking of snippets that you execute often and lose somewhere in your HANA Studio tabs, the ones where you haven’t been super diligent about saving as sql files. (Confession time, this is me, I have useful code snippets stored in lots of random places that seemed like a good place at the time.)

Note: I know HANA Studio is “dead” with HANA 2.0, however many people are still using it and are still using HANA XS Classic, so perhaps this tip will help someone have a nicer experience in the client tool.

Introduction to the Relational Data Lake Service DAT106 #SAPTechEd Recap

Presented at SAP TechEd

Below are my rough notes

How to use SAP HANA cockpit performance monitor & analysis apps to monitor/analyze heavy query issue

Introduction

There are different kinds of performance issue(high CPU/memory usage, lock wait for example) and even combination of them in SAP HANA DB due to the different use case, and it’s not easy to analyze them.

SAP HANA Hardware and Cloud Measurement Tools (HCMT) – Replacement of HWCCT Tool

Recently before installing SAP HANA on certified server, I thought of running SAP HANA Hardware Configuration Check Tool on the provisioned server. The latest available HWCCT version in service marketplace is 244 and I have used the same to perform the check.

NOTE: I have also used version 242 and the details provided below are encountered in both the version. 

First error you will encounter on running hwcct command for version 242 and 244 will be –

./hwcct: error while loading shared libraries: libhdbtmcachebase.so: cannot open shared object file: No such file or directory

I was able to get this file from the existing HANA database and copied this file to the lib directory of hardwareConfigurationTool folder

NOTE: This file is only available in HANA 2.0 SPS 04. You won’t be able to find this file in lower HANA database version. 

After that, above error got resolved. But now during landscape evaluation I encountered below error –

Failed to parse system information in readMemoryDistributionInfo, size=34754

Failed to parse system information in readNetworkInfo, size=34754

Error while running HWCCT:exception 1: no.1000010 (ltt/impl/strtod.cpp:707) TID: 24197

Invalid argument

exception throw location:

1: 0x00007fff9305d610 in ltt::throwInvalidArgument(char const*, int)+0x30 at new.cpp:296 (libhdblttbase.so)

2: 0x0000000126eb0d80 in int lttStoi32<char>(char const*, unsigned long*, int) [clone .constprop.46]+0x180 at iterator_base.hpp:1060 (hwcct)

3: 0x0000000126eb290c in ValidateSystemInfo::checkFSConfig4DataLog(ltt::map<ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> >, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> >, ltt::less<ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > >, ltt::rb_tree_balancier>&) [clone .constprop.14]+0x1ec at string.hpp:603 (hwcct)

4: 0x0000000126ecab50 in ValidateSystemInfo::checkFileSystemList(ltt::vector<ltt::map<ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> >, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> >, ltt::less<ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > >, ltt::rb_tree_balancier> >&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> >&)+0x980 at ValidateSystemInfo.cpp:1428 (hwcct)

5: 0x0000000126ecbb84 in ValidateSystemInfo::validateFilesystemConfig()+0x3e4 at memory.hpp:1258 (hwcct)

6: 0x0000000126ebd798 in ValidateSystemInfo::validate(ltt::basic_string_retval<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > (ValidateSystemInfo::**)(), int&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> >&)+0x1e8 at ValidateSystemInfo.cpp:1909 (hwcct)

7: 0x0000000126f007a8 in hwcctTests::EvalOS::runTest()+0x1698 at LandscapeTest.cpp:197 (hwcct)

8: 0x0000000126ead3f8 in main+0xf58 at HwcctHelper.cpp:112 (hwcct)

9: 0x00007fff93452140 in System::mainWrapper(int, char**, char**, void*)+0x50 at SystemMutex.cpp:203 (libhdbbasis.so)

10: 0x00007fff926a3920 in generic_start_main.isra.0+0x140 (libc.so.6)

11: 0x00007fff926a3b1c in __libc_start_main+0xac (libc.so.6)

12: 0x00007fff93445544 in __libc_start_main+0xa4 at IsInMain.cpp:78 (libhdbbasis.so)

exception type information:

- 0: public ltt::invalid_argument@0x7fff930de780 SI

- 0: public ltt::logic_error@0x7fff930deac0 SI

- 0: public ltt::exception@0x7fff930dec40

There is no SAP Note which addresses above issue. At first I thought there might be some additional pre-requisites as I’m using recently certified SUSE version (SLES 15 SP 1) but I could not find any. I raised message to SAP and found that – Its a programming error which is reported since HWCCT 242 and 244 version.

Also SAP HANA Hardware Configuration Check Tool (HWCCT) has been end of life-cycle (EOL) on Aug 1st, 2019. So now no further releases or patches will be provided to accommodate its fix. (As per SAP)

What’s NEXT?

A new SAP HANA hardware and cloud measurement tools (HCMT) is or will be introduced as a replacement of HWCCT. I could not find any official announcement of this tool but as per SAP, HCMT will be an official tool to check server before deploying HANA system in future.

HCMT is available for download in Service Market Place, so thought of giving it a try. Below is the official SAP Note for this tool –

2493172 – SAP HANA Hardware and Cloud Measurement Tools

Download the pdf attached in above SAP Note as it gives details on the usage of HCMT tool.

HCMT Overview

The SAP HANA hardware and cloud measurement tool (HCMT) allows customers and partners to collect information on the infrastructure intended for SAP HANA deployment. The tool measures whether the planned hardware or cloud system complies with the requirements defined by SAP.

Furthermore, it gauges whether the system planned for SAP HANA deployment can achieve satisfactory base performance by meeting the minimum requirements defined as well as satisfactory overall performance given the intended SAP HANA usage.

The measurement results are saved into a single file, which can be uploaded to the SAP HANA hardware and cloud measurement analysis for further analysis and reporting.

NOTE: SAP HANA hardware and cloud measurement tools are based on the requirements of SAP HANA Platform 2.0 or newer. For older SAP HANA versions, refer to the SAP HANA Hardware Configuration Check Tool

Download

You can download the tool from the SAP Support Portal at https://launchpad.support.sap.com/#/softwarecenter –> SUPPORT PACKAGES & PATCHES –> Search for: “hana optim”

Unlike HWCCT, which is ready to use just by extracting SAR file. Here, with HCMT we need to install the tool on the server.

First extract the tool using SAPCAR

It will have setup folder, navigate into the folder and install the tool using hcmtsetup command

After setup, the following folder structure is available:

The SAP HANA hardware and cloud measurement tool performs a series of automated tests, for example network tests, file system consistency tests, system management BIOS tests, and CPU benchmark tests.

The duration and repeat rate of the tests depends on the type of execution plan that you intend to run.

The following execution plans are available:

executionplan.json – Default execution plan that helps you to check if the KPIs for SAP HANA certification are met.

full_executionplan.json – Performs the same tests as the default execution plan, but has a higher test repeat rate and thus a longer test duration. This test is used for SAP HANA certification.

So for people who wants to validate HANA server before installing should use executionplan.json plan to test their HANA servers

NOTE: I have executed this tool for Scale-up System 

Prerequisites

◉ You have installed the latest version of the SAP HANA hardware and cloud measurement tool on the system.

◉ You have at least 20 GB of free storage space in the location where SAP HANA data can be placed during the test.

◉ When using nonvolatile memory, mounts for all hosts or an alias of the same name must be available.

◉ Port 50001 must be open for communication.

NOTE: This tool will run for a while, so make sure you run this tool in one of your jump server.

# ./hcmt -v -p <path>/setup/config/executionplan.json

Once the execution is completed it will create a file named hcmtresult-<dateandtime>.zip inside the same folder. Transfer that zip file into you desktop

We need to upload the measurement results file and analyze the results to see whether the systems meet the configuration and performance requirements.

https://hotui-supportportal.dispatcher.hana.ondemand.com/index.html

Click on “Manage Your Systems”

Click on (+) Add System

Provide details based on your usage and click Save

Click on “Upload Your Measurement Results”

If you have multiple system configured, make sure you upload measurement result to appropriate system.

Review and Submit

Analyzing the Measurement Results

SAP HANA hardware and cloud measurement analysis provides a graphical and textual representation of your measurement results. It allows you to see which parts of your system are doing well and which parts may need some changes or improvements to achieve the required performance.

You can read the pdf attached to SAP Note 2493172 on how to analyze the result..

Pro’s

1. Nice centralized repository for all of our HANA Server checks

2. Graphical insight but tedious to interpret result.

Con’s 

1. Difficult to read or get insight from the uploaded measurement as the result is not provided in the form of dashboard which can be drilled down to get more insight (like S/4HANA Readiness Check)

2. Currently there is no option to share the result to other S-User

3. I would rather prefer a quick summary in one file like below from HWCCT tool over individual selection

But as SAP suggested that this tool is still in development. So probably we can expect to get more holistic insight from this tool in future.

Join and Key in SAP HANA

In this blog, I would like to share the information on Join and Key in SAP HANA.

Explanation about Join:

What is SAP HANA Join?

Join in SAP HANA is used to Join table and information view and select values as per the requirement.

Split string into multiple rows using SQL in SAP HANA

Introduction

In this post I would like to describe options for splitting concatenated string into multiple rows using SQL in SAP HANA. Depending on which version of HANA system you are working you can choose the one which is valid.

SAP HANA EXPRESS EDITION in Yandex Cloud. Binary Installation. Step-by-step guide

About  a Cloud Trends.

A Cloud computing is a new technology trend. A lot of  guidelines about SAP in SAP Cloud Platform, Amazon AWS, Google GCP and Microsoft Azure But Cloud platforms there is much more. In this step-by-step guideline you know about newbie among Cloud Providers – about Ynadex Cloud.  Competition among cloud services is good thing for customers ! Prices are down – Quality are up.

ABAP Tool for receiving automated e-mails for SAP HANA Alerts

Introduction:

You want to receive automated e-mails for the currently active SAP HANA Alerts. These e-mails should be triggered by an ABAP program and the SAP Job scheduler (transaction SM36).

For this purpose, we have developed a little standalone ABAP program with the name RSHDB_SEND_ALERTS_BY_MAIL. This program sends automated emails with the currently active SAP HANA Alerts. Additionally, the program allows to restrict the alerts by the Rating and the Alert ID.

SAP HANA Flat File Upload

In this post, I would like to explain data upload to SAP HANA. SAP HANA support uploading data from a file. SAP HANA Support the following type of files,

.CSV (Comma Separated value files)
.XLS
.XLSX

Open Source GIS with SAP HANA

Introduction

SAP’s in-memory database SAP HANA features a geospatial engine, which makes SAP HANA a predestinated storage for geospatial vector data. Once data is residing in SAP HANA developers can leverage the power of HANA’s multi-model engines (e.g. graph and json document store) as well as the advanced analytics capabilities and embedded machine learning (e.g. PAL, APL, EML).

MRP Planning #2

This is in Continuation of my Previous Blog MRP Planning 

So in this Blog will see about

Planning with MRP areas

Multi-plant/site planning

Requirements grouping for individual project planning

MRP Planning Process

In this blog will try to Explore different Planning Process used for Full filling Business Needs.

We use special planning processes, for below reasons

◉ if we do not want to plan on a plant level, but either on a multi-plant levelor only for a part of a plant

◉ if we want to work with special procurement types.

Get Started with Data Modeling in SAP Data Warehouse Cloud

INTRODUCTION

Before we start our tour into SAP Data Warehouse Cloud world, I’d like to mention, that all content here was written based on the Beta Version of SAP Data Warehouse Cloud. Software settings, coding and/or code snippets are examples. They are not for productive use. This blog post is only intended to better explain and visualize new functionalities in SAP Data Warehouse Cloud.

Sandbox system via Homogenous System Copy (SAP HANA-specific: Backup/Restore) step-by-step guide

About

SAP system landscape is defined as an layout of SAP servers. Basically SAP environment consist a three-system landscape paradigm. A system landscape consists of Development Server (DEV), Quality Assurance server (QAS) and Production Server (PROD) Over time, you begin to understand that for experiments you need another independenty system – Sandbox (SAND).

SAP HANA Data Strategy: HANA Data Modeling a Detailed Overview

Why talk about HANA Data Modeling?

HANA data modeling is what drives real-time analytics while lowering the total cost of ownership (TCO) and time to deliver (TDL) business insights using SAP HANA digital business platform.

Monitoring HANA Service: Custom Email Alerting

Background

There are several options to monitor the SAP Cloud Platform HANA Service.

Case Study: Data Aging in SAP HANA and S/4HANA

First, I would like to share a recent message about data aging from SAP:

MRP Live on SAP S/4 HANA

In this blog will see some of the important things we need to see when we are suggesting MRP Live to your Clients.

There is Myth / negative opinions, as well as many of us, are not suggesting MRP Live to Clients because of earlier in 1511 versions there are some bugs and limitations but MRP Live has evolved year by year and now with 1809 onwards MRP Live is Stable and Runs without any issues.

Simple Linear Regression Python enjoy….

Once again I am writing this because of the motivation i am receiving from one of the most important course running @openSAP Introduction to Statistics and i am sure many of us are the active participant of that ,this resulted in writing this stuff on linear regression.

Regression: In statistical modeling, regression analysis is a set of statistical processes for estimating the relationships between a dependent variable and one or more independent variables. Wikipedia

How to Optimize BPC Model in SAP BPC 11, version for SAP BW/4HANA

In this blog, I will briefly describe you how to create a data manager package to achieve this. In the end, user could trigger this package no different to what he can do in older BPC release.

1. Create a BW Process Chain for BPC Model

a) Goto tcode RSPC in SAPGui, and create a new Process Chain.

b) Create a step with process type ADSOREM

Data loads to SAP HANA DB using SAP DS (Data Services)

SAP Data services:

SAP Data services is an ETL tool which gives a single enterprise level solution for data Integration, Transformation, Data quality, Data profiling and Text data processing from different source systems into a target DB.

What’s different in SAP Sales and Distribution (SD) in S/4 HANA

If your knowledge of SAP’s S/4 HANA only came from attending Sapphire, or reading the company’s marketing materials you might think that it was old news. After all, the product launched four years ago and has been pitched so hard since that surely by now every SAP customer must have not only drunk the Kool-Aid dry but also signed up and finished implementing it. But outside of the Orlando conference center spin zone, businesses need more than trade show hype to jump at the latest bright and shiny object. Business cases must be made, budgets approved, and projects scheduled, all of which take time. Lot’s of time.

How to support both MySQL and SAP HANA during development phase

Have you ever experienced a project that require support both MySQL and SAP HANA during the development phase.

In this blog post, I’d like to share my experience of how to support MySQL and SAP HANA during the development phase.

If We want to develop applications that support both MySQL and SAP HANA at the same time. We have to find the difference between them.

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!

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.

SQL vs HANA Integration in Bods

Introduction:

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

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.

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.

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.

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.

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.

SAP HANA revision upgrade step-by-step

Introduction

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

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.

SAP HANA Data Strategy

Overview

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.

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.

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.

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.

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

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.

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?

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.

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.

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)

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

Product & Database Information

This section gives you an overview on the components for SAP S/4HANA 1909.

Integrating Amazon Simple Queue Service (SQS) with SAP HANA

Introduction

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.

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.

Restricted & Calculated Measures in S/4 HANA Cloud Custom Analytical Queries(In-app extensibility)

In S/4 HANA cloud Custom Analytical Queries are used to build reports. Here in this blog we will talk about Restricted & Calculated measures and how those can be used. Let’s talk about a simple example to illustrate the use of these measures. For example, we need a report for financial reporting which includes –

1. Company Code (Dimension)
2. Ledger (Dimension)
3. G/L Account (Dimension)
4. Current Year Total In Company Code currency (Measure)
5. Previous Year Total In Company Code currency (Measure)
6. Total In Company Code currency (Measure)

S/4 HANA FIORI Transactional App data validations with FIORI ELEMENT Template and CDS -BOPF framework

Introduction: This Blog is to show S/4 hana fiori transactional app data validations with FIORI  ELEMENT  Template and CDS -BOPF framework.This covers   CDS creation, app crud operations(transactional behaviour), Odata Publish withannotations  and Odata registration to be used in front end. Required SAP landscape prerequisites are  Eclipse ADT, WebIDE, S/4 HANA  On-Premise with SAP_GWFND and SAP_UI components.

Main Part : The below steps are  required to  perform data validations with BOPF framework in S/4 HANA app.

Predictive Material and Resource Planning (pMRP)

In this Blog will discuss What’s New about Predictive Material and Resource Planning (pMRP)

With SAP latest release on 1909 HANA On-Premises Version, new functionality has been introduced to improve Capacity Issues, the new functionality is pMRP – Predictive Material and Resource Planning

Publishing data to Salesforce from SAP HANA using SDI.

Introduction

There are use cases where one has to publish huge volume of data from SAP HANA to Salesforce,  this blog describes options that are available with the Advantco Salesforce adapter for SDI. We describe how to use virtual tables to upsert (update/create) standard or custom objects in Salesforce. We will also handle platform events in case of more complex use cases where one has parent and child objects.

Playing with HANA parameters

Note: This blog is the recreation of an old blog on an old profile as part of the process of pulling all my content together on a consolidated profile.

The purpose of this blog was to share two end to end examples of passing parameters within HANA and using placeholders in SELECT statements.

I have created two scenarios:

1. HANA Table –> Table Function (with parameters) –> Calculation View (with parameters)

2. HANA Table –> Calculation View (with parameters) –> Procedure (with parameters)

Jenkins Build Process with SAPUI5 through HANA XSA

In this blog, we will build the NodesJS and SAPUI5 app in SAP HANA XSA that controls the Jenkins build process.

What’s Jenkins ?

Jenkins (jenkins.io) offers a simple way to set up a continuous integration or continuous delivery environment for almost any combination of languages and source code repositories using pipelines, as well as automating other routine development tasks.

SAP HANA 2.0 SPS03 on HANA Express – The (very good) first impressions

There are so many new features that I do not even know where to start! I have been playing with these for the last weeks and updating tutorials on XS Advanced. But I had to contain my excitement and  wait until everybody else could get their copy.

There are plenty of very cool features released in SAP HANA, express edition 2.0 SPS03, some are at plain sight and some not. This is my own recollection of the some of them.

Error Message “Unkeep Attribute could not be removed” for SQL Queries against External SAP HANA Views with Non-Cumulatives

Have you ever tried to expose a BW query with non-cumulative key figures as External SAP HANA View? Then, you probably bumped into the error message “Unkeep Attribute could not be removed”. This blog explains why the error message is raised and how it can be avoided under certain conditions.

When to use Execute in SQL Engine for Calculation Views

This posting will give an overview of the implications of the setting “Execute in SQL Engine”. This setting is available for Calculation Views to overrule the default execution behavior.

Background

When Calculation Views are included in queries the query is first optimized in a special engine called “Calculation Engine”. This has a drawback when the query is included in a larger SQL query because in this case two different optimization processes are involved: One for the SQL query part and a separate one for the Calculation View part. This can lead to inefficiencies between the different optimization processes.

Data Lifecycle Manager (DLM) Database Artifacts and Data Relocation Use Cases

Today’s post goes into more depth on the database artifacts that can be generated within a DLM profile and provides more detail on the data relocation direction use cases for moving hot data to cold data storage, cold to hot data storage or bi-directional movement of data between hot and cold data stores. Let’s dive right in:

S/4HANA – what impact on BW and BW/4HANA??

In this blog, I’ll detail another issue linked to the migration of a system but in this case, it is the migration of ECC to S/4HANA and the impact this has on the BW and BW/4HANA systems.

The main impact on BW and BW/4HANA after upgrading ECC to S/4HANA is on the BW datasources (DS) object type.

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.

Business Partner SAP S/4 HANA insights

Business Partner Approach in SAP S/4 HANA

The following blog post provides an insight into the SAP S/4 HANA system and how business partner setup must be done for migration.

I would like to share a glimpse of my current experience with SAP S/4 HANA migration.

Many of us always struggle where to start, how to start and finally ends with why to start

Socket.IO File Upload in SAP HANA XSA

In this blog, we are going to build a file (.csv) upload app with NodeJS and Socket.io. In previous blog, I created the similar app but using XSJS lib in HANA XSA. With websocket, I would like to overcome the gateway timeout issue when using HTTP post method.

Let’s get started by creating the SAP Cloud Platform Business Application with database, NodeJS and web module.

Create CSV File Upload SAPUI5 App with SAP HANA XSA

In this blog, I am going to share how to create a simple SAPUI5 app to upload .csv file into SAP HANA XSA tables. We will create the multi-target-application that consist of database, XSJS and SAPUI5 module.

Let’s get started.

Lets discuss some good practices of coding

This blog will help folks who just on-boarded for ABAP in understanding the codes in line with it.

Note: 1st block of code indicates incorrect way of coding. Codes that follow the golden rules are written just after that.

SAP HANA ML Python APIs: Sequential Pattern Mining Algorithm (SPM)

Welcome to HANA ML Python API for sequential pattern mining aka (SPM) method.I explained first four methods of association analysis in my previous blog post.

Note: Make Sure your python environment with HANA ML is up and running ,if not please follow the steps mentioned in previous blog post.

Association Analysis Algorithms Implementation using HANA ML Python APIs.

Let’s Start –

Here is small list & introduction of the methods which I will be implementing one by one.

Introduction and algorithm description

I have used Jupyter Notebook which uses the real time itemset dataset to demonstrate the association rule mining algorithms below which are provided by in hana_ml package.

Expect Better from your Data Warehouse

As a young man growing up, my teachers, coaches, or other adults would not hesitate to use words like “You can do better”, “I expect more”, and even “Just do your best”. I (like most kids) often fell short of expectations. Each spoken time, these phrases would create an opportunity for me to evaluate how I fell short and how I must change to be successful in the future.

Central Finance (CFIN) – Cost Object Mapping

This blog post is proposed for the Central Finance implementation project team. Sharing this information based on my experience in Central Finance project. The landscape was SAP 4.6C source system, separate instance of SLT and Target S4 HANA 1709

WhatsApp Integration with SAP S/4HANA

I have added Part II is here, which will discuss the how we can handle the security aspect.

But How this integration make sense?

Answer is very simple think about a situation where you want to know your order status, either you would login to system or you ask someone. Now instead of doing this if you could ask whatsapp bot which could tell you insight of your order. Much simpler isn’t’ it.

Implement Security in WhatsApp Integration with SAP S/4HANA

Security is important aspect in any Enterprise conversational system when it is Hosted in Public social media like WhatsApp, Facebook etc, Because now a days everyone got smart phone. Welcome to my another blog where i am going discuss about security aspect of WhatsApp integration with SAP S/4HANA, as most of the people are interested to see how security can be taken care in this particular integration so thought to write another blog in it.

New Output Management for S/4 Hana system. Purchase_Order, Sales_Order.(Print & IDOC)

Agenda: This document gives brief insight into new output management for S/4 Hana (Using BRF+) and how to use the new OM for printing and for the purpose of IDOC generations.

Before opting for New OM, please go through the Notes mentioned below, which could help in understanding the possible implementation and also supported sources in new OM.

SAP C/4HANA Extensibility – Triggering Lambdas with Events

This blog will detail how a Lambda function can be triggered to run when an event is published into the Kyma environment. To eliminate any barriers, we will utilize the SAP Commerce mock application to send events, but the process flow would be the same if using SAP Commerce. The setup of SAP Commerce can be found in this blog.

What is the difference CalcView versus SQL View?

Recently I was asked what the difference between a Hana Calculation View and a SQL View is. To provide reading material, I did a quick search via google and was shocked by the answers I found. Some wrong, some missing the point, many outdated.

Conquer your data with the HANA DataFrame – Exploratory Data Analysis

Source: https://www.history.com/topics/exploration

Diving into the HANA DataFrame: Python Integration – Part 1

>>> from math import pi
>>> π = pi
>>> area = π * r**2

>>> résumé = "knows Python"
>>> "Python" in résumé
True

Sneak peek into S/4HANA 1909 Finance Innovations Part – 1

SAP has yet to release S/4HANA 1909, but I have some interesting sneak previews on what you can expect in the area of Finance. Of course, this would not cover everything, but I will focus mainly on the Finance capabilities in the S/4HANA Core. Interesting things are happening in the area of Profitability Analysis for example. Is COPA going to be replaced? Or is SAP just changing product names.

SAP Cloud Platform Extension Factory – Connecting to SAP Commerce Cloud

One of the key components of the SAP Cloud Platform Extension Factory Kyma runtime is the Application Connector.  The Application Connector provides a mechanism to simplify the connection between external systems and Kyma in a secure manner.  Once the initial connection has been established, the registration of the external Events and APIs of the external system takes place. The Events and APIs are then available within the Kyma Service Catalog.  The events can be consumed asynchronously with services and lambdas (serverless functions) deployed within Kyma.  Additionally, the Application Connector provides monitoring and tracing capabilities to facilitate operational aspects.

S/4HANA for Customer Management (S4CRM 1809) second look

SAP BW/4 2.0 – CAL for it …

We had a look to the CAL library for the latest releases of BW/4 and we found a brand new DEV Image of BW/4 2.0 including the BW/4 1.0 Content Add-On

SAP HANA XSA Email Example

For a few of the items he wanted, like bg-deploy, I was able to point to existing content that hopefully will help. But for some of the items there certainly were lacking examples.  One of them he mentioned was Email from XSA (pure node and xsjs).

This is a particular example or exercise that is often requested but I’m personally reluctant to do. It gets complicated fast because of the dependency upon an external SMTP server and the individual setup and authentication steps needed for the various different providers.

Currency Conversion in HANA based on Fiscal Period

Background

Whenever there is a requirement for Currency Conversion, the time reference plays a dominant role for determining exchange rates. Exchange rates vary on daily basis and which exchange rate should be applied for currency conversion is always a question.

HOW-TO: Activate Master Data Hierarchies for SAP Analytics Cloud (SAC)

Introduction

SAP Analytics Cloud enables to create dynamic visual stories based on key business areas with trusted data that is managed by IT.

There are many introductions and learning materials for creating powerful reports and dashboards for SAC. All the information shows how to visually deal with data derived from various sources. Since the BW live connection via BW queries does not have all the required features yet, we are using live connection via External SAP HANA Views. The External SAP HANA views are query-based. This is the only way it does work with the master data hierarchies right now.

Develop Simple on HANA Express in AWS Cloud 9 Checkpoint – How to Catch Up/Restart

Develop Simple on HANA Express in AWS Cloud 9
Develop Simple on HANA Express in AWS Cloud 9 Part 2 – The Backend App
Develop Simple on HANA Express in AWS Cloud 9 Part 3 – The Frontend App

Overview

In the past 3 parts of this series, we’ve done a lot of Cloud 9 configuration and coding. As someone whose first job is not that of a technical writer, I know that some steps may not have been clear. I also know as someone who follows along to tutorials, sometimes I just need a ‘fast forward’ or ‘catch up’ button. This will be the point of this part of the series. Or if you happen to massively mess up your progress, this will walk you through quickly getting back up and running as-of Part 3 in the series.

How to influence degree of parallel execution when modeling HANA Calculation Views

Background

SAP HANA uses an involved algorithm to decide about the parallelism with which queries are executed. However, in some situations you want to influence the degree of parallelization on top of the general HANA mechanism and control the parallelization of individual parts of your models based on business considerations.

Playing with HANA Parameters

The purpose of this blog was to share two end to end examples of passing parameters within HANA and using placeholders in SELECT statements.

I have created two scenarios:

1. HANA Table –> Table Function (with parameters) –> Calculation View (with parameters)
2. HANA Table –> Calculation View (with parameters) –> Procedure (with parameters)

SAP HANA XSA Controller API Interaction

Since the introduction of SAP HANA extended application services, advanced model (XSA), SAP has supported many new approaches to accessing the platform APIs.  XSA is based upon Cloud Foundry which provides its core functionality via a command line client and a REST enabled web API.  XSA has this same functionality, but most of the focus on platform admin and interaction tends to focus on the CLI interface or the browser-based administrative UI which SAP deliveries. However behind that web UI are essentially calls to the controller APIs. These same APIs can be called from and used in your own applications.  In this blog I’d like to share some experiences trying to use these APIs.  There are some common challenges anyone using them will face and perhaps this blog can be helpful in that regard.

Develop a Spring Boot (Java) application with HANA database on SAP Cloud Platform (Cloud Foundry) – PART 3

We will continue from where we left off in the previous part where we finished configuring the HANA Database and the user that will communicate with the database.

STEP 4: Deploy the Application

Let’s build the war file first. If you are using Eclipse, then perform a maven build and specify profile as cf. Otherwise, you can also build the application using maven command line tool with the following command –

Develop a Spring Boot (Java) application with HANA database on SAP Cloud Platform (Cloud Foundry) – PART 2

In this blog post, we continue with the Spring Boot application that we developed in PART 1. We will now look at the steps involved in binding a HANA instance with our application.

STEP 2 : Create HANA service instance.

We will create the HANA service instance in this step. HANA service provisions a HANA DB for us. This is a paid service so you’ll need to enable it using ISM tool.

For this exercise, we will use the 64standard service plan.

Download and Installation of SAP HANA Studio 2.0 (SP3) with ABAP & BW Perspectives

Here are the comprehensive steps for download and installation of SAP HANA Studio with ABAP & BW perspectives which helps to initiate the development activity to Analytics Consultants.

What is SAP HANA Studio?

SAP HANA Studio is an Eclipse based, integrated development environment (IDE) for development and administration of SAP HANA Database in the form of GUI tool.

ACI Base24 HP NonStop Data Integration to SAP HANA DB

Solution Proof of Concept

Develop a Spring Boot (Java) application with HANA database on SAP Cloud Platform (Cloud Foundry) – PART 1

In this blog series, we will develop a Spring Boot application and deploy it on SAP Cloud Platform (Cloud Foundry). For persistence, we will make use of SAP HANA service on SCP. The goal of this project is to show how we can make use of HANA database in Cloud foundry. The application itself is very simple – REST endpoints supporting CRUD operations on Employee entity.

In what way In-Memory Computing Powers Artificial Intelligence

HANA Backup Recovery Strategy On AWS

Purpose

The purpose of this blog is to highlight backup solution that can be designed for HANA database on AWS without any overhead of using third-party tool. The idea of specifically mentioning AWS is because I’m using AWS Simple Service Storage (S3) for this solution, otherwise you can incorporate this approach in any other cloud provider (Azure, GCP) or even on-premise.

Upgrading HANA XSA & WebIDE + SSL Configuration

Backup

First backup all your existing XSA projects to Git and/or export the mta archives.

Obtaining the Software

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

How to deal with Value Unconverted in SAP Tables for CDS Views, Calculation Views or BW Enhancement

This Blog Post Provide Information on difference between Value and Unconverted Values in SAP Tables. In some table when we check in SE11 or SE16 we can only see Unconverted Values for fields, but when check in SE16N  we can see its actual char value. In this blog post we will deal with scenario where we need to use these values in our modelling scenarios how can we overcome the problem on whether which values to consider.

Increase HANA data capacity with – SAP HANA Native Storage Extension(NSE).

Introduction:

SAP HANA Native Storage Extension(NSE) is a general-purpose, HANA built-in warm data storage solution. This solution is available on HANA 2.0 SP04. As we all know that now a day’s value of data is enormous from an organization standpoint of view and Hence data storage solution and Access mechanism of data matter a lot. Data is broadly categorized into 3 different temperature tiers – Hot, Warm and Cold. Frozen is also there, normally it is not considered in HANA data tiering options(DTO).

xsjs – Job Notification Via Email with Attachment

One of the requirement that we often come across is Jobs Execution Notification in SAP HANA via email .I also want to address the issue of email attachment (We often come across requirements asking to automate the results notification via email as an attachment) – So I thought we can address both the issues today

End to End Model of Data Analysis & Prediction using Python on SAP HANA data

This blog post helps to connect with SAP HANA DB (Version 1.0 SPS12) then extract the data from HANA table/View and analyze the data using Python Pandas library. Then you can clean and select independent variables/features data to feed the Machine learning algorithms to predict dependent variables or find insights.

SAP S/4 HANA Manufacturing Cycle (MTS / MTO) in Fiori Apps

After the Release of HANA from 1509 the Usage of Fiori Application is becoming mandatory day by day and with every New Release of HANA it’s becoming more and more

So many of Us are not aware of how to Use those Fiori Apps in our Manufacturing Cycles like MTS / MTO.

For each and every Transaction is having a Significant App in Fiori.

Let’s Get into the process and explore some of the important Apps to use in our day to day projects.

Just another dummy data generator for SAP HANA

The most of the times we don’t have enough data, or even any access to customer real data, so we have to generate some rows. In order to do that, i just wrote a python script to generate dummy data and I want to share it with you.

In very simple terms, this python script works generating rows for a given HANA table; it takes table metadata for columns definitions (taking account data types, length, etc), and then it generates a random value according to column specification. I’m using Python and SAP Python HDBI client for SAP HANA, and I think it would work with PyHDB Python library as well.

SAP HANA Smart Data Integration and Smart Data Quality Webcast Recap

Analytics is the core of running the business with deep insight for decision making. Running the business is better or rather say best, when the platform is SAP HANA. The critical fuel for analytics is right data. Data can be raw and as is or it can be enriched and improved to make it meaningful. Data Integration with Data Quality is the key to procure and make data meaningful. In this session we will be sharing level two information about SAP HANA Smart Data Integration and Smart Data Quality with additional information on Data Virtualization.

SAP Hana Technology and Hadoop Ecosystem

SAP Hana cutting-edge Technology and Big Data Hadoop Ecology

SAP HANA Development from Alternative IDEs

In this blog I’d like to revisit the topic of using alternative IDEs but this time also look at how to connect to and use a HANA DB. I think we’ve perhaps created the incorrect impression that only way to perform modern development with HANA (HDI in particular) is to use XSA/Cloud Foundry and the SAP Web IDE. While there is a strong focus on making development easy in the SAP Web IDE and deploying to XSA/CF; that certainly isn’t the only way to develop on HANA.  So in this blog I’ll also dive deep into the topic of using the SAP Cloud Platform based HANA As A Service from outside the Cloud Platform tooling.

How to access an SAP HANA XSA Container schema from external applications such as NodeJS

My Licensed To Code colleague Roland Schulz and I have been working on SAP HANA XSA development for the past few years. We have been doing lots of NodeJS development on both SAP HANA XSA and also outside of HANA. We have a scenario which we are developing of a NodeJS application and needed to write data from the external NodeJS application into an SAP HANA Container schema but we could not connect to the schema from the outside.

The Few Facts About SAP Leonardo, SAP HANA and Machine Learning

https://iytwist.blogspot.com/

Improve the quality of your data with SAP Data Hub

Data drives the business processes we all rely upon, yet in many organizations poor quality data causes inefficiencies that could be avoided. SAP Data Hub includes various data quality operators that allow data pipelines to be created that can improve the quality of data in motion, or at rest.

Binding Node.js Application to HANA Databases

Introduction

In this blogs, I will explain about the way of accessing HANA tables from Node.js Application.
Especially, I will explain about issuing certification on SCP and implimenting conn_param in app.js