HANA PAL (double exponential smoothing) multiple data sets and speed

[Former Member]

Problem -

I'm attempting to implement multiple stactical forecasts across several data sets. Currently in SQLSCRIPT I am looping at my data sets and calling out to DoubleSmooth  implementation and returning the result, ideally what I would like to do is pass a single large data set 12 months for 12 different sets and get 12 different forecast results, is this possible ? should I be using a different PAL/BFL function to execute the forecast (that has this capability).

The intent of this is to;

1. Remove the loop that current marshals the data for the call into the PAL function.

2. Allow HANA to optimize / parallel the calls to increase speed of processing.

Any ideas would be greatly appreciated.

[Former Member]

Moved to HANA threads ... thanks

[Laszlo_B]

Hello Richard,

you might get a faster answer in Space http://scn.sap.com/community/developer-center/hana, as HANA-related questions are usually handled there - so, you might want to post this question there too.

Best regards,

Laszlo