Monday 31 December 2018

Smart Data Integration: Increase Initial Load Performance for Replication Tasks

This Blog Post aim is to assist you in your daily work using Smart Data Integration and the Replication Task.

In some situations i faced performance issue and i want to use this Blog as a central sweat spot for Best Practices and Lessons learned about performance issues surrounding SDI and the initial Load Replication Task.

Saturday 29 December 2018

HANA Active Active System Replication – Configuration, Failover & Failback

Having worked with an Active-Active Read Enabled (R/E) System Replication scenario we wanted to share our experiences. The official documentation is good but does not provide many diagrams or overall setup, process flows for failover, failback and how the read-only queries can be handled. Working with a long-time colleague Paul Barker. This was used for a short evaluation of the Active-Active with Read Enabled capability.

Wednesday 26 December 2018

How to create XSOData from HANA Calculation Views with input parameters and Navigation properties

We have seen several blogs on how we can easily expose the results of a calculation view as XSOData service.

We can even define navigation properties in the XSOData between the entities. By defining the navigation – we can make use of the existing Smart templates in WebIDE to develop Master Detail kind of UIs.

Monday 24 December 2018

Implementing SLT configuration (for sidecar) in SAP HANA

In this blog I am going to discuss about one of the data provisioning technique in SAP HANA and how to implement it.

There are primary three types of data provisioning techniques in that can be implemented with SAP HANA Database. these are given below –

Thursday 20 December 2018

Implementation of Decision Tables with Return Values in SAP HANA

Introduction to Decision Table

Decision table creates the business rules in a tabular format for automating the business decisions. In this blog, I would like to show a step by step process of creating a simple decision table on HANA and how to execute the same.

Tuesday 18 December 2018

Emergency Access Management (EAM) for HANA Target Systems

Purpose of the Document

In the latest version of GRC 12.0,  SAP has extended the emergency access management (EAM) functionality to HANA database. This blog is to provide the details on how this new functionality can be configured and utilized to manage the firefighting access to HANA target systems.

Friday 14 December 2018

Query Automation on HANA

Business requirement :

When SAP implements SAP Enterprise HANA from other landscape, huge no of SQL query need to be transform to HANA graphical VDM as BI tool like Lumira, Webi design Studio in BOBJ and Tableau. In one scenario similar request (convert SQL to HANA Graphical VDM (Virtual Data Model) raised when the landscape transform to SAP HANA.

Wednesday 12 December 2018

SAP Data Hub and R: Time series forecasting

Read on if you want to know how R syntax can be deployed in SAP Data Hub. I will use time series forecasting to introduce this concept. Think of demand forecasting or sales forecasting, just to give a few examples for how this might be used in a business context.

Generally, you can choose from a number of technologies for time series forecasting. You can select a highly automated approach (ie with SAP Predictive Analytics), you can leverage conventional algorithms inside SAP HANA (Predictive Analytics Library) or you can bring in open source such as R or Python.

Tuesday 11 December 2018

HANA SDI | Smart Data Integration – Batch based Delta Load using Timestamps within a parameterized SDI FlowGraph

1. Introduction

HANA SDI can serve various needs when it comes to data extraction, loading and transformation. In terms of data loading flavors, it supports real-time replication and batch processing, push and pull based.

In this blog entry I would like to outline one option how pull based micro-batching can work with SDI in a simplified use case. The showcase leverages HANA XSC runtime (not state of the art but still applicable out there and therein mostly design time objects. Some material data sets will be loaded in a batch-based manner, using scheduled xs cron jobs, offering some kind of extended options.

Saturday 8 December 2018

How to Generate a HANA CDS Wrapper View

To generate from command prompt, please complete the following:

◈ Download and install the js application.
◈ Open the js command prompt.
◈ Install the dependent packages from the command prompt npm install.
◈ Open the folder hana-cds-wrapper-generator-master/view-generator and execute js.

Thursday 6 December 2018

Refreshing a SAP HANA Database using a database backup


One typical use case managed by SAP Landscape Management is refreshing a system – overwrite the content of an existing target system with actual data from the source system while maintaining system topology and configuration. General SAP Landscape Management functionality allows to manage such an exercise via a “Storage Based” or “Virtualization Based” approach:

Monday 3 December 2018

Create Time-Related Tables and Generate Time Data in SAP HANA XSA Platform


Time data is necessary almost in any kind of data manipulation process, as well as adding time-dimension to the calculation views. So, ways to go for the time-dimension has changed a bit with the release of SAP HANA XSA Platform. In this blog post, you’ll see how to create time-related tables if required, and generate time data through the steps on SAP WEB IDE.