Skip to Content
0
Former Member
Apr 08, 2014 at 07:59 AM

Fail in Forecast Smoothing

29 Views

Hi,

as I listened to the Video about Forecast Smoothing this should be only available to SPS7.

The Video: http://www.saphana.com/docs/DOC-4326

Looking into the Table SYS:AFL_FUNCTIONS_ I find the Entry "FORECASTSMOOTHING" in the Table. So I guess the Forecast Smoothing is available to me.

In HANA Studio - Help - About ... I see Version: 1.0.7000 / Build id: 386119

But running my Example of Forecast Smoothing gives me the Error:

Could not execute 'CALL _SYS_AFL.PAL_TS (V_TS_DATA, #TS_PARAMS, TS_OPTIMAL_PARAMS, TS_RESULTS) WITH OVERVIEW' in 176 ms 111 µs .

SAP DBTech JDBC: [2048]: column store error: search table error: [2620] _SYS_AFL.AFLPAL:FORECASTSMOOTHING: [135] (range 2) AFLFunctionFatal exception: PAL error[73001502]:Ahead exception throw out, Check trace for details

My Params are:

INSERT INTO #TS_PARAMS VALUES ('THREAD_NUMBER', 2, null, null);

INSERT INTO #TS_PARAMS VALUES ('FORECAST_MODEL_NAME', null, null, 'TESM'); SESM: Single, DESM: Double, TESM: Triple

INSERT INTO #TS_PARAMS VALUES ('FORECAST_NUM', 30, null, null);

INSERT INTO #TS_PARAMS VALUES ('STARTTIME', 0, null, null);

INSERT INTO #TS_PARAMS VALUES ('CYCLE', 90, null, null);

INSERT INTO #TS_PARAMS VALUES ('FORECAST_AUTOMATIC', 0, null, null);

INSERT INTO #TS_PARAMS VALUES ('ALPHA', null, 0.1, null); 0-1 for smoothing weight

INSERT INTO #TS_PARAMS VALUES ('BETA', null, 0.1, null); 0-1 for trend (DESM & TESM)

INSERT INTO #TS_PARAMS VALUES ('GAMMA', null, 0.1, null); 0-1 for seasonality (TESM)

I try also without the FORECAST_AUTOMATIC, ALPHA, BETA, GAMMA but then I read in the Indexserver-Alert that the Param FORECAST_AUTOMATIC is missing.

As I know:

- The Data has no gaps

- The Base Example in the Documentation fails with the same error

Any suggestion?

How I can check if the Forecast SMoothing is available in my Version?

Regards,

Mansur