Technical Articles
SAP Profitability and Performance Management Integration with SAP Analytics Cloud
Introduction
Have you tried bringing a bucket of water with a secured lid from one side to another using a bridge? Did the water spilled while crossing the bridge? Yes? No? Well, let’s find out!
In SAP Profitability and Performance Management 3.0, it can be integrated to multiple applications, non-SAP or SAP system and one of those is through SAP Analytics Cloud. In SAP Analytics Cloud, we can consume and analyze data from SAP Profitability and Performance Management.
And in this document, I will be explaining one of many ways how we can integrate SAP Profitability and Performance Management with SAP Analytics Cloud using a Query.
System Landscape: SAP Profitability and Performance Management and SAP Analytics Cloud
Since we need to setup first in SAP Profitability and Performance Management, we can see below the created structure used. In this structure, I used Model BW with BW InfoObjects as an input in the created Query source Environment.
SAP Profitability and Performance Management setup:
Model BW as an input to our Query: This Model Bw consists of four (4) BW InfoObjects.
- ZQA_CUST
- ZQA_PROD
- ZQA_QTY
- ZQA_AMT
Input Data
- This is the data inserted in the Model BW.
Query Source: Environment
Once you clicked the Analyze button, it will display the data below.
We can also check the results via Transaction code RSRT in PaPM Client. To check, first get the Query by clicking Function Attributes > Runtime Attributes > Query.
In your SAP Profitability and Performance Management Client, go to Transaction code RSRT > Input the copied Query > Execute.
It will display the same results with our Query Function.
Now that we already have the data records to be consumed by SAP Analytics Cloud, we will now proceed in setting up the other side of the bridge which is the SAP Analytics Cloud.
SAP Analytics Cloud setup:
Live BW Connection:
1.Create BW Live Connection by clicking Connections
3.Connect to Live Data
Fill in the required fields based on the SAP Profitability and Performance Management system we are connecting.
If in case you encountered CORS issue in connecting to your SAP Profitability and Performance Management system, you can refer to Firas Kassem’s blog on how to Enable BW Direct Live Connections https://blogs.sap.com/2017/11/08/enable-bw-direct-live-connections-in-sac/ .
Conclusion:
Now that I have showed you how to integrate SAP Profitability and Performance Management with SAP Analytics Cloud through Query and Live BW Connection (as if building a bridge and transferring a bucket of water from one side to another), you can now analyze data from SAP Profitability and Performance Management to SAP Analytics Cloud securely without the need of manual transfer.
If you have any questions, feel free to ask here here in SAP Community Questions section link.
For more blog post, you can check the SAP Community Blog post link.
I hope this helps and I encourage you to share it to your friends!
Thanks for this post !
When you do some changes in your P&PM query you need to activate it. Sometimes the activation changes the name of the generated query used by SAC. The consequence is that your SAC model is broken. have you found a solution to prevent this problem ?
kind regards,
Romuald
Excellent!! Thanks for posting the blog.
One question,can I trigger PaPM process from SAC rather than just reading the data from query functions?
For example, we could use Analysis for Microsoft Office to call planning sequence/planning. At the backend, it actually calls the PaPM processing functions. Is SAC capable to do so as well?
Thanks and regards,
Cindy
Hi Cindy,
Yes, you can do that. Please check below blog.
https://blogs.sap.com/2021/02/04/sap-profitability-and-performance-management-a-unique-integration-with-sap-bpc-and-sap-analytics-cloud/
Thanks & Regards,
Akshay Georaikar