Question Re: HOW TO USE PREDICTIVE ANALYTICS MODEL in Technology Q&A

HOW TO USE PREDICTIVE ANALYTICS MODEL

Former Member — Thu, 04 May 2017 10:16:43 GMT

I made a time series model using predictive analytics,and i saved the model in HANA.Now, i want use it in hana, how can i do?

Re: HOW TO USE PREDICTIVE ANALYTICS MODEL

pratheek_kv2 — Thu, 04 May 2017 10:26:03 GMT

Hi Richard,

Did you store it as a Procedure in HANA? If so, please call the procedure from HANA to use it.

Thanks,

Pratheek

Re: HOW TO USE PREDICTIVE ANALYTICS MODEL

Former Member — Thu, 04 May 2017 10:37:48 GMT

I made the model using Automated Analytics,and i can only save it as file or table in hana

Re: HOW TO USE PREDICTIVE ANALYTICS MODEL

Former Member — Thu, 04 May 2017 10:40:59 GMT

I made the model using Automated Analytics,and i can only save it as file or table in hana

Re: HOW TO USE PREDICTIVE ANALYTICS MODEL

achab — Thu, 04 May 2017 19:38:20 GMT

Hi Richard, you need to define what you mean by using a model. Our Predictive Factory component makes it possible to import the time series model, to retrain it if need be on a regular basis and to create forecasts (output data in HANA table) on a regular basis. Kind regards, Antoine

Re: HOW TO USE PREDICTIVE ANALYTICS MODEL

Former Member — Fri, 05 May 2017 01:08:08 GMT

Hi Antoine.I know the Predictive Factory can do this.Without the Predictive Factory,can i use the model to create forecasts? Now,i can only save it in HANA as a file or table,and i save it as a table, can i make a procedure with the table in HANA,so i can use the procedure in HANA?

Re: HOW TO USE PREDICTIVE ANALYTICS MODEL

achab — Fri, 05 May 2017 17:07:48 GMT

The easiest route to do this is the Factory. The reason behind this is that you will get new historical data points on a regular basis. Each time you will need to retrain your time series model. So just applying the model is not an option otherwise forecasts quickly become obsolete. This being said, I am pretty sure you might be able to use directly the APL library or a combination of APL code & exported model to do this in-HANA. However, as previously mentioned, this requires development skills and this is not the most straightforward route. kind regards Antoine

Re: HOW TO USE PREDICTIVE ANALYTICS MODEL

Former Member — Tue, 09 May 2017 09:43:56 GMT

Thank you,Antoine.At last,i choose the Factory,and i learn how to do it now.