xP&A CX Commercial Planning - Manage data loads for xP&A Commercial Planning

To be able to initialize integration flows from SAP Analytics Cloud you will need to set up a connection of type HTTP API. This connection will need to use the service key credentials from your SAP Process Integration Runtime, so let’s go there.

Start your browser and go to your SAP BTP Cockpit. Open the Services section and click on Instances and Subscriptions

To quickly locate your process integration runtime service you can use the drop downs on top:

In the service drop down, filter for Process Integration Runtime. In the plans drop down, filter for integration-flow.

Hint: This should be the same one you had used to set up the flows during the tutorial xP&A Commercial Planning - How to set up system connections

Once you have located the correct one in the list of instances click on the Key link in the Credentials column. You will get pop up displaying the credential details for OAuth authentication.

Take a note of:

• clientid
• clientsecret
• url
• tokenurl

Now that you have retrieved the credentials head over to the next step to retrieve the API end point for your connection

In case you have not worked through the previous tutorial xP&A Commercial Planning - How to set up system connections for defining the endpoints for each integration flow in step 10, this step will show you an easy way to get the defined endpoints for each flow.

Head over to your Integration Suite instance. In section Monitor click on Integrations.

In the search field enter market which should give you any of the integration flows being part of the SAP Commercial Planning package. Click on one of the search results.

On the right hand-side under tab Endpoints, you can find the Endpoint for the particular flow.

Note down the whole URL. You will need the part in the beginning of the URL (anything before /http/<name of flow endpoint>) for the general connection set up.

When calling the individual endpoints of each flow afterwards by multi action, you will need the base URL plus individual flow suffix.

Now that we have the credentials, the URL and the endpoint(s), let us create the HTTP API connection in SAP Analytics Cloud.

In SAP Analytics Cloud click on menu entry Connection.

and then on the + icon to add the new connection

Please choose the connection type HTTP API.

You will get a pop up to enter the connection details

Provide the following details

Once you have entered all details click on the Create button to have your connection created.

Let’s have a look at the Multi Actions now.

You can find the list of the multi actions delivered with the content package and their integration flows for transferring data in the table below. You can find more information on the individual cloud integration flows in their package documentation on SAP Business Accelerator Hub.

The set up of the multi actions for all flows follows a similar scheme.

The following points need to be configured in all of the multi actions

• the connection to be used
• the URL to be called for the respective API end point
• parameters and their values to be passed in the body

Let’s use the multi action SAP_MKT_IM_MarketingPlanning_LoadBaselineQuantities as an example.

Please repeat these steps for all multi actions that you require.

In the Files menu search for multi action SAP_MKT_IM_MarketingPlanning_LoadBaselineQuantities and open it

In the multi action screen, click on the API step in the middle of the screen. On the Step Details panel on the right-hand side you will need to finalize the details for the step.

In field HTTP API Connection pick the connection you have set up in the previous step.

In the field API URL you need to enter the API endpoint of your integration flow.

This is:

• The URL as determined in step 1
• /http
• the end point (e.g. /xpa_mkt_write2sac ) you have configured in the previous tutorial xP&A Commercial Planning - Data Integration in step 10 (or as retrieved in step 2 of this tutorial).

Example: https://<host of your process integration runtime>/http/<your configured end point>

In the Body input field you need to specify three parameters and their values for the integration flow:

If you are working with the models as delivered by default, the parameter modelID is pointing to the correct model id already. In case you have created a copy of the model, make sure to insert the correct model id. The correct id can be found in the URL when opening your model from the File menu.

Parameters for calmonthFrom and calmonthTo are filled by parameters ${StartPeriod} and ${EndPeriod} respectively which will prompt you to enter a value when running the multi action.

In the Response section, leave the option as displayed in the screen shot below.

In section Request -> Method, leave the setting at Synchronous Return.

Great, now that you have customized the multi actions, head over to the next step to see them in action

Now you are ready to get your multi actions started.

Based on the different planning scenarios in the Commercial Planning package, the multi actions are linked in different stories. Hence, please find the story you need to open for each multi action in the table below:

To continue with our example, search for story SAP_MKT_Marketing_AdminPage in the File menu and open it.

Click on the Load Baseline Quantities multi action trigger to start the multi action.

You will get a pop up to set the parameters for start and end period as seen before in the previous steps. Enter values for start and end period and click on Run

Now your multi action will call the cloud integration flow to pick up baseline quantity data from SAP Integrated Business Planning for Demand and push it into your SAP Analytics Cloud planning model.

Once the job has finished, you will get a notification.

Please repeat steps 4 and 5 of this tutorial to get all of your multi actions ready.

Congratulations! You have now learned how to set up and initialize your integration jobs from within SAP Analytics Cloud. Visit our community page Extended Planning & Analysis Business Content.