Store Cluster Analysis using R powered by HANA - p...
SAP for Retail Blogs
Gain insights and practical tips to captivate customers, optimize your supply chain, and drive growth with SAP for Retail software. Share your own insights!
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.
