How SAP Analytics Cloud (SAC) pulls data from SAP Profitability and Performance Management Cloud (SAP PaPM Cloud)

In one of my previous blogpost, How to setup Model View OData, you learned how to configure and consume data from SAC with the aid of the public API Endpoint Fact Data. Now I am here again to provide how you can do it the other way around.

SAP PaPM Cloud as calculation engine flexibly gives users with the desired processed data which results from modeling configuration. Users in turn would want to use these processed data as data source for applications such as SAC. In SAP PaPM Cloud, Query Function is mainly used as entry point in order to arrange the processed data in such a way that it can be used for Reporting via Client Side Simulation. These Query Functions when activated also generates several artifacts of which two of them will be used in this blogpost namely: Temporary Tables (Ytable) and Calculation Views. Consumption of these generated artifacts for Story creation or further reporting purposes in SAC is now made possible through:

a) OData Connection (Temporary Tables)

b) HANA Live Connection (Auto Generated Calculation Views)

Let’s go ahead and journey with me on the needed steps to achieve these integration.


Pre requisites:

In Modeling Environment of SAP PaPM Cloud, Query function has been activated successfully.


a) OData Connection (Temporary Tables)

On Application level, buffer or temporary tables are used to access data which users can see in the Show Screen. These temporary tables have corresponding OData endpoint equivalent which can be used as data source in building scenarios in SAC. In order to achieve this, you may follow the guide below after logging in to SAC.

Procedure:

  1. Choose Connections in the lower left corner of the screen
  2. Choose Add Connections
  3. In the screen which appears, search for OData Services. Remain in the screen while getting information of the needed credentials in the next steps.
  4. Login to Business Technology Platform (BTP) using the global account and get credentials from the service keys information of the space given by the following steps:

4a. Choose the subaccount and go to the space

4b. On the left panel, Choose Services -> Instances then search for ‘API’. Choose papm-cloud-api-papm-default

4c. On the lower right side choose Service Keys Name

4d. Take note of the service key information of client id and client secret.

  1. Go back to SAC webpage and fill in the required connection information then choose Create.
Connection Name Text Description of Odata Connection without spaces
Data Service URL https://papm-cloud-api-<space>.cfapps.<region>.hana.ondemand.com/sap/opu/odata/NXI/P1_N_APP_ODATA_SRV/Data/<enviroment>/<version>
Authentication Type OAuth 2.0 Client Credentials
OAuth Client ID Client ID from Service keys without “
Secret Client Secret from Service keys without “
Token URL https://<subaccount>.authentication.<region>.hana.ondemand.com/oauth/token
  1. In SAC, go to DataSet -> Choose From a Data Source -> Choose OData Services
  2. Select the created OData Connection in the dropdown then choose Next.
  3. Users can select from the list of Ytables and new Query can now be built in SAC for scenario analysis purposes.

b) HANA Live Connection (Auto Generated Calculation Views)

Calculation views can now be generated in SAP PaPM Cloud and stored in HDI Container in a provisioned HANA Database. Further information has been laid out by one of my colleagues through the release of Blogpost: SAP PaPM Cloud: What’s New as of 2022-06-30?

Once you are logged in into SAC, I will show you the steps on how to configure the connection in order to use of this generated artifact.

Procedure:

  1. Choose Connections
  2. Choose Add Connections
  3. Tick Data Source Type: Cloud and Search for SAP HANA
  4. Fill up information in the page which appears
Name Text Description of HANA Live Connection without spaces
Connection Type SAP HANA Cloud
Host a) Database Host information where HDI Container resides.
User Name b) Database Username
Password c) Database Password

--NOTE: In case users with proper authorization are unable to select the contents of calculation views,
--do remember to check the privileges of SAP_PAPM_ADMIN.
--Users can revisit the Application Help guide for these privileges : GRANT SELECT ON SCHEMA SAP_PAPM_ADMIN TO SAP_PAPM WITH GRANT OPTION;
--or
GRANT ALL PRIVILEGES ON SCHEMA SAP_PAPM_ADMIN TO SAP_PAPM WITH GRANT OPTION;
  1. In SAC, Choose Modeler button then choose Live Data Model
  2. Fill in the information by selecting SAP HANA as System Type and your created connection as Connection. Choose the F4 help button to display the list of Calculation Views.
  3. Calculation Views generated by SAP PaPM Cloud is now possible to be used as data source in SAC.

Hooray! You reached the end. Now, you are better equipped and you are able to answer two integration points of SAC to SAP PaPM Cloud and vice versa.

  1. How does SAP PAPM Cloud pulls data from SAC?
    Answer: through SAC’s Public Export Data API where configuration is explained in How to setup Model View OData
  2. How does SAC pulls data from SAP PAPM Cloud?
    Answer: through a) Odata Connection and b) through HANA Live Connection

Onto the next! See you 🙂