- SAP Managed Tags
Requirement from customer:
- Customer checks the financial values on SAC story and is ok with the KPIs.
- Customer needs a button in SAC to send the KPIs to 3rd party system in a format different from what we have in Step 1.
Sample Layout of Report for 1: Format of report to validate KPI values, Accounts on rows and Period Amounts in columns.
Sample Layout of Report for 2: Format of data to be send outside of SAC using Button Script:
Here we will not cover Analytic Model development on SAP Datasphere end to end, below is how we take the oData request of Analytic model
Copy URL and adjust the URL depending on fields required and additional operators like sort, filter etc. This URL will contain the fields that need to be sent outside SAC, hence needs to be accurate.
Example:
The above URL can be shared with Cloud Integration (CPI), to be maintained in HTTP Adapter, also can be made dynamic with placeholders/filters. ( In our case w e are passing fiscal year, Period, company code etc. and the same is changed dynamically at CPI end.
Sample IFLOW from CPI ( HTTP Adapter)
Create a connection in SAP Analytics Cloud with CPI ( HTTP Connection ) :
This will be used to POST the data from SAC to the endpoint of CPI tenant(S).
Create MultiAction in SAP Analytics Cloud with API
“Test_Multiaction” created
HTTP API Connection is selected that was created in above step.
Message body can have fixed message, also can pass Parameters as in our case.
Parameters can be maintained here:
SAC Story/Page for Execution
I am taking an example of standalone story, but this can also be added to a new page of the same story that the user is viewing( like story in Sample Layout 1 shown above ).
As it can be seen above, we are using radio button, input text fields to capture user inputs to be passed to multiaction parameters shown above.
Before we can call the multiaction in our story, we need to attach/combine "Test_Multiaction" created above it in the story. Navigate to “Outline” and use “Add Multiactions” and follow screenshot below:
Below is the SAP Analytics Cloud script sample to set the parameters of Multiaction and also to call/execute the same. This will post the message to CPI
On successful execution, we get the message as below:
Monitor Job (MultiAction):
We can also monitor the status of runs/jobs for the created multiAction to check history and failure details.
Goto “Job Monitor - Multiactions”
| User | Count |
|---|---|
| 10 | |
| 8 | |
| 7 | |
| 6 | |
| 6 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 4 |
