Keep in mind, that is not an standard SAP solution. This only relies on a custom R package that can work with ODBC enabled tables, and like any custom packages, there are many limitations…anyway…this should be fixed when SAP released the official R into HANA integration.
In my previous blog Prediction model with HANA and R we create a stored procedure in HANA to populate a table called TICKETS_BY_YEAR, then on R we calculate the prediction for the next year and generate a nice graphic showing both the real data and the prediction. So…of course I’m not going to repeat all that.
This is the R code that we need to use…
prt.lm=lm(tickets ~ period)
After we execute this code, we can check on HANA that our new table called PREDICTION_TICKETS was created…
* We don’t have a way to validate if the table exists or not.
* We must delete the table before doing the insert, otherwise is not going to work.
* Even when the date field was called PERIOD, R named it “year” and pass it into HANA.
* We can’t specify the type of the fields, nor the lenght
* We are forced to have an additional column with a numeric index, that we can nicely call “Id”…
As I said early…this is just a custom package that allows us to play…this shouldn’t be used as a final solution, but as a playground. Enjoy!