Are there any statistical functions available in HANA outside of the ones included in R?
I know that R is open source and easily (at least according to the docs, I have not actually tried it) configurable to work with HANA, but all I'm looking for is relatively simple stuff like calculating standard deviations and getting random numbers from a normal probability distribution.
Is there something I can use, or will I need to configure (and learn to use!) R?
Thank you
Ignacio
Ignacio:
I would say that R is the best way to go...and yes...it's easy and fun...if you're using SAP HANA on AWS just follow this blog...
http://scn.sap.com/community/developer-center/hana/blog/2012/05/21/when-sap-hana-met-r--first-kiss
Greetings,
Blag.
Hi Ignacio.
'just went accross this conversation via Google. So usefull or not, I think it's worth updating it a bit, as things have evolved quite significantly since August 2012.
Since SPS06, SAP is delivered with ApplicationFunction Libraries.
The Application Function Libraries (AFL) includes both the Business Function Library (BFL) which contains functions for common business calculations, such as depreciation, cash flow discounting, Year-over-Year performance, and time series forecasting. The Predictive Analysis Library (PAL) has predictive algorithms, including classification, clustering, association, and more advanced time series functions.
They can be quite a powerfull starting point for implementing complex statistical models without R.
Have a look there : What´s New? SAP HANA SPS 07 AFL / Predictive
You can make use of the Application Function Modeler to leverage all theses.
There , have a look at Hilary Bliss' blog : SAP HANA and the Application Function Modeler | SAP BI BLOG.
lol thread bumped after 3 years later,
anyway you can use PAL library there are many useful functions inside. I used multiple regression for one of my calculation and so cool ðŸ˜€
Add a comment