Hi experts,
This time I want to share my experience between the SAP PO B2B add-on & SAP Analytics Cloud, we’ll see how you can execute analytics on your B2B messages from SAP PO to get the following results:
The concept is:
- Extract B2B data from SAP PO: using a SOAP WebService
- Publish an OData V2 service in CPI: using an OData service artifact in SAP CPI via cloud connector to use our B2B SOAP WebService extractor as a existing data source
- Analyse the B2B data in SAP Analytics Cloud: using SAP Analytics Cloud via a model consuming the B2B OData service extractor
So, let’s begin:
1.Extract B2B data from SAP PO
if you were following my latest blogs related with the SAP PO B2B add-on( part-1 & part-2) then you should know that the dynamic properties are the cornerstone of the SAP PO B2B add-on, and you can use them for your analytics via user defined search:
- Using UDS for TPM runtime data is described here
- All the parameters exposed by the SAP PO B2B add-on are here
- The procedure to configure UDS is described here
B2B message monitor:
After that you configured the UDS, you will find a new tab in the message details, with the attributes that you want to use for analytics:
To extract the UDS attributes you can use the standard SOAP WebService called “AdapterMessageMonitoring” operation “getUserDefinedSearchMessages”:
As you can see you must to specify all the fields that you want to extract and the value, you can noticed that using the value “*” you will search for all the values 
, but the response message is not so “friendly”, for that reason I created a simplified service interface hidden all the mandatory parameters and restructuring the response message:
And finally you can get the WSDL file from the B2B SOAP WebService extractor:
2.Publish an OData V2 service in CPI
In SAP CPI you can create an OData service artifact to expose your B2B SOAP WebService extractor as an OData service:
The detailed procedure is described here
After run the wizard using WSDL file exported previously from SAP PO you will see the EDMX file:
You need to map the SOAP WebService “Operation” to the OData “action”:
And finally you can perform small adjustments to the auto generated Iflow like mappings and adapter configuration:
Deploy the OData Service artifact:
3.Analyse the B2B data in SAP Analytics Cloud
Now that we have our B2B OData service extractor we can use it as a source for our model in SAP Analytics Cloud and build “Stories”:
First we create a connection to SAP CPI:
We fill all the data of our deployed B2B OData Service extractor:
It’s time to create a model using as a data source our B2B OData service extractor:
After that you created the model, you can run an import to get all the data from our SAP PO system:
Finally you can create a Story using our model to perform analytics on the B2B data:
Not forget be curious!
Max.
Original Article:
https://blogs.sap.com/2020/05/22/sap-po-b2b-add-on-heart-sap-analytics-cloud/