Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Interactive Reporting Dashboard for SAP Cloud Integration using SAP Analytics Cloud

sunny_kapoor
Advisor
Advisor
‎08-26-2020 7:52 AM

Update: We have a new content package for SAP Integration Suite where we have packaged the dashboard for API Managment and the Cloud Integration capabilities, Kindly use the new package


 

SAP Cloud Integration is one of the key capability of SAP Integration Suite which support end-to-end process integration through the exchange of messages.The Cloud Integration reporting dashboard is built upon SAP Analytics Cloud (SAC) which is a powerful data acquisition application.

SAP Integration Suite Customers are actively looking for an intuitive and interactive reporting dashboard for their Cloud Integration tenant. This blog post helps you to start the analytics journey in SAC that is specific to SAP Cloud Integration. We assume that the reader is familiar with SAP Analytics Cloud and this blog post does not substitute SAP Analytics Cloud documentation, which can be found here: Help Portal: SAP Analytics Cloud.

This dashboard provides at-a-glance view of relevant key performance indicators of a Cloud Integration tenant using the intuitive and interactive widgets.The widgets in the dashboard displays data in a simple metric that helps you visualize the context information with slicing and dicing capabilities. The dashboard has a responive design and can be viewed on mobile devices as well.

Following are the key views of the dashboard:


  • Message Processing View





    • Visualize, sort, and track message processing happening on your Cloud Integration tenant. Here you can monitor the messages that are being processed by each integration flows and get to know the processed messages over a period. Besides monitoring, you can also get to know the deployment statuses of integration flows.






  • Deployed Artifact View




    • Reports the number of integration artifacts deployed based on the type of integration content.





  • Service Endpoints View





    • In this view, you can find the service endpoints distributed as per the API protocols.




This dashboard has one story and three data models, which is based on the relevant SAP Cloud Integration OData APIs.


 

How to activate the SAP Cloud Integration Reporting Dashboard content in SAP Analytics Cloud?



  1. Login to your SAP Analytics Cloud tenant.

  2. From the Main Menu, navigate to Browse > Content Network.

  3. Select Business Content tile.

  4. Select the business content package with the name SAP Cloud Integration Reporting Dashboard.

  5. An overview of the content appears. Go through it and then click Import.

  6. Click on the notification icon to view the content import progress.

  7. Once the content is imported successfully, you will be notified.Read the documentation for more details.

  8. To view all the imported packages, navigate to Browse > Files > Public > SAP_Content folder from the Main Menu.

  9. For the SAP Cloud Integration content, select the SAP_ALL_CPI folder.

  10. This would list a story and three data models. Please read the documentation for more details on data models.

  11. Click on the SAP__ALL_GEN_CPIREPORTING_DAQ story. The dashboard is made up of multiple pages with intuitive and interactive widgets. By default, the data displayed in the widgets is from a sample data.Note: Sample data is getting older by each passing day. Due to this, the data from the last 30 days(default days filter) may not be displayed in the Message Processing widgets. Increment the number of days in the Days Filter to get the view as given in the screenshot.


 

How to connect with your SAP Cloud Integration tenant?



  1. To establish the connection between SAP Cloud Integration and SAC tenants. In the Main Menu, choose Connection.

  2. Select the SAPCPI connection and then click Edit icon. You can connect to Cloud Integration OData APIs in SAP Analytics Cloud application either by using OAuth 2.0 Client Credentials (Recommended) or Basic Authentication.

  3. Configure the connection as described in the documentation.Kindly check the following documentation based on your Cloud Integration environment:

    OAuth Inbound Authentication with Client Credentials Grant for API Clients in CF environment


    OAuth Inbound Authentication with Client Credentials Grant for API Clients in Neo Environment



  4. Once you change the connection successfully, go to the Schedule Status tab and Refresh the two data models i.e. SAP__ALL_GEN_IM_CPIRUNTIMEARTIFACTS and SAP__ALL_GEN_IM_CPISERVICEENDPOINTS. This would delete the existing sample data and add new data in the data models.

  5. Click on the model SAP__ALL_GEN_IM_CPIMESSAGEPROCESSINGLOGS. Change the Import Settings to Clean and replace selected version data, this will delete the existing sample data while importing the new data.This is a one time activity to clean the sample data.

  6. Refresh the model data.

  7. Revert the Import Settings to Update. This will update the existing data and add new data in the data model going forward.

  8. By default, the scheduling frequency is set to None for all the data models. We recommend you to schedule a data import. See Updating and Scheduling Models for more details.


 

With this you have activated and configured the SAP Cloud Integration reporting dashboard on your SAC tenant. You can also use the other published SAP Cloud Integration OData APIs to extend the dashboard capabilities as per your requirements.

Note: This dashboard now works for both Cloud Foundry and Neo environment.


 


An Update for existing users of this dashboard who are getting an error in the model.


 

Note: This section is not for the new users who are planning to use this content for the very first time.

Note: Before consuming the fix make sure you export the data of SAP__ALL_GEN_IM_CPIMESSAGEPROCESSINGLOGS model to a file as a backup as explained here because there are chances that you would loose the existing data of the model.

It is not rquired to take the backup for the other two models as we clean and replace the data with every new import.

 

How to consume the fix?



  1. Login to your SAP Analytics Cloud tenant.

  2. From the Main Menu, navigate to Browse > Content Network.

  3. Select Business Content tile.

  4. Select the business content package with the name SAP Cloud Integration Reporting Dashboard.

  5. An overview of the content appears.

  6. Click on the Import Options tab, then select the Overwrite object and data and then click on Import

  7. Click on the notification icon to view the content import progress.

  8. Once the content is imported successfully, you will be notified.

  9. You need to re-enter the credentials of the Cloud Integration tenant in the SAPCPI connection.

  10. To view all the imported packages, navigate to Browse > Files > Public > SAP_Content folder from the Main Menu.

  11. For the SAP Cloud Integration content, select the SAP_ALL_CPI folder.

  12. This would list a story and three data models. Please read the documentation for more details on data models.

  13. Click on the SAP__ALL_GEN_IM_CPIMESSAGEPROCESSINGLOGS model. Then click on the Data Management tab.

  14. Under Import Jobs, you would see two entries. Delete the second entry with the problem.

  15. Refresh the model data and schedule it as described above.

  16. Do the same for SAP__ALL_GEN_IM_CPIRUNTIMEARTIFACTS model. Go back and click on the SAP__ALL_GEN_IM_CPIRUNTIMEARTIFACTS model. Then click on the Data Management tab.

  17. Under Import Jobs, you would see two entries. Delete the second entry.

  18. Refresh the model data and schedule it as described above.


 

With this you have successfully consumed the SAP Cloud Integration reporting dashboard fix.

 

 
54 Comments
Labels in this area
Popular Blog Posts