Welcome to the first installment in the SAP S/4HANA and SAP Predictive Analytics integrator Blog Series written by Shekhar Chhabra

The idea of this section is to get the pieces of PAi installed, configured, connected before we can start creating, publishing, integrating predictive models into the world of PAi.

Over the next few weeks we are going to detail the following:

Install the PAi Delivery Unit

Here we will describe steps on how to install the PAi Delivery Unit:

PAi Delivery Unit Installation Validation

Here are a couple of tips and tricks to check that the PAi Delivery Unit was installed successfully and, that your SAP HANA is configured correctly for PAi. This set of steps involve executing some SQL. The SQL provided is from the PAi Team.

select * from "_SYS_REPO"."DELIVERY_UNITS" where DELIVERY_UNIT=‘HANA_UMML’;

select * from "_SYS_REPO"."DELIVERY_UNITS" where DELIVERY_UNIT=‘HCO_PA_APL’;

Each Delivery Unit should be returned when the SQL is executed successfully. For example, see this screenshot:

Here is more SQL to execute:

SELECT ifnull(A.PLUGIN_NAME, B.PLUGIN_NAME)||’.’||ifnull(A.AREA_NAME, B.AREA_NAME)||‘.enabled‘ as "Key", map(PACKAGE_STATUS, ‘REGISTRATION SUCCESSFUL’, ‘true’, ‘false’) as "Value" FROM "SYS"."M_PLUGIN_STATUS" as A

full outer join (

select ‘sap_afl_sdk_apl’ as PLUGIN_NAME, ‘APL_AREA’ as AREA_NAME FROM dummy

union all

select ‘afl’ as PLUGIN_NAME, ‘AFLPAL’ as AREA_NAME FROM dummy) as B

on A.PLUGIN_NAME = B.PLUGIN_NAME and A.AREA_NAME = B.AREA_NAME

union all

SELECT lower(PLUGIN_NAME || ‘.’ || replace(KEY, ‘ ‘, ‘.’)) as "Key", VALUE as "Value" FROM "SYS"."M_PLUGIN_MANIFESTS"

union all

select ‘hana.version’ as "Key", VERSION as "Value" from SYS.M_DATABASE

union all

select ‘hana.scriptserver.enabled’ as "Key", map(ACTIVE_STATUS, ‘YES’, ‘true’, ‘false’) as "Value" from

(select ‘scriptserver’ as SERVICE_NAME from dummy) as A

left join M_SERVICES as B

on A.SERVICE_NAME = B.SERVICE_NAME

The above lets you know if the SAP HANA ScriptServer is started, what version of APL is installed on the system. Scroll down to the bottom of the result.

Finally, we can use this SQL to check if the ABAP technical user has the PAi role needed to execute and consume predictive models.

SELECT * FROM "PUBLIC"."EFFECTIVE_ROLES" where USER_NAME = ‘’ and ROLE_NAME = ‘sap.hana.pai::ExecutePAI’;

All the above SQL can also be run via HANA studio connected to the HANA DB, provided your user has all the necessary roles and authorizations.

In the next installment I will walk you through the configuration steps required on the SAP Netweaver. Stay Tuned!!

，什么是云，物联网专用卡，淘客app开发，大数据和云计算，大数据精准