Skip to Content
Author's profile photo Ramesh Duraisamy

Store Cluster Analysis using R powered by HANA – prototype

Store Cluster Analysis giving retailers insight into the  optimal number of  zones, and will align your retail stores to the appropriate zones. This is a minor attempt with R Powered by Hana.

What is R?

R is an open source programming language and software environment for statistical computing and graphics.

The goal of the integration of the SAP HANA database with R is to enable the embedding of R code in the SAP HANA database context. That is, the SAP HANA database allows R code to be processed in-line as part of the overall query execution plan. This scenario is suitable when an SAP HANA-base

How we performed Store Clustering:

R code is embedded in SAP HANA SQL code in the form of a RLANG procedure.

To achieve this, the calculation engine of the SAP HANA database was extended. The calculation engine supports data flow graphs (calculation models) describing logical database execution plans. A node in this data flow graph can be any native database operation, but also a custom operation. One of those custom operations is the R operator.

Below Video explains step by step procedure,

Thanks and Regards,

Ramesh D

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.