Friday, 17 August 2018

Develop, Deploy & Debug a Hana Node.js app (xsjs) using Hana DBaaS on cloud foundry.

This blog will cover 4 steps in end to end development and deployment of the app to cf.

1. Create the Hana database using the Hana Service (DBaaS) on cloud foundry (CF)
2. Configure Web IDE Full stack to work with cloud foundry.
3. Deploy the App on CF.
4. Debugging using webide fullstack.

Wednesday, 15 August 2018

Developing Speech Interface for XSA Web Applications using Python

In this blog, I am going to talk about how to build conversational interfaces in XSA applications by integrating speech-to-text and text-to-speech APIs. I am also going to briefly cover how web sockets work in python for XSA applications. For those that are not familiar, web sockets are used for live bi-directional communication between clients and a server. Numerous clients can be connected to the same server through which they receive live updates as events. They do not need to make explicit HTTP calls to check for status updates. In addition, the Server can also initiate communication with the client and send updates as opposed to simple HTTP where a client must always initiate communication often leading to polling interfaces.

Monday, 13 August 2018

Example Optimize Join Columns

In this example we will demonstrate how the usage of option Optimize Join Columns influences query processing. The example makes use of two tables.

Friday, 10 August 2018

Examples Using Input Parameters with Calculation Views

Input parameters provide a means to influence query execution with values that are entered at runtime by the end user. In contrast to variables, input parameters can be mapped between different views so that an input parameter from one view is filled with values of the mapped input parameter of another view. In addition, it can be controlled at what node the input parameters are processed which provides precise control about the semantics of the input parameter. While variables are evaluated using the normal WHERE-filter Syntax, input parameters offer more options and have an own syntax. We will demonstrate this syntax of input parameters with different examples in this blog.

Wednesday, 8 August 2018

SAP HANA 2.0 Cockpit Installation and Configuration How to Guide

In this blog, I would like to provide a step-by-step procedure to install and configure new SAP HANA 2.0 Cockpit to monitor and maintain multiple SAP HANA databases.  SAP HANA 2.0 Cockpit is a native web based centralized HANA administrator tool used to perform all database management and monitoring of multiple SAP HANA 2.0 and SAP HANA 1.0 SPS 12 databases.

Monday, 6 August 2018

India Geo Model from HANA live with SAP Analytics Cloud

Hence, I tried a quick POC to represent India data on geo map from HANA live. This was further enhanced to actually include drill up/down capabilities on the states. I thought it would be useful for many India customers who intends to achieve similar usecases.

Friday, 3 August 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 6

In this Part of blog we are going to install SAP S/4HANA Frontend server.

◈ Installation of SAP S/4HANA IDES Frontend Server


1. Follow from Step 1 to Step 7 in the Part 5 of this blog.

Wednesday, 1 August 2018

Working with HANA spatial data in Javascript

Over the years, I’ve done a fair amount of technical proof-of-concept applications, most of them on HANA or the SAP cloud platform. All of these have been written up into step-by-step “how-to’s”, but precious few of them have found their way here, to the public realm.

Monday, 30 July 2018

Use Case to S/4HANA Smart Data Integration (SDI)

Every new technology or platform is developed as a need to address the challenges faced by older technologies, cater to the unmet needs of the consumer or to facilitate a change by making the processes easier and/or economical. Smart Data integration is no exception.

Friday, 27 July 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 5

In this Part of blog we are going to install SAP S/4HANA Application server.

◈ Installation of SAP S/4HANA IDES Application Server


1. Open Terminal and use cd /HANAIDESSetup/SAP_Software_Provisioning_Manager/ command to go to SAP Software Provisioning Manager Directory (Figure 5.1)

Wednesday, 25 July 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 4

In this Part of blog we are going to install SAP HANA Database

Install SAP HANA Database

1. Open Terminal

2. Go to HDB_SERVER_LINUX_X86_64 Directory using cd /HANAIDESSetup/SAP_HANA_Platform_Edition_2.0_SPS03_rev30/51053061/DATA_UNITS/HDB_SERVER_LINUX_X86_64/ command (Figure 4.1)

Monday, 23 July 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 3

In this part of blog we create the partition of disks /dev/sdc and /dev/sdd, create directories for both HANA Database and HANA IDES Setup files, mounting both directories to relevant disk is also part of this blog, finally we extract and copy the setup file to the HANA IDES setup directory.

Friday, 20 July 2018

HANA Procedure performer XS JS Project

In this post I want to share the way how to call HANA Procedures via XS JS. This is not a how-to guidepost, I want to share the end functionality that we use in our work. This approach might be very convenient in integration projects when the data extraction rules can be changed during the UAT, so you won’t need to change anything in your integration solutions you just need to apply this requirements in your procedures and change will be committed on the fly.

Wednesday, 18 July 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 2

In this part of SAP IDES S/4HANA installation we will install SUSE Linux in the Virtual Machine which we created in the Part 1 of this blog.

◈ Install SUSE Linux Enterprise for SAP Applications in the Virtual Machine

1. Select S4HANA IDES Virtual Machine from the left panel of VMware vSphere Web Client and click the Power on the selected virtual machine icon  SAP HANA Study Materials, SAP S/4HANA, SAP IDES S/4HANA, SAP HANA Certifications (Figure 2.1)

Monday, 16 July 2018

SAP WebIDE for HANA 1.0 SPS 12

SAP WebIDE for HANA 1.0 SPS 12


SAP Web IDE for SAP HANA is a browser-based IDE for the development of SAP HANA-based applications comprised of web-based or mobile UIs, business logic, and extensive SAP HANA data models.

Friday, 13 July 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 1

In this first part of SAP S/4HANA 1610 IDES installation we download all the required files for installation and create a virtual machine in VMware vCenter Server.

◈ Download all Required Files for Installation

For installation of SAP IDES S/4HANA, we have to download ISO file for installing SUSE Linux from SUSE Downloads and SAP installation files from SAP Software Downloads.

Monday, 9 July 2018

Hana Hadoop Integration with Federated Access

Data Lake analytics have become real. But the challenge is to access the data quickly and provide meaningful insights. There are several techniques to access the data faster. In this blog we see how we can integrate Hana with Hadoop to get insights for larger data sets quickly.

If you have both Hana & Hadoop in your eco-system. SAP has provided an option to integrate HANA and Hadoop using Hana Spark controller. Where power of In-Memory processing can be used for real time insights and we can in parallel use Hadoop ability to process huge data sets.

Friday, 6 July 2018

Accessing Data using REST APIs with Python on XSA

My previous blogs have been focused on setting up Python on HANA XSA, connecting applications to HANA Databases, and configuring security and routing settings for applications. In this blog, I am going to delve deeper into accessing a HANA Database within a Python application and creating REST APIs to query data.

Wednesday, 4 July 2018

How to Expose a HANA Table via oData

With IOT gaining traction and SAP’s HANA DB as well as applications becoming warehousing tools, we’re seeing a greater need to integrate IOT data into HANA. One method of achieving this is by allowing sensor data from IOT devices to publish or post data directly into HANA database tables. Once data is in HANA, additional data modelling can be carried out and formatted data exposed for end user consumption to front end tools such as SAP Analytics Cloud or Business Objects.

Monday, 2 July 2018

Myth and truth about cluster & pool tables on HANA

In general nearly everyone knows that with new installations based on NW750 there are no cluster tables anymore. When you migrate to HANA one prerequisite is that all cluster and pool tables have to be declustered/depooled.

But is this really correct? In my last projects there were a lot of issues regarding cluster and pool tables. SUM and SWPM have not worked as expected and so some data was not migrated / depooled / declustered automatically in cause of bugs.

Friday, 29 June 2018

Provisioning data from web services with custom adapter using SAP HANA SDI SDK

We’ve encountered several situations recently where it was required to acquire information from external systems that already had an API to expose data with web services.

The usual way would be writting a script or using an ETL, but those options had some disadvantages:

Wednesday, 27 June 2018

Inventory Management in SAP BW/4HANA

INTRODUCTION


The loading process of Inventory Management data in BW/4HANA is different than that in the predecessor versions (BW 7.4 and below). This blog will attempt to explain how to load Inventory Management data in BW/4HANA, and also how the data is saved in the BW database tables.

Sunday, 24 June 2018

Introducing the NDSO: Part Three – Integrating a NDSO with SAP BW/4HANA

Motivation


As already mentioned in the first blog. SAP supports the application driven approach and the native, SQL driven approach to Enterprise Data Warehousing and offers corresponding applications and tools in its portfolio. Especially for customers using SAP BW/4HANA there is of course always the option to implement parts of certain scenarios natively on the SAP HANA database and use capabilities the SAP HANA platform provides in the context of EDW. In those ‘mixed scenarios’ integration is key so – here we go with blog three and take a closer look on how to integrate the NDSO (and its data) in mixed scenarios with SAP BW/4HANA.

Tuesday, 19 June 2018

Setting Up App Router for HANA XSA with Python

In my previous posts, I have covered details on getting started with Python development on XSA. I am going to continue this series forward and now talk about setting up a central application router for your applications. Again, I am using the same pyapp project in this blog post as i did in the previous ones.

Monday, 18 June 2018

Getting Started with Python on SAP HANA XSA

Currently, XSA only distributes a build pack for Python while the runtime needs to be installed manually by the developer. This is different from Node.js and Java for which XSA provides runtime as well. Similarly, the SAP Web IDE for SAP HANA, the main development IDE for XSA, only supports Java and Node.js development. All Python development needs to be done and deployed through command line interface (CLI).

Friday, 15 June 2018

S/4 HANA Cloud – Adding a Custom field to Web GUI for HTML

This blog will provide you the information about, how to add a custom field to Web GUI for HTML and access it in the assigned business context.

The below procedure steps you need to follow in S/4 HANA on Cloud Version.

To open the app, select the Custom Fields and Logic tile as shown in below snap shot.

Wednesday, 13 June 2018

How to implement Function Import in HANA XS

It is all about a feature that I found missing in HANA XSODATA — support for OData Function Imports.  While this feature can be implemented in a custom way through XSJS, I would like to have this custom implementation compliant with OData V2 specification in order for the consumer application (which is SAPUI5) to be able to leverage the existing ODataModel V2 library.  This is my journey for achieving this requirement — by creating a custom function import utility through XSJS.

Monday, 11 June 2018

How To Get SAP ERP Data Into HANA

The key element we need to explore in order to see how we can migrate ERP data into HANA is a built-in feature of the SAP system called Smart Data Integration. Smart Data Integration is a feature of HANA that administrators can use to transfer data into the SAP install with relative ease. The details of the procedure may require some basic explanation, but the process itself is as simple as we can find in any sort of system as complex as SAP.

Friday, 8 June 2018

How to create FlowGraphs in HANA Web IDE with SDI connection

In this Blog, I am going to show “How to” create a Flowgraphs in HANA Web IDE with SDI (Smart Data Integration) connection.

SAP HANA flowgraph helps you to transform data from a remote source (SDI) into SAP HANA either in batch or real-time mode. In this case, I am using Hadoop database as remote source and loading the data into HANA Database tables.

Wednesday, 6 June 2018

Migration Guide: Moving to Version 2.0.0 of the SAP S/4HANA Cloud SDK

With the release of version 2.0.0 of the SAP S/4HANA Cloud SDK, along with dropping support for Java 7, we were able to incorporate several improvements and add some great new features to the Java libraries of the SDK based on your feedback! Along with the modernization of the technology stack, we took the chance to clean up our code base and remove obsolete and unwanted functionality that – in a few cases – required breaking changes to our API.

Monday, 4 June 2018

Deploy HANA Express database on Google Kubernetes cluster

This post will guide you through the creation and configuration of a Kubernetes cluster on Google Kubernetes Engine (GKE). You will then learn how to connect to SAP HANA, express edition running on the pods. The configurations provided here should also work on other Kubernetes orchestrators such as Azure Kubernetes Service or Amazon EKS.

Wednesday, 30 May 2018

Integration of External Data Structures with Open ODS Views

Integration of External Data Structures with Open ODS Views:

◈ Modelling options with Open ODS Views.
◈ Consuming external data in SAP BW.
◈ Combining external data with data in SAP BW.

Monday, 28 May 2018

SAP HANA and R hands-on: From freestyle to deployment

Learn how to script R in your preferred editor with SAP HANA data and how to deploy the code directly in SAP HANA.

If you are a Data Scientist, there is a good chance that you enjoy working with R. You can bring in your creativity, choose from thousands of R packages and script some very agile data analysis and predictions.

Friday, 25 May 2018

The SAP HANA JSON Document Store – Introduction Part-1

Overview


The SAP HANA JSON Document Store (also known as DocStore or Document Store) is a new feature which has been introduced with SAP HANA 2.0 SPS 01. The new store combines a relational and document-oriented database to a hybrid innovative technology which is unique for a variety of reasons, namely, its ACID compliant, fully integrated with SAP HANA in terms of access/query and administrative capabilities.

Wednesday, 23 May 2018

A short overview of What’s New for the SAP HANA Performance Management Tools in SAP HANA 2.0 SPS03

SAP HANA capture and replay


Testing database workload is still a large effort for administrators, testers, developers and consultants alike when looking to upgrading from one release to another. Especially when it comes at larger scale scenarios, the amount of work can grow exponentially.

Monday, 21 May 2018

Use JDBC to connect to HANA database instance in SAP Cloud Platform

This blog is divided into two parts.

Part 1

1. Introduce how to create a HANA database instance in SAP Cloud Platform (called SCP for short in the remaining part of this blog)

Friday, 18 May 2018

Setup S/4HANA 1610 IDES On-Premise – Part II

As we successfully completed OS Setup and HANA DB Install in Part I, we will further see the installation steps to build S/4HANA ABAP Instance.

Wednesday, 16 May 2018

Setup S/4HANA 1610 IDES On-Premise – Part I

We installed our first SAP S/4HANA systems – IDES S/4HANA 1610 in premise. To setup this environment we purchased 2 Servers of following configuration.

Monday, 14 May 2018

SAP Fiori App on HANA XS/SAP Cloud Platform/Mobile Devices, Consuming SAP Business One HANA Service Layer

Objective


Utilize SAP tools to ease development efforts in packaging & deploying SAP UI5 Applications on Mobile/SAP Cloud Platform/Hana Platform.

Show a very simple Loosely-Coupled end-to-end Hybrid App solution utilizing SAP Business One Service Layer

Friday, 11 May 2018

HANA Partitioning – 2 billion rows limitation – Part I: BWoH / BW/4HANA

Some of you may already know the limitation of 2 billion entries in a single table / partition.
Another hint regarding this limitation is the alert ID 17 ‘<table> contains xxx records’. The default threshold of this alert is 300,000,000 rows. This limitation applies to BSoH / S/4HANA and BWoH / BW/4HANA => general HANA limitation. But both have its own distribution rules. So I will split this blog into two parts BWoH and BSoH.

Wednesday, 9 May 2018

Generating and Deploying HANA CDS Wrapper Views

Overview of Data Replication in S/4HANA Cloud


In the S/4HANA Cloud environment, data can be replicated with these three options:

◈ Whitelisted APIs
◈ Legacy APIs
◈ Data Models

Monday, 7 May 2018

HANA SLT(System Landscape Transformation) Archived Files(SARA) Replication to HANA

In this blog we are going to discuss how to replicate the data which had been archived on source systems through SARA files.

In every project based on agreement we will go for archiving either it will be to keep only last 12 months data or last 24 months based on business agreement.

Sunday, 6 May 2018

Make your HANA Express impersonate Cloud Foundry

When I help partners set up their HANA Express servers for development use, I want to configure them to impersonate the behavior of Cloud Foundry so that they get used to how the XSA generated URLs work.  This approach also tends to promote a more deployment target agnostic behavior and leads to projects that deploy into both HANA XSA on-prem and Cloud Foundry environments without any code differences.

Friday, 4 May 2018

HANA Spatial Demos: Geocoding, Clustering, Aggregation

Business story


Let’s imagine a purely fictional story to back-up our applications:

◈ Our customer is an insurance company specialised in house insurance.
◈ Currently, they have all their data in Excel files.
◈ They want to move it into a dedicated system capable of grouping houses in the same area together.

Sunday, 29 April 2018

Exploring the SAP HANA XS Advanced Secure Store functionality with NodeJS

Introduction


Recently a question was raised here in the community how the secure store functionality can be used in a XS Advanced application without using the $.security.Store API available via the XSJS compatibility layer. Until HANA 2.0 SPS02 there was no official information available although the functionality was already part of the system, but not officially released, at least to my knowledge. With HANA 2.0 SPS03 in the SAP HANA Developer Guide for XS Advanced the Application Security chapter was enhanced by a new sub-chapter Maintain Values in the SAP HANA Secure Store which adds the information that the secure store can be used by new procedures:

Wednesday, 25 April 2018

SAP HANA 2.0 SPS 03 Installation – Preparation for HANA Migration using DMO

A lot of SAP customers have been migrating their existing SAP landscapes from traditional database platforms to SAP HANA. OS/DB migration using SAPinst (SWPM) has been in place since long, however the migration to SAP HANA database requires certain minimum SAP release/SPS level as a prerequisite for the existing SAP systems in the customer landscape.

Saturday, 21 April 2018

How To Integrate Hana Database with Excel

Connecting to SAP HANA with Microsoft Excel


Microsoft excel is most widely used BI tool across the globe, with excel we can explore well versed SAP Hana data.SAP HANA supports the query languages SQL and MDX where as JDBC and ODBC are used for SQL-based access. ODBO is used for MDX-based access. MDX (Multi-Dimensional Expressions) is a query language for OLAP databases. It has been defined as part
of the ODBO (OLE DB for OLAP) specification from Microsoft.

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

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.