Implementing system-versioning and time-travel data handling scenarios in SAP HANA 2.0

Sometimes functional requirements for data warehouses (DWH) include support of time-dependency for master data. For example, in the real world, a manager changes their city from time to time. According to DWH data model, city is an attribute of manager. It’s required to see which city relates to manager at a particular date. In this case, city must be the time-dependent attribute of manager

If you are going to build DWH using SAP BW, you may not worry. SAP BW has proven comprehensive support for time-dependent master data out-of-the-box. But what if you need to build SAP HANA SQL Datawarehouse? Does SAP HANA support time-dependent scenarios like in SAP BW?

Setting up a BW/4 Instance in CAL

Being familiar with AWS or any other PaaS or SaaS provider one should think that setting up an instance of a piece of software is a one to ten click thing in modern times. Not so with SAP!

Today I have struggled with the activation of the “SAP BW/4HANA 2.0 SP02 including SAP BW/4HANA Content 2.0 SP01” image in CAL and not only with the image but also with the very poor “Getting Started with SAP BW/4HANA 2.0 SP02 including SAP BW/4HANA Content 2.0 SP01” that acompanies the image.

Next Generation Hana Development Model

I would like to introduce you to the next generation development model for Hana, the HanaAppContainer project. It should be

◉ easy to use
◉ powerful
◉ simple to setup
◉ run-everywhere, from a laptop to on-prem to a large cluster with load balancers in the cloud

How to replicate STXL table (INDX-like) using SDI

The Problem

The purpose of this document is to describe our approach to replicate table STXL from SAP ECC to HANA DB using SAP HANA SDI. Replicating STXL is challenging because it is an INDX-like table. Its content must be parsed before being saved into HANA DB.

In our previous projects, SAP SLT was the tool used to perform the replication. There is good documentation on SCN explaining how to configure SLT to replicate INDX-like tables. However, we could not find similar materials when SAP HANA SDI is used.

NSE(Native Storage Extension) Data Tiering Options

What is NSE ?

HANA SPS 04 version has introduced the NSE. NSE is used to store the warm data. HANA was used to store the hot data in memory but as data growth occurred in some of the organization the need for another store came into picture and SAP came out with a solution to introduce the another store called as warm store which in turn called as NSE.

Calculate the total number of Business days present in a Month as per Organization/Company calendar

Introduction

The purpose of creating this table function is to calculate the  key figures which are very important for Target Vs Sales Analytical reporting. This Key figures can be referenced in Predictive Sales reporting.

An example to call PAL Apriori via AMDP

Introduction

SAP Predictive Analysis Library (PAL) is delivered with SAP HANA. This application function library (AFL) defines functions that can be called from within SAP HANA SQLScript procedures to perform analytic algorithms.

ABAP-based SAP applications are able call the functions (Classification, Regression, Clustering, Association Rule, Recommender Systems, etc.) provided by PAL. One common way is to do it via AMDP.

Automating your SAP HANA and S/4HANA by SAP deployments using Ansible – Part 2

The goal for these blog post series is to show how we can make SAP Solutions deployments easy and reliable using Ansible automation.

In the previous blog post, we explained what Ansible is, some best practices while using Ansible, benefits of using it and a quick introduction to Ansible Tower.

In this blog post, we are going to focus on the ‘Red Hat Enterprise Linux System Roles for SAP’. These are Red Hat supported (Tech Preview at the time this blog post was written) Ansible Roles to assist with the OS-specific configuration required while installing SAP HANA or SAP NetWeaver software.

Automating your SAP HANA and S/4HANA by SAP deployments using Ansible – Part 1

The goal for these blog post series is to show how we can make SAP Solutions deployments easy and reliable using Ansible automation.

What is Ansible

Ansible is a radically simple IT automation engine that automates cloud provisioning, configuration management, application deployment, intra-service orchestration, and many other IT needs.

SAP High Availability. Step-by-step guide

High Availability on Physical layer