Friday, 22 June 2018

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


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


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


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


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


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)


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


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


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


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


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


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.