Skip to Content
avatar image
Former Member

Predictive Analytics Authorizations

Hello, We are trying to use predictive Analytics for the first time.

We granted the following authorizations:

Now when we try to run a simple predictive we can see that HANA tryies to run the following statement:

CREATE PROCEDURE "TEST_PREDICT_MODEL_PAS2_3" (IN input1 "APR_MODEL_PAS2_3",IN input2 "APR_TYPE_PAS2_3", OUT result "COMP_APRMODEL_STORE_TYPE_PAS2_3") LANGUAGE RLANG READS SQL DATA AS BEGIN attach(input1);attach(input2);library(arules);model_char1

Could not execute 'CREATE PROCEDURE "TEST_PREDICT_MODEL_PAS2_3"(IN input1 "APR_MODEL_PAS2_3",IN input2 ...'

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

Which authorizations are missing? What did we miss?

Thanks,

Amir

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 27, 2015 at 06:44 AM

    Hi Amir,

    Just to check that this is not an PAL configuration problem.

    Please do the following PAL  check with following commands:

    SELECT * FROM "SYS"."AFL_AREAS" WHERE SCHEMA_NAME = '_SYS_AFL' AND AREA_NAME = 'AFLPAL';

    SELECT * FROM "SYS"."AFL_PACKAGES" WHERE SCHEMA_NAME = '_SYS_AFL' AND AREA_NAME = 'AFLPAL';

    SELECT * FROM "SYS"."AFL_FUNCTIONS" WHERE SCHEMA_NAME = '_SYS_AFL' AND AREA_NAME = 'AFLPAL';

    You can also do the same to test your APL (Automated Predictive Libraries):

    select * from "SYS"."AFL_AREAS";

    select * from "SYS"."AFL_PACKAGES";

    select * from "SYS"."AFL_FUNCTIONS" where AREA_NAME='APL_AREA';

    select * from "SYS"."AFL_FUNCTION_PARAMETERS" where AREA_NAME='APL_AREA';

    None of the result tables should be empty if PAL & APL is configured correctly.


    As for autorizations you can refer to the SAP HANA PAL guide:

    For each AFL area, there is a role. You must be assigned this role to execute the functions in the library. The role for the PAL library is automatically created when the Application Function Library (AFL) is installed.

    The role name is:

    AFL__SYS_AFL_AFLPAL_EXECUTE

    To generate or drop PAL procedures, you also need the following role, which is created when SAP HANA is installed:

    AFLPM_CREATOR_ERASER_EXECUTE

    From the document "SAP HANA Predictive Analysis Library (PAL)" - based on SAP HANA Platform SPS 09, Document Version: 1.1 – 2015-02-16

    Try it out and please share your results.

    Best regards,

    Kurt Holst

    Add comment
    10|10000 characters needed characters exceeded

  • May 26, 2015 at 05:10 PM

    Hi Amir,

    Can you please precise what client you are using? Automated Analytics or Expert Analytics? Also are you triggering specific HANA predictive library (APL? PAL?)

    Thanks & regards

    Antoine

    Add comment
    10|10000 characters needed characters exceeded