Thursday 31 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.

Saturday 26 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.

Thursday 24 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.

Tuesday 15 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.