Skip to Content
0

PAL Seasonality Test

May 29, 2017 at 04:13 PM

114

avatar image
Former Member

Hi guys,

I'm trying to run a seasonality test on my time series data using the seasonality function of the PAL library. Unfortunately, I encounter a problem with the definition of the output table called decompose. In the PAL Guide, there are 2 options to definition the decompose table. First one comprises the information of the trend seasonality and the irregular (random) components of a time series. The second only considers the irregular one. As the function indicates to analyze the time series regarding to potential cycles, so I expect to get the cycle component as well. So I tried to perform the test with the first decompose table, but in return I get the following error:

AFL error: Registration of AFLLANG wrapper procedure "TSSEASONAL_PROC" failed with error 'inconsistent parameter description'.

Meaning that the function doesn’t accept the first table…

With the second table, the procedure works fine, but I miss the seasonal component.

Any idea that might solve this problem?

Regards

Chen

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member
Jun 01, 2017 at 02:37 AM
0

Hi Chen,

Could you share your table definition, and I am afraid that there is some problem on it.

Plus, what's your HANA/AFL revision?

Best regards,

Meilin

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Meilin,

the type of the decomposition table is definied as

CREATE TYPE PAL_TS_DECOMPOSE_T AS TABLE(
"PERIOD" INTEGER,
"SEASONAL" DOUBLE,
"TREND" DOUBLE,
"RANDOM" DOUBLE
);

I'm not sure about the revision of the AFL Library. I guess it's 121 (under installaed Plug-ins at the administration page in HANA Studio).

Thanks in advance!

0
Former Member

Hi Jianlian,

Sorry for the delayed, but such an interface is not available until HANA 2.0. As your HANA version is 1.0 SPS12, you can only use the old interface, i.e., outputs only random component.

https://help.sap.com/viewer/2cfbc5cf2bc14f028cfbe2a2bba60a50/1.0.12/en-US/d990dc754e714d95a30721aa1dc3f2f0.html

Best regards,

Meilin

0
avatar image
Former Member Jun 16, 2017 at 12:44 PM
0

Hello Meilin,

thank you for the advice. I'm afraid that we don't have the latest AFL revision (121).

The table should be alright, as it's defined as required. Nevertheless here is the table definition

CREATE TYPE SEASONAL_DECOMPOSE_T AS TABLE(
"PERIOD" INTEGER,
"SEASONAL" DOUBLE,
"TREND" DOUBLE,
"RANDOM" DOUBLE
);


Regards

Share
10 |10000 characters needed characters left characters exceeded
Antoine CHABERT
Sep 15, 2017 at 07:20 AM
0

Former Member were you able to solve your problem? Kind regards Antoine

Share
10 |10000 characters needed characters left characters exceeded