Skip to Content
Technical Articles
Author's profile photo Kevin Josh Topino

SAP Profitability and Performance Management Integration with SAP Analytics Cloud


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.

  3. ZQA_QTY
  4. 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


2.Create Connection

3.Connect to Live Data


Fill in the required fields based on the SAP Profitability and Performance Management system we are connecting.

To check on your SAP Profitability and Performance Management system Hostname and Port, go to SMICM in your system > Services. There you will see the properties of the system.

Get the host  name and service name/Port of the HTTPS

Input the Host name and the HTTPS Port copied from the SMICM

The New BW Live Connection is now created.

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 .

1.Create new Live Data Model: To create new Model using Live connection, choose Live Data Model.

2.Create Model from Live Data Connection: Enter the system type and Live connection and the Query

3.New Model: Once the Query is opened, Save the New Model

4.Create new Story using existing Model by clicking Stories > Canvas > Table > Choose Existing Model.

5.SAP Analytics Cloud Story using Table: The data from PaPM can be displayed using SAP Analytics cloud.


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!

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Romuald COLLETAZ
      Romuald COLLETAZ

      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,


      Author's profile photo Cindy Jia
      Cindy Jia

      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,


      Author's profile photo Akshay Georaikar
      Akshay Georaikar

      Hi Cindy,


      Yes, you can do that. Please check below blog.


      Thanks & Regards,

      Akshay Georaikar