HANA Input Parameters with texts

Introduction

On one hand HANA Variables are easy to use and, mostly, perform well on well-modeled HANA views. There are always exceptions with big tables where join happens at a very granular level, then it is smarter to use Input Parameters, mapped through nested layers of HANA views instead of just a Variable in the topmost one. Performance-wise you can achieve a saving of 20-50% (personal observations), but then it comes a little tricky with introducing both keys and texts in Value Help.

An example:

• You have a basic view joining the tables BSEG & BKPF
• This basic view is used in Reporting view

Basic view

HANA Live implementation (sidecar scenario)

In this “how-to” post I am aiming to cover additional parts that arise while using HANA Live models in a sidecar scenario to your main (mature) SAP installation on a different DB. This blog post is of lesser interest for those cases, where an existing ECC / CRM system is migrated to HANA DB due to the fact that required tables are readily available under SAP_ECC / SAP_CRM schema. All you need to do is – install the HANA Live content and start using / modifying it.

Just a short recap, the scenario I am trying to cover here is the least-risk (and, possibly, cost) approach to leverage advantages of HANA with minor changes to existing ECC/CRM landscape, when an additional HANA instance is connected to the “main” system, running on traditional relational database. It may be an own HANA box, or any of the cloud solutions on the market.

HANA CatEye! Experimental Project with NodeJS + MongoDB + RaspberryPI3

In my previous article,, I have explained BPC on HANA by using HANA objects and their advantages. This time i want to write about NodeJS which is going to be the primary Javascript runtime in HANA XS with SAP HANA SP11. Also I have developed a simple application by using NodeJS named as HANA CatEye.

BPC on HANA by using HANA Objects Part I

 BPC on HANA by using HANA Objects:

Our approach has two main advantages.

1. Overall significant decrease on development time
2. Huge performance increase

           The initial phase of the project was implemented in traditional way which was developing the business logic through optimizing the ABAP codes and parallel processes to maximize the performance and decrease the runtime process of packages. The runtime process was taking too much time due to huge amount of data.

Expose CDS Views as OData Service

In continuation to previous blog Core Data Services in ABAP in this blog I will show how to create CDS Views and step by step procedure to generate OData service using CDS Views.

There are 3 different ways you can expose CDS views as OData service:

1. Import DDIC structure using SEGW Netweaver Gateway service builder transaction.
2. Reference Data Source using SEGW Netweaver Gateway service builder transaction.
3. Using Generic Annotations. (@Odata.publish:true) 

First way is supported from SAP ABAP NW 7.40 SP5, Second and third ways are supported from SAP ABAP NW 7.50 and above. For first two ways SAP NW Gateway is used and for third type without use of SAP NW Gateway odata services can be created using annotations. Gateway is used only to add the service created using annotations.

In this blog I am going to show type one i.e how to generate OData service using import DDIC structure using SEGW service builder transaction.

SAP S/4HANA from a Developers Point of View - Part One

Introduction
In my first part I try to explain what is the main difference between R/3, SAP ERP and S/4.

As you can see from the picture above R/3 was upgraded, extended and renamed to eventually SAP ERP. With upgrades from R/3 to the next version SAP mostly added/enhanced functionality and mostly kept all other functionalities as before. This allowed custom ABAP programs to continue to run with no or may be small adjustments.

SAP HANA Multitenancy Multi-tenant Database encryption with change of encryption root key for SYSTEMDB

Why This Blog:

In this case, the high level security measure is to enable Data Volume Encryption on the Hana system.

This is the first time I have enabled Data Volume Encryption with a Hana Multitenant Database.

After we have executed steps described in SAP HANA Administration guide, for enabling Data Volume Encryption, the alert '57' was raised in our SYSTEMDB reporting "Inconsistent SSFS". At this point our tenant DB was working without issues including backup. For system DB we were experiencing all symptoms reported by SAP Note 2097613.

Parallelization options with the SAP HANA and R-Integration

Why is parallelization relevant?

The R-Integration with SAP HANA aims at leveraging R’s rich set of powerful statistical, data mining capabilities, as well as its fast, high-level and built-in convenience operations for data manipulation (eg. Matrix multiplication, data sub setting etc.) in the context of a SAP HANA-based application. To benefit from the power of R, the R-integration framework requires a setup with two separate hosts for SAP HANA and the R/Rserve environment. A brief summary of how R processing from a SAP HANA application works is described in the following:

• SAP HANA triggers the creation of a dedicated R-process on the R-host machine, then
• R-code plus data (accessible from SAP HANA) are transferred via TCP/IP to the spawned R-process.
• Some computational tasks take place within the R-process, and
• the results are sent back from R to SAP HANA for consumption and further processing.

Tableau and HANA

Introduction

Tableau is an easy to use visualization tool that allows you to connect to various types of data sources, visualize and create interactive dashboards and story points.

Connecting HANA and Tableau

After reading Ronald's blog, I thought connecting Tableau to HANA is very easy but when I tried to connect Tableau to HANA using Native Connector, I got the below error

Remember these points for Migration SAP ECC On Hana!

Seven points for success.

After a lot of good and bad experiences during Migration to SAP ECC ON HANA, it was possible make a list with very important points.
These points refer to SAP HANA Version, EHP Version, O.F. (Kernel, Library, File system and etc), Appliance and other information that are ommited on Guides, Notes and Sites.

Let's go to the list:

01 - Human Resources.

• Is Your Team prepared for these challenges?
• Does  Your Team or Partner have all the necessary knowledge?

Answer: Check all information about the skill, cases and past experiences, "Hana and Oracle SAP is not the same thing". You will be told most of times that they are.