Sunday 29 December 2019

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?

Saturday 28 December 2019

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.

Friday 27 December 2019

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.

Thursday 26 December 2019

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.

Wednesday 25 December 2019

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.

Tuesday 24 December 2019

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.

Monday 23 December 2019

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.

Friday 20 December 2019

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.

Wednesday 18 December 2019

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.

Monday 16 December 2019

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.

Saturday 14 December 2019

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.

Friday 13 December 2019

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.

Thursday 12 December 2019

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

Wednesday 11 December 2019

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.

Saturday 7 December 2019

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.

Friday 6 December 2019

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.

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

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. 

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

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”

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

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

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

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

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

After setup, the following folder structure is available:

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

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.

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

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

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

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

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

Click on “Manage Your Systems”

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

Click on (+) Add System

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

Provide details based on your usage and click Save

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

Click on “Upload Your Measurement Results”

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

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

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

Review and Submit

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

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

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

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

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

SAP HANA Study Materials, SAP HANA Tutorial and Material, SAP HANA Learning, SAP HANA Guides, SAP HANA Online Exam

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.

Wednesday 4 December 2019

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.

Monday 2 December 2019

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.

Sunday 1 December 2019

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.

Friday 29 November 2019

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.

Thursday 28 November 2019

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

Wednesday 27 November 2019

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

Monday 25 November 2019

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

Saturday 23 November 2019

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.

Friday 22 November 2019

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.

Wednesday 20 November 2019

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

Friday 15 November 2019

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.

Thursday 14 November 2019

Wednesday 13 November 2019

Friday 8 November 2019

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.

Wednesday 6 November 2019

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

Tuesday 5 November 2019

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

Monday 4 November 2019

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.

Saturday 2 November 2019

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.

Friday 1 November 2019

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.

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

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

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


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

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.

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

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.

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.

Monday 30 September 2019

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)

Friday 27 September 2019

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.

Thursday 26 September 2019

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

Wednesday 25 September 2019

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.

Tuesday 24 September 2019

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)

Monday 23 September 2019

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.

Saturday 21 September 2019

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.

Friday 20 September 2019

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.

Thursday 19 September 2019

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.

Wednesday 18 September 2019

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:

Tuesday 17 September 2019

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.

Monday 16 September 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.

Friday 13 September 2019

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

Thursday 12 September 2019

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.

Wednesday 11 September 2019

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.

Tuesday 10 September 2019

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.

Monday 9 September 2019

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.

Wednesday 4 September 2019

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.

Tuesday 3 September 2019

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.

Monday 2 September 2019

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

Sunday 1 September 2019

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.

Friday 30 August 2019

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.

Thursday 29 August 2019

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.

Wednesday 28 August 2019

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.

Tuesday 27 August 2019

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.

Thursday 22 August 2019

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

Wednesday 21 August 2019

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.

Tuesday 20 August 2019

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.

Saturday 17 August 2019

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 Tutorials and Materials, SAP HANA Certifications, SAP HANA Learning, SAP HANA Online Exam

Friday 16 August 2019

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.

Wednesday 14 August 2019

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.

Tuesday 13 August 2019

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.

Monday 12 August 2019

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.

Sunday 11 August 2019

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.

Saturday 10 August 2019

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)

Friday 9 August 2019

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.

Thursday 8 August 2019

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 –

Wednesday 7 August 2019

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.

Friday 2 August 2019

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.

Wednesday 31 July 2019

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.

Monday 29 July 2019

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.

Friday 26 July 2019

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.

Thursday 25 July 2019

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.

Wednesday 24 July 2019

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

Monday 22 July 2019

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

Friday 19 July 2019

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.

Wednesday 17 July 2019

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.

Tuesday 16 July 2019

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.

Monday 15 July 2019

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.

Friday 12 July 2019

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.

Thursday 11 July 2019

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.

Monday 8 July 2019

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.

Saturday 6 July 2019

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

Friday 5 July 2019

Robotic Test Automation Brings Ends To Scripting

Robotic Test Automation Brings Ends To Scripting


Scripts always brings an expression that can foray fear into the hearts of the most fearless team of developers, QA experts and project managers as they try to deliver changes into an SAP system on time and under budget.

Well, possibly not so much ‘fear’ as a discouraging sense of acknowledgement.

Wednesday 3 July 2019

SAP Hana Geospatial – Making things simple

SAP Hana customers often ask about an easy way to use Hana Geospatial capabilities to address their business scenarios related to simple location problems such as determining the “distance between two locations” or if “location X is accessible from location Y in less than 10 minutes by car”, or what is “minimum distance between location Z to location A”…

Monday 1 July 2019

The power of the HANA-optimized Business Content (SAP BW/4HANA) – Example FI-AA

In this blog post I want to demonstrate you the power of the HANA-optimized Business Content and how it can help to speed up your BW/4HANA implementation.

For this, let us have a closer look together into the business content area of Fixed Asset Accounting – as an example.

Friday 28 June 2019

S/4HANA Conversion

Overview


You have an existing ERP system, and you want to leverage your previous investment in the business processes that you already have implemented in ERP. You want to bring them to the new world of SAP S/4HANA. Then S/4HANA system conversion is perfect option for you…!!!

Wednesday 26 June 2019

Setting up SSL on Application Server S/4HANA

This blog post is for setting up SSL for Application server S/4HANA for successful connection with SAC (SAP Analytics Cloud).

Background –


When we are connecting SAC (SAP Analytics Cloud) to SAP S/4HANA system with direct live connection, we need to make trusted connection.

Monday 24 June 2019

Smart Data Integration: HanaAdapter from HANA Express to HANA as a Service

If I’m doing something for the first time and I know I will need to replicate it multiple times, I tend to take screenshots and notes for my self of the future. Since I got this question a couple of times in the last weeks, I’m publishing those notes.

This post is about setting up Smart Data Integration from an on-premise SAP HANA instance (HANA Express in my case) to my tenant of SAP Cloud Platform, SAP HANA Service on Cloud Foundry.

Friday 21 June 2019

Machine Learning with SAP HANA & R – Evaluate the Business Value

In this blog, I will show how to evaluate the business value from a machine learning model built in SAP HANA using R.

Combining SAP HANA & R allows the data scientist or advanced business analyst to leverage the power of SAP HANA and at the same time get the vast functionality from the use of R Packages. The main benefit with an approach of using SAP HANA in combination with R is that it allows you to utilize the power of SAP HANA both in terms of scalability and performance through R scripting. In a nutshell, there is no movement of training data from SAP HANA to the R server/client and the training of machine learning models is performed exactly the same place as where the data resides. In short: algorithms and data are on the same in-memory SAP HANA server.

Wednesday 19 June 2019

GRC Access Control 12.0 ARM setup for provisioning HANA DB users

Let’s first go over an example of a HANA DB role request and then show that role provisioned in HANA DB through GRC Access Control.  First screenshot below is an access request for HANA DB role ABAP_ADMIN. Once the request is submitted and goes through the approvals, the role gets assigned to user ID.  The second screenshot shows the assignment in HANA DB.

Monday 17 June 2019

Capture Change Data with the SDI Flowgraph Table Comparison

When batch-loading data from a source system into your Data Mart or Data Warehouse, you usually look for ways to reduce the to-be extracted data set to minimize extraction time and resource consumption. Ideally, there is a way to only extract changed records, for example, using a change date column. However, this does not always fly. For example, change date columns are not always reliable or deletions are not always tracked in the source table. An alternative would be to switch from batch to log or trigger replication on the source, but you don’t always have this luxury. So, now you have to load the entire source data set, but still you want to identify the change data, to only process delta’s in downstream data flows. How can you identify such change data using batch loading?

Sunday 16 June 2019

How to Connect SAP HANA with GeoServer

Meanwhile SAP HANA and its spatial features can be used with a lot of third party GIS (Geographical Information Systems) tools. One crucial question is on how to connect SAP HANA with these tools. This might be quite different from tool to tool and sometimes also be kind of hidden information, especially when the possibility and support for a certain tool is new and recent. In this blog I go into the details how to connect SAP HANA with GeoServer.

Friday 14 June 2019

BW/4 HANA – Virtual Master Data Through SDA

With increasing demand of multi sourced data reporting, flexibility & agility, SAP offers an one stop solution with BW/4 HANA.

SAP S/4HANA provides operational reporting for current data from a single SAP application. SAP BW/4HANA delivers a modern data-warehousing environment that allows reporting on data from SAP and Non-SAP Applications. BW/4 HANA which is available only in SAP HANA platform is optimised for SAP HANA.