How to have Predictive Analytics functions [PAL] embedded in sql scripted views and applied on data in HANA Modeling

Here we are going through how we can use the Predictive Analytics functions provided via PAL in HANA in the Scripted Calculated views .

We are following the SAP provided SAP HANA Predictive Analytics Library ( PAL ) guide to do this.

PAL provides a vast business opportunity and immense business value to cater the needs of Analytics domain in projects implemented on SAP HANA platform.

SDI/SDQ OData Adapter in HANA SPS12 - GET, PUT operation and REPLICATION flowgraph

It is a really simple scenario we are dealing with: Accessing a public OData URL, read from and write to the tables exposed there. HANA is running on SPS12 on premise. The purpose of this blog entry is to better illustrate the different steps analogous as they are explained in the HANA EIM Administration Guide.

In this scenario we are accessing the following public OData Service URL (ODATA V4) which allows read and write operations.

http://services.odata.org/V4/OData/(S(1t3xkksfwh00yknrwftrjhm5))/OData.svc/

What’s new in SAP HANA SPS12 – Smart Data Access

Overview

The SPS12 release is upon us, and with it a few great new features for SDA: Kerberos constrained delegation, UPSERT support, ROW_NUMBER support, performance optimizations and more.

What is SAP HANA Smart Data Access?

For those of you not so familiar with SDA, it has been available as a part of SAP HANA since SPS6 and gives you the power to expose data from remote sources as virtual tables in SAP HANA. This is a huge advantage compared to traditional ETL processes in many situations as it is gives you a cost-efficient, easy-to-deploy option to get real-time data visibility across fragmented data sources. Not to mention the advantage it brings in terms of location agnostic development when building applications on HANA which need to leverage data from multiple sources.

Capturing and Replaying Workloads - by the SAP HANA Academy

Introduction

One of the new SPS 12 features for monitoring and managing performance in SAP HANA is the ability to capture and replay workloads. This feature enables you to take a performance snapshot of your current system -- a captured workload -- and then execute the same workload again on the system (or another system from backup) after some major hardware or software configuration change has been made. This will help you evaluate potential impacts on performance or stability after, for example, a revision upgrade, parameter modifications, table partition or index changes, or even whole landscape reorganisations.

In this blog, I will describe the required preparation and the operational procedures.

SAP HANA SPS 12 What's New: Security - by the SAP HANA Academy

In the upcoming weeks we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA Support Package Stack (SPS) 12.

For Security for the SPS 11 release, see SAP HANA SPS 11 What's New: Security - by the SAP HANA Academy

Overview Video

SAP HANA Security - SPS 12 - YouTube