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.

Monday, 10 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.

Friday, 7 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.

Wednesday, 5 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.

Friday, 30 November 2018

SAP S/4HANA: Key Adoption Scenarios to Consider Webcast Recap

SAP S/4HANA, SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Learning

This was a SAP user group webinar from yesterday.

Interesting developments are planned next year for 1809 in terms of system conversion; read below.

Wednesday, 28 November 2018

SAP HANA System Copy- Homogeneous On Multi Tenant Database – Refresh using SWPM

As explained on my last blog SAP HANA System Copy- Homogeneous On Multi Tenant Database that we have 3 Ways to do System Copy and i explain 2 Ways 1 and 3 according to the note -1844468 – Homogeneous system copy on SAP HANA, and i promised to add 2nd way as well , So below is the 2nd way to do system copy, For Pre checks and preparation please read the 1st blog,