Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
replied

Hi Amir,

Thanks for the quick feedback.

Well the missing results on the APL functions is not the problem as this is unrelated to the HANA ABC Analytics (PAL).

I see that you have a RLANG call in your scripts. If you want to use the R language then you also need to provide that priviliges to your user. "Create R Script" as shown below:

May I suggest that you take a look at this article - in the appendix you find an end-to-end scenarios where HANA Script is used with the PAL:

http://scn.sap.com/docs/DOC-50803

Best regards, Kurt

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question