In this blog post I will guide you through the process of setting up a multi action to start the data export from SAP Analytics Cloud to SAP S/4HANA Cloud.
As a prerequisite, ensure that you have already created a Configuration ID for Financial Plan Data in your SAP S/4HANA Cloud system.
For details, see How to Manage Financial Plan Data Jobs for SAP Analytics Cloud Integration.
In my example, I want to export planned cost center expenses and created the configuration CCTR_EXP in my SAP S/4HANA Cloud system for the same.
In addition to these settings, you also need to create another communication system, user and arrangement using communication scenario SAP_COM_0326 in your S/4HANA Cloud system, to be able to start the configuration with a multi action.
To do this, follow the steps in the SAP Help portal, SAP_COM_0326.
In my example, the new Communication system ID / Name is SAC_DATA_INTEGRATION_0326.
Create a new User for Inbound Communication with Authentication Method User Name and Password.
Note down user name and password.
You’ll need this later when you set up the connection in SAP Analytics Cloud.
Save the communication system.
Then create a communication arrangement, in my example I named it SAC_DATA_INTEGRATION_0326, using Scenario SAP_COM_0326.
Under Additional Properties add:
External Scheduler Company > SAPExternal Scheduler Product > Analytics Cloud
Note down the Service URL/Service Interface, this will be needed to create the connection and the multi action API step in SAP Analytics Cloud.
To enable your user to see the job log details, either enhance an existing business role or create a new one as follows:
Access Maintain Business Role app and choose NewSelect Role Type > Business UserEnter a Business Role ID and DescriptionSelect CreateAdd Business Catalog > SAP_CORE_BC_APJ_JCE
this is needed to grant an authorization to see the application job log of the communication userAdd IAM Apps > F7902_TRAN
this is needed to grant authorization to perform integration to Plan Data Line Items in SAP S/4HANASelect Maintain Restrictions and set Access Categories Write, Read, Values HelpSet restriction types to your needsRead, Value Help Set restrictions and values for restriction type JCENAME_JCEPART Application Job Catalog Entry > SAP_FINS_INT_SAC_S4Application Job Part > APPLOGSet all other restriction types to your needs.Add your business user to this business role
Now you’re done with the configuration in the SAP S/4HANA Cloud system. Let’s access the SAP Analytics Cloud tenant you specified in the communication system.
Use the side navigation to access Connections
Enter a name and description for your connection.
Data Service URL
Enter the Service URL/Service Interface from your communication arrangement based on Scenario SAP_COM_0326.
User Name and Password
Enter the credentials of your Inbound Communication user you have created for communication system based on Scenario SAP_COM_0326.
Now that you’ve set up the connection, you can use the same to create an API step within a multi action.
Use the side navigation to access Multi Actions, choose Create and then Add API Step
Step Name
Enter a speaking name for your API step, for example the ID of your configuration job
HTTP API Connection
Select the connection you’ve just created.
API URL
Adjust the below URL to fit to your system settings, whereas
DataServiceURL is the Service URL/Service Interface of your communication arrangement based on Scenario SAP_COM_0326JobName is the name which will be displayed in the Schedule Financial Plan Data Jobs for SAP Analytics Cloud Integration app job log, for example CCtrExpensesStory_ExportUserID is the ID of your business user. The integration will be performed on behalf of your business user, with your authorizations.ConfigID is the ID of the configuration job you want to trigger
<DataServiceURL>/JobSchedule?JobTemplateName=’SAP_FINS_INT_SAC_S4_SINGLE_RUN’&JobText=’<JobName>‘&JobUser=‘<UserID>’&TestModeInd=false&JobParameterValues='{“VALUES”:[{“NAME”:”P_CONFID”,”T_VALUE”:[{“SIGN”:”I”,”OPTION”:”EQ”,”LOW”:”<ConfigID>“,”HIGH”:””}]}]}’
Note that some special characters (space, {, [) are not allowed and must be replaced by the corresponding HTML encoding. You need to encode the part of the URL defining the job parameter values (marked in orange) and the result should be something like below:
<DataServiceURL>/JobSchedule?JobTemplateName=’SAP_FINS_INT_SAC_S4_SINGLE_RUN’&JobText=‘<JobName>’&JobUser=‘<UserID>’&TestModeInd=false&JobParameterValues=’%7B%22VALUES%22%3A%5B%7B%22NAME%22%3A%22P_CONFID%22%2C%22T_VALUE%22%3A%5B%7B%22SIGN%22%3A%22I%22%2C%22OPTION%22%3A%22EQ%22%2C%22LOW%22%3A%22<ConfigID>%22%2C%22HIGH%22%3A%22%22%7D%5D%7D%5D%7D%27′
Activate Require CSRF Token
CSRF Token URL
enter the below URL, add the DataServiceURL of your communication arrangement.
<DataServiceURL>/JobTemplateSet(JobTemplateName=’SAP_FINS_INT_SAC_S4_SINGLE_RUN’,JobTemplateVersion=’0′)
Save the multi action.
Now you are ready to add the multi action to any existing or new story.
Once you published your data in SAP Analytics Cloud and started the data transfer to SAP S/4HANA Cloud, you can have a look into the job log in the check the result of your job.
Access Display Financial Plan Data app to see the data.
With this setup complete, you can seamlessly export planned financial data from SAP Analytics Cloud to SAP S/4HANA Cloud and monitor the results through system logs and reporting apps.
In this blog post I will guide you through the process of setting up a multi action to start the data export from SAP Analytics Cloud to SAP S/4HANA Cloud.As a prerequisite, ensure that you have already created a Configuration ID for Financial Plan Data in your SAP S/4HANA Cloud system.For details, see How to Manage Financial Plan Data Jobs for SAP Analytics Cloud Integration.In my example, I want to export planned cost center expenses and created the configuration CCTR_EXP in my SAP S/4HANA Cloud system for the same.In addition to these settings, you also need to create another communication system, user and arrangement using communication scenario SAP_COM_0326 in your S/4HANA Cloud system, to be able to start the configuration with a multi action.To do this, follow the steps in the SAP Help portal, SAP_COM_0326.In my example, the new Communication system ID / Name is SAC_DATA_INTEGRATION_0326.Create a new User for Inbound Communication with Authentication Method User Name and Password.Note down user name and password.You’ll need this later when you set up the connection in SAP Analytics Cloud.Save the communication system.Then create a communication arrangement, in my example I named it SAC_DATA_INTEGRATION_0326, using Scenario SAP_COM_0326.Under Additional Properties add: External Scheduler Company > SAPExternal Scheduler Product > Analytics CloudNote down the Service URL/Service Interface, this will be needed to create the connection and the multi action API step in SAP Analytics Cloud.To enable your user to see the job log details, either enhance an existing business role or create a new one as follows:Access Maintain Business Role app and choose NewSelect Role Type > Business UserEnter a Business Role ID and DescriptionSelect CreateAdd Business Catalog > SAP_CORE_BC_APJ_JCEthis is needed to grant an authorization to see the application job log of the communication userAdd IAM Apps > F7902_TRANthis is needed to grant authorization to perform integration to Plan Data Line Items in SAP S/4HANASelect Maintain Restrictions and set Access Categories Write, Read, Values HelpSet restriction types to your needsRead, Value Help Set restrictions and values for restriction type JCENAME_JCEPART Application Job Catalog Entry > SAP_FINS_INT_SAC_S4Application Job Part > APPLOGSet all other restriction types to your needs.Add your business user to this business role Now you’re done with the configuration in the SAP S/4HANA Cloud system. Let’s access the SAP Analytics Cloud tenant you specified in the communication system.Use the side navigation to access Connections Enter a name and description for your connection. Data Service URLEnter the Service URL/Service Interface from your communication arrangement based on Scenario SAP_COM_0326.User Name and PasswordEnter the credentials of your Inbound Communication user you have created for communication system based on Scenario SAP_COM_0326.Now that you’ve set up the connection, you can use the same to create an API step within a multi action.Use the side navigation to access Multi Actions, choose Create and then Add API StepStep NameEnter a speaking name for your API step, for example the ID of your configuration jobHTTP API ConnectionSelect the connection you’ve just created.API URLAdjust the below URL to fit to your system settings, whereasDataServiceURL is the Service URL/Service Interface of your communication arrangement based on Scenario SAP_COM_0326JobName is the name which will be displayed in the Schedule Financial Plan Data Jobs for SAP Analytics Cloud Integration app job log, for example CCtrExpensesStory_ExportUserID is the ID of your business user. The integration will be performed on behalf of your business user, with your authorizations.ConfigID is the ID of the configuration job you want to trigger<DataServiceURL>/JobSchedule?JobTemplateName=’SAP_FINS_INT_SAC_S4_SINGLE_RUN’&JobText='<JobName>’&JobUser='<UserID>’&TestModeInd=false&JobParameterValues='{“VALUES”:[{“NAME”:”P_CONFID”,”T_VALUE”:[{“SIGN”:”I”,”OPTION”:”EQ”,”LOW”:”<ConfigID>”,”HIGH”:””}]}]}’Note that some special characters (space, {, [) are not allowed and must be replaced by the corresponding HTML encoding. You need to encode the part of the URL defining the job parameter values (marked in orange) and the result should be something like below:<DataServiceURL>/JobSchedule?JobTemplateName=’SAP_FINS_INT_SAC_S4_SINGLE_RUN’&JobText='<JobName>’&JobUser='<UserID>’&TestModeInd=false&JobParameterValues=’%7B%22VALUES%22%3A%5B%7B%22NAME%22%3A%22P_CONFID%22%2C%22T_VALUE%22%3A%5B%7B%22SIGN%22%3A%22I%22%2C%22OPTION%22%3A%22EQ%22%2C%22LOW%22%3A%22<ConfigID>%22%2C%22HIGH%22%3A%22%22%7D%5D%7D%5D%7D%27′ Activate Require CSRF TokenCSRF Token URLenter the below URL, add the DataServiceURL of your communication arrangement. <DataServiceURL>/JobTemplateSet(JobTemplateName=’SAP_FINS_INT_SAC_S4_SINGLE_RUN’,JobTemplateVersion=’0′)Save the multi action.Now you are ready to add the multi action to any existing or new story.Once you published your data in SAP Analytics Cloud and started the data transfer to SAP S/4HANA Cloud, you can have a look into the job log in the check the result of your job.Access Display Financial Plan Data app to see the data.With this setup complete, you can seamlessly export planned financial data from SAP Analytics Cloud to SAP S/4HANA Cloud and monitor the results through system logs and reporting apps. Read More Technology Blog Posts by SAP articles
#SAP
#SAPTechnologyblog
