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.

Wednesday, 12 June 2019

Implementing Dynamic Join To Showcase Measure Based On Different Attribute In a Single HANA View

Introduction


There are different types of joins available in the database. SAP HANA offers all of these joins.

The different types of joins in SAP HANA

Monday, 10 June 2019

SAP Native HANA best practices and guidelines for significant performance

Just putting up and writing down all the consolidated best practices and guidelines including tips for SAP HANA modeling (Majorly for version 2.0 SPS 02)

Top 10 reasons to choose SAP HANA


SAP HANA layered architecture (Great to have) and naming conventions

Friday, 7 June 2019

Lightweight eclipse for HANA studio ( + streaming, SDI SDK)

The web based tools for the SAP HANA platform are ever improving, but sometimes the HANA studio remains the easiest way to get things done.

The HANA studio is a bit heavy and unstable, so here’s a few advice to get the capabilities in a more lightweight and robust fashion. You will need internet connectivity to do the install.

Wednesday, 5 June 2019

Import/Export Catalog Objects with Dependencies for Multi-TenantDB in SAP HANA 2.0 SPS04

Introduction


In this blog post you will learn how to import/export catalog objects with dependencies for Multi-TenantDB in SAP HANA 2.0 SPS 04. IMPORT/EXPORT in SAP HANA Database is a useful feature. It is often used to transfer the data between different SAP HANA Databases for different purpose. In most of the cases, you may need to use Cross DB Access based on your business requirements. Let’s assume there are two different tenants, one is DB1 and the other is DB2. And a calculation view (ZCV_REVENUE) in DB1 is referencing many table and views in DB2. In this situation, if customers export ZCV_REVENUE with dependencies, only ZCV_REVENUE is exported, the referenced objects in tenant DB2 has to be exported manually one by one.

Monday, 3 June 2019

Principal Propagation between HTML5- or Java-based applications and SAP HANA XS on SAP HANA Cloud Platform

Introduction


Although there is no standardized definition of the term “Principal Propagation”, it is commonly understood as the ability of a system to securely forward or propagate the authenticated user (principal) from a sender to a receiver in a way that the forwarded user information is kept confidential and – even more important – cannot be changed during transit. Based on a pre-established trust relationship to the sender, the receiver uses this information to logon the user without asking her again for the credentials.

Saturday, 1 June 2019

SAP S/4HANA Cloud and S/4HANA On-premise Quality Management Features

In this blog S/4HANA Cloud and S/4HANA On-premise Quality Management features will be presented. Both applications improve its features and continue to meet customer requirements. Quality management process is the key driver from the product development stage until product discontinuation phase.