Friday, 20 April 2018

Angular 2 on HANA XSA

From the day I heard SAP HANA will support Node.js, I was curious to experiment what all we can develop on HANA using the new platform. Just few days before I was able to run Angular 2 apps on HANA XSA and thought of sharing the same. So lets start with the prerequisites.

Wednesday, 18 April 2018

Analysis of Memory Management & Host/Resource Utilization Statistics in BW ON HANA and above

Many a times users of SAP face performance issue on the system which in turn impact their daily tasks and business. One of the common cause behind such performance issues can be less efficient memory management analysis or improper load distribution which leads to high host/resource utilization. I am going to write series of blog on this issue and will share with you.

Monday, 16 April 2018

SAP HANA 2.0 SPS 03: New Developer Features; Database Development

In this blog, I would like to introduce you to the new features for the database developer in SAP HANA 2.0 SPS 03.   We will focus on the database development topic including Core Data Services, as well as SQLScript.

Friday, 13 April 2018

S/4HANA Cloud Integration | Commercial Project Part 2

Introduction


Consume S/4HANA Cloud APIs indirectly via SAP Cloud Platform Integration

In this blog we will focus on indirect S/4HANA Cloud API consumption via SAP Cloud Platform Integration (in this blog referred to as CPI).

Wednesday, 11 April 2018

S/4HANA Cloud Integration | Commercial Project Part 1

Introduction


In a professional services project you might use S/4HANA Cloud in combination with other solutions to apply the relevant business processes for professional services such as opportunity to cash. Scenario could be that project opportunities are managed in another solution, once the opportunity gets realized and priced, a project in S/4HANA Cloud will be created.

Monday, 9 April 2018

Create Resource Group and Resources in SAP HANA Cockpit 2.0 SP 06

As we are aware that SAP HANA Cockpit is the new web based HANA administration tool to monitor and manage HANA 2.0 databases, recently we installed the latest release SAP HANA Cockpit 2.0 SP 06 patch 04 for a client so as to monitor the BW/BPC HANA landscape.

Sunday, 8 April 2018

General Availability of SAP HANA XS Advanced Cockpit

The new release of SAP HANA 2.0 SPS03 is around the corner and we are excited to explain our new features. In this blog, we are specifically going to look into SAP HANA XS Advanced Cockpit. This will replace the old SAP HANA XS Advanced Administration Tools, which is announced as “Deprecated” in this release. We will refer to SAP HANA XS Advanced Cockpit as XSA Cockpit and SAP HANA XS Advanced Administration Tools as XSA Admin Tools in this blog. One of the major reasons for us to move to XSA Cockpit is to provide users a consistent, unifying user experience in cloud and on-premise. The XSA Cockpit includes all functionalities of the XSA Admin Tools and it also provides a lot of additional capabilities. The UX and design of the XSA Cockpit is very similar to the SAP Cloud Platform Cockpit to provide users a seamless experience in the cloud and on premise.

Friday, 6 April 2018

Managing large SAP BW on HANA systems: SAP HANA Enterprise Cloud (HEC) perspective

As a cloud architecture and advisory member, I frequently come across several customer cases related to existing SAP Business Warehouse(BW) systems. Large customers usually have large data footprint (often in several terabytes) and a variety of data source systems. Additionally, several reporting/analytic tools are connected to existing SAP BW systems.

Wednesday, 4 April 2018

SAP Hana 2.0 hybrid Landscape Management with LaMa 3.0 & Solution Manager 7.2 Part-2

Configure Microsoft Azure connector for SAP LaMa


The Azure connector for SAP LaMa will allow me to perform several operations directly onto Azure such as activate or power off VMs, do SAP system relocate or perform SAP system copy/clone.
However, not all Azure resources are supported, only VMs deployed by ARM with managed disks are supported, VMs deployed in availability zone are currently not supported.

Monday, 2 April 2018

SAP Hana 2.0 hybrid Landscape Management with LaMa 3.0 & Solution Manager 7.2 Part-1

I will explain and detail how to manage SAP Hana 2.0 SP2 instance with SAP LaMa 3.0 SP5 in the context of hybrid landscape between on-premise and Microsoft Azure.

In order to monitor my hybrid solution i will explain how to configure Solution Manager 7.2 accordingly.

Friday, 30 March 2018

Technical details about data aging Part II

To understand the data aging in detail we will go a little bit deeper in this part of the blog series.

As example we will use table CDPOS. Data aging is in use and aging runs already were executed. As result we get this data distribution.

Wednesday, 28 March 2018

Business Partner in S4 HANA – Customer Vendor Integration

It’s been almost 2 years I have started my journey in SAP world. I started with Technical domain for some time and I landed in Functional domain SAP SD (Sales and Distribution).

I must say that even after learning and practising it’s still feels like there is lot to learn. My office colleagues helping me a lot to learn things every day.

It always exciting whenever you come across new technology.

Monday, 26 March 2018

Your SAP on Azure: SAP HANA Express on Azure Kubernetes Cluster (AKS)

Using a docker image to install SAP HANA express edition can shorten the deployment time and ensure the consistency between environments. The easy way to use it is to build a Kubernetes cluster using Microsoft Azure Container Service and deploy containers in the cloud.

A docker container is a package of libraries and system settings required to run an application. It allows to save the time needed to provide a working environment and you can focus on the target database configuration. It’s great especially in environments where you need to provide separated HANA instances for many developers.

Friday, 23 March 2018

S/4HANA – What to do about Planning and Consolidation – The Options

As organisations continue to convert their SAP ERP systems to S/4HANA, one area that pops up as a roadmap item is how to handle requirements for Planning and Financial Consolidation.

In some cases, this provides an opportunity to simplify the landscape and in others prompts a review of what organisations require from a planning solution and what they require from a financial consolidation tool. These discussions are made more confusing for SAP customers, because SAP provide a number of different solutions that cover the topics of planning and consolidation, and at first glance it can be difficult to understand which should be used.

Wednesday, 21 March 2018

Mircosoft Dynamics 365 CRM adapter for SAP SDI

1. Overview


The Advantco Dynamics 365 adapter is an adapter for SAP HANA Smart Data Integration (SDI), its purpose is to batch load or to replicate changed data in real time from  Dynamics 365 CRM to the SAP HANA tables.

Monday, 19 March 2018

S/4 Embedded Analytics – The Virtual Data Model

In this post, I will discuss the architecture of building a virtual data model (VDM) in S/4 HANA, using CDS Views (Core Data Services).

With the availability of the SAP HANA platform there has been a paradigm shift in the way business applications are developed at SAP. The rule-of-thumb is: Do as much as you can in the database to get the best performance.

Friday, 16 March 2018

Custom Rule Set – SAP HANA Text Search

In this blog, I’ll discuss how to create custom rule set in SAP HANA.  To implement certain custom use cases, customers have to implement their own rule set for performing Text Search Operations.

Search Rule Set


Figure 1 below shows the structure of Rule Sets stored in XML/Tree Like Formation.

Wednesday, 14 March 2018

Connect a SQL client to HANA Express on Google Kubernetes Engine

I showed how to setup a Kubernetes cluster with three HXE containers running in single pods. As I continue to explore different possibilities with my new favorite toy, I thought I could document some extra steps to connect from an external, local SQL client.

Monday, 12 March 2018

Setting up communication channel between SAP Cloud Platform (Neo) & HANA XSA (On-Premise)

Overview


Recently, I came across a situation where I had to consume an OData service that’s deployed in HANA 2.0 on-premise following XSA paradigm in a SAPUI5 application running in SAP Cloud Platform – Neo environment. In this blog, I’d like to take through the concepts and the various configuration steps that are involved in setting up communication channel between an application deployed in SCP to and HANA XSA on-premise. I’ll also describe in detail the security configuration to allow a user logged in SCP HTML5 application to access a protected resource in HANA XSA, for example an OData service that requires specific scope to access.

Friday, 9 March 2018

Upgrading Web IDE in HANA Express

One of the housekeeping tasks I generally perform in the instances I use to develop actual applications is to upgrade the Web IDE. Not only because some minor bugs are swept away, but also because there’s always some additional functionality that makes development easier.

You would generally need access to the marketplace and a proper license for this. However, the engineering team has made this patch available for download in the download manager in revision 23. If the following rings a bell, you might want to give this a try:

Wednesday, 7 March 2018

How to free Hana System on Public Cloud from I/O performance issue?

How to free Hana System on Public Cloud from I/O performance issue?


Apart from memory, storage performance plays a major role in safeguarding HANA performance. Storage system used for SAP HANA in TDI environments must full fill a certain set of KPIs for minimum data throughput and maximum latency time for Hana data and log volume. Cloud vendor need to pass the KPI checked using HWCCT (Hardware Configuration Check Tool) for SAP to certify their cloud platform to run SAP HANA. The reason is to safeguard customer HANA system from any possible I/O performance that’ll lead to performance degradation up to system standstill and irresponsive.

Sunday, 4 March 2018

Table redistribution and repartitioning in a BW on HANA system

In this blog, I am providing step by step details about how to perform table redistribution and repartitioning in a BW on HANA system. Several steps described in this document are specific only to a BW on HANA system.

Wednesday, 28 February 2018

SAP HANA Text Mining Functions – Part 2

In this blog, we’ll discuss remaining Text Mining Functions.  Functions available to find top ranked related and relevant documents and terms.

Document Classification or Categorization

One of the category of Text Mining function is Document classification or categorization. SQL Function in HANA for performing this operation is TM_CATEGORIZE_KNN.

Monday, 26 February 2018

Compute Distance using a Calculation View – XS Advanced Model

We’re going to learn how to create a Graphical Calculation View to calculate the distance between two locations or coordinates represented by a longitude and a latitude. We assume that some of these locations or coordinates are already known and the other is an input from the user.

This is achieved by using the HANA spatial capabilities. HANA support three spatial reference systems (SRS) by default. For this blog we will use the WGS84 – SRID 4326 SRS because HANA supports it and the coordinates used are based off Google Maps.

Friday, 23 February 2018

Use Excel to query and analyze HANA data

Background


For decades, Microsoft Excel remains as the tool of choice to many users for data analysis. Even In the modern BI era, the “Export to Excel” is a must-have feature to many BI tools. In HANA world, we could hear the question from time to time inquiring how to connect Excel to HANA. This blog aims at introducing a new way, which is also completely free, to connect Excel to HANA. It overcomes the limitations of existing methods, and can be a great companion to HDBStudio to improve the interactive HANA data query and analysis through Excel.

Wednesday, 21 February 2018

SAP HANA Text Mining Functions – Part 1

In this blog, we’ll discuss Text Mining Functions.  Functions available to find top ranked related and relevant documents and terms.

Figure 1 shows the permutations and combinations available for doing Text Mining.

Monday, 19 February 2018

End to End Development – SAP HANA and Web IDE

In this blog, we cover end to end application development starting from creating a database table in SAP HANA, develop virtual data models on top of database tables and finally use Smart templates available in Web IDE to create a Fiori Application consuming virtual data models.

Smart templates, also known as SAP Fiori Elements, provide a framework for generating UIs at runtime based on metadata annotations and predefined templates for the most-used application patterns.

Friday, 16 February 2018

Installing SAP HANA database using self service on SAP Cloud Platform

A new capability was released on SAP Cloud Platform to allow customers to perform installation of SAP HANA/ASE database instance in a self-service manner. Prior to this, there was a manual process in place. If a customer has an existing SAP Cloud Platform subscription with several subaccounts and decides to subscribe to a HANA DB, they would have to raise a support ticket requesting the assignment of a HANA DB to a particular subaccount. Behind the scene, the SAP Cloud Platform DevOps team would install the HANA DB and assign it to the requested subaccount.

Wednesday, 14 February 2018

Enterprise applications with optimized costs – SAP HANA-based systems on Hetzner Online

In this article I would like to share my experience  of building our company SAP infrastructure and hardware costs optimization that we  have managed to achieve. Currently we have over 20 internal sap systems in our internal  landscape, including about 15 HANA-based installations. We use a combined approach with Hetzner Online and Amazon web services, and our average monthly expenses  for hardware rental are about EUR 1,000.  In fact, this is not a productive landscape, so most of those tricks  will not work once you have mission-critical systems. However, in many production  scenarios serious costs saving can be achieved, and this is what I am going to describe below.

Monday, 12 February 2018

HANA 2.0 SP1 on SUSE 12 SP02

This time I will show you how to install SAP HANA 2.0 SP01 with latest patch on SUSE 12 SP02. I am not using Redhat because they refused to give me a trial with SAP repositories, so SUSE for the win.

Required SAP Notes

1984787 – SUSE LINUX Enterprise Server 12: Installation notes

2205917 – SAP HANA DB: Recommended OS settings for SLES 12 / SLES for SAP Applications 12

Thursday, 8 February 2018

Execute SQL Statement in HANA Studio using Literals or Bind variables

There are two variants of SQL statement execution defined in SAP note 2000002 – FAQ: SAP HANA SQL Optimization. The difference is how the where condition is specified in SQL Statement.

Sometimes I prefer to call “Literals” as “Hard code”.

Wednesday, 7 February 2018

sqlpad meets SAP HANA

Having already contacted the author of the project, Rick, he was open to the idea of a contribution so a fork in Github later and a few alternations to the codebase and I was ready to proceed. The internal process was pretty quick, took me just a couple of days while a simple form was processed (time zones delay everything!).

Monday, 5 February 2018

Publish Analytical View in Webi in simple steps

This document explains step by step to publish Hana views directly into Webi Rich Client in a simple steps.

Since, We are using BOBJ 4.2, we don’t have to create Universes for deploying our Views & We can directly deploy our HANA views in WEBI

This document will also give basic understanding of the basic development/creation of webi reporting after publishing the Analytical view in Webi

Sunday, 4 February 2018

Migration Cockpit Migration Object Modeler S/4HANA Basics

Introduction:


It is a part of the Migration cockpit which integrates Custom objects or  standard objects not provided in the S/4 Hana Migration Cockpit template.

NOTE: Its available only on On-Premise systems

Friday, 2 February 2018

SAP HANA 2.0 editions (2018) – by the SAP HANA Academy

Introduction


The Feature Scope Description for SAP HANA has been updated for 2018. In this blog, you will find a brief overview of the feature sets with references to SAP HANA Academy tutorial videos and playlists.

Wednesday, 31 January 2018

Establishing the Live HANA on-premise Connection from SAP Analytics Cloud using CORS

The HANA CORS (Cross Origin Resource Sharing) configuration is straight forward but as the old saying goes, a picture paints a thousand words.  Such a shame that the SAP documentation policy is does not allow screenshots.  I have therefore tried to capture the configuration steps here.

SAP Analytics Cloud Version 2018.1.0
SAP HANA Version 1.00.111 (SPS 11).

Monday, 29 January 2018

SAP HANA Express Edition on AWS for XSA development space issues

I launched the SAP HANA, Express Edition on AWS through CAL.

Once it ran, I ran across many issues.

A few things to help out so that I could get start developing:

◈ started nodejstools explicitly.
◈ create a space and explicitly redeployed the builder using the di-space-enablement tool

Sunday, 28 January 2018

SAP S4HANA Business Partner: Same Number Range for BP and Vendor

Since the advent of S/4HANA we have seen a lot of changes/simplifications in the application, one of them being – Business Partner.

Today I would like to talk about a scenario where we need to maintain same number for Business Partner and Vendor.

Friday, 26 January 2018

SAP PI/PO & your 0 issues philosophy (yes is possible): Here just your own Analytics / BI via HANA OLAP / Lumira / Java / Excel or other technology that you decide

I will share a complete solution with the objective to achive the logic that will alow you to make corrective decisions for your solutions implemented or to monitor for preventive symptoms for current interfaces… After we can agree that a lot of companies suffer in their integration processes and don’t know the main reason, but this article will not cover that point here; because i just will share a “logical tool” to let you implement your own technology to monitor and decision making reports.

Wednesday, 24 January 2018

SAP HANA 2.0 XS Advanced Installation – by the SAP HANA Academy

Introduction


Recently, we have updated a number of SAP HANA Academy tutorial videos about installing SAP HANA components:

SAP HANA Installation and Update – SAP HANA 2.0 SPS 02

In this blog, I will provide some references and background information about the SAP HANA XS Advanced (XSA) runtime.

Monday, 22 January 2018

SAP Hana Smart Data Access (SDA) – Basic Configuration

In this post, I have explained step by step configuration of  Smart Data Access for Hana Database with error resolutions.

One of main challenges that companies are facing today are

1. Get information in real time to make quick decision on time

2. At the same time, we need to keep control over cost for IT and Technology.

Sunday, 21 January 2018

Create a value help (for input parameter / variable) in HANA Calculation view

Input parameters and Variables are two diferent mecanism that HANA provide us to get interaction with final users.

In some cases, we need to include an input parameters / Variables with value help with the propose of provide more information when user have to choose an input value.

Friday, 19 January 2018

SAP Analytics Cloud: Live Data Connection to HANA DB in SAP Cloud Platform using SSO

The SAP Cloud Platform (SAPCP) is a platform-as-a-service offering which supports customers’ digital transformation. It does not only provide an environment for the development of new applications but also allows the extension of existing cloud and on-premise systems. SAPCP has evolved as a central component in many enterprise landscapes for integrating data and business processes and for leveraging innovative technologies. By connecting a HANA database which is included in SAPCP with SAP Analytics Cloud (SAC), customers are equipped with advanced analytics and business intelligence features for their enterprise data.

Wednesday, 17 January 2018

Introducing enhancements to SAP HANA capture and replay in SAP HANA 1.0 SPS12 Revision 122.14 and SAP HANA 2.0 SPS02

SAP HANA capture and replay was first made available with the initial release of SAP HANA 1.0 SPS12. Since release, many enhancements have been added to SAP HANA 2.0 and are now also available on SAP HANA 1.0 SPS12 Revision 122.14. While it greatly simplified testing application workload, the testing of data- and system-related changes remains a challenge for many of our customers today, especially in large-scale and complex environments.

Monday, 15 January 2018

Automate SAP HANA System Replication with SLES for SAP Applications

SAP HANA System Replication on SLES for SAP Applications


What is this solution about?

The solution created by SUSE is to automate the takeover in SAP HANA system replication setups.

The basic idea is that only synchronizing the data to the second SAP HANA instance is not enough, as this only solves the problem of having the data shipped to a second instance. To increase the availability you need a cluster solution, which controls the takeover of the second instance as well as providing the service address for the client access to the database.

Friday, 12 January 2018

Installing the Automated Predictive Library (APL) on SAP HANA Express 2.0

The Automated Mode of SAP Predictive Analytics allows the efficient creation of powerful predictive models. Installing the Automated Predictive Library (APL) on SAP HANA makes it possible to train these models directly in SAP HANA. The data does not have to be extracted into an external system, the architecture is simplified and agility is increased.

Wednesday, 10 January 2018

Your SAP on Azure – Part 4 – High Availability for SAP HANA using System Replication

In the today’s post, I would like to present you a solution for protecting the HANA database server.

SAP HANA database offers two solutions that are designed for High Availability:

a) Host Auto-failover – in this solution you need to deploy additional host to the current HANA database and configure it to work in standby mode. In case the active node failures, the standby host can automatically switch operations to the secondary node. This solution requires a shared storage, which we already know is a small problem for Azure

Sunday, 7 January 2018

BW HANA – BI Reporting Performance Benefits

I recently done a review of several client sites that have done a technical upgrade to a HANA DB. This article will cover how to create a BI statistics query for report performance and calculate the report performance benefits of a HANA DB upgrade.

Friday, 5 January 2018

Create a HANA Service binding in Cloud Platform CF

I am a developer in SAP and am working in project using SAP Cloud Platform Cloud Foundry hosted on Amazon Web service infrastructure.

Creating a HANA Service Binding in the global account via Cloud Cockpit :-

Prerequisites:

Wednesday, 3 January 2018

Creating a HANA calculation view for currency conversion providing exchange rates for all days including non-working days like holidays and weekends

There is sometimes a need to calculate the exchange rate for weekends and holidays in business use cases.  Since there is no exchange rate for these dates because they are non-working days, the business usually decides to take the most recent previous exchange rate and apply it to these dates.  For example, since December 30, 2017 is a Saturday, the exchange rate for this date will be the exchange rate for December 29, 2017 (Friday) – the most recent previous working day with an exchange rate.  This blog illustrates how to create a HANA calculation view that will provide the exchange rate from USD to EUR of any date in the period of the last 3 years.

Monday, 1 January 2018

Creating SAP Analytics Cloud Live Connection to SAP HANA Database on SAP Cloud Platform

SAP Analytics Cloud (SAC) has the capability to connect to various types of cloud and on-premise data sources via live and import connections

In this blog post, we focus on connecting from an SAP Analytics Cloud tenant to a cloud data source that is an SAP HANA database on SAP Cloud Platform (SCP) via a live connection.