Skip to Content
author's profile photo Former Member
Former Member

Statistical functions in HANA - without R

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    Posted on Jul 31, 2012 at 08:14 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Ignacio:

      Well...you're somehow right...for sure R is not as fast as SAP HANA and the fact that the data need to go to the R server and then back to SAP HANA might degrade the performance...but...the key here is to design the process in a way that it behaves in the most proficient way...meaning that you will pass to the R server only what you need and pass back to SAP HANA only what you need as well...inside R there's also many performance improvement techniques...

      That happens everywhere...when I was in the consulting field I need to do a lot of performance work on program made by others...sometimes I cut down program that took hours to processed to a couple of minutes just by fixing some not very optimal code.

      No matter how quick and fast the system is...is your process is not well designed, then it's going to be slow...and eventually fail...SAP choosed R because it's the best statistical software out there...easy to use...extensible and very powerful.

      Just like an anecdote...I learned R just because I read that it was going to be used by SAP HANA...

      Want something nice about R...read this 😊 The R Inferno

      Or maybe some of my humble blogs 😊 (The links are on the blog I sent you)

      Greetings,

      Blag.

  • author's profile photo Former Member
    Former Member
    Posted on Jul 31, 2012 at 06:16 PM

    Hi Ignacio,

    If you meant using HANA SQL statement, I believe the answer is NO with the current release. You can always create one yourself on storedprocedure, or use R.

    Best,

    Rocky

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2012 at 04:18 PM

    Thanks Rocky and Alvaro for your responses... looks like R is definitely the way to go!

    Regards

    Ignacio

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 14, 2015 at 03:57 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 14, 2015 at 04:13 PM

    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
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.