Skip to Content
Technical Articles
Author's profile photo Sunny Kapoor

Interactive Reporting Dashboard for SAP Cloud Integration using SAP Analytics Cloud

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.
  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.

 

 

Assigned tags

      26 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Naresh Dasika
      Naresh Dasika

      Hello Sunny,

      Thanks a lot for writing the blog on this topic. This really helps in getting the required metrics related to Interface message processing from SAP CPI.

      With the trail account, I couldn't find option "Content Network" under "Browse". Can you please clarify whether it is visible from the trail account or not?

       

       

      Regards,

      Naresh Dasika

      Author's profile photo Sunny Kapoor
      Sunny Kapoor
      Blog Post Author

      Hi Naresh Dasika ,

       

      I don't think content network is available for SAC trial accounts.

       

      Regards,

      Sunny

      Author's profile photo Radar Lei
      Radar Lei

      Hi Sunny Kapoor,

      Good to here that to have such analytics information in the analytics cloud.

      For the analytics information, is there some detail or sumary data regarding the IFLow processing times such as maximum processing time, everage time etc?

      In addition, for the deployment part, for the same IFlow might be re-deployed with the same version or with different version, could such information also be there?

      Thanks and Regards,

      Radar Lei

      Author's profile photo Sunny Kapoor
      Sunny Kapoor
      Blog Post Author

      Hi Radar Lei

       

      The source of information for this SAC dashboard is CPI OData APIs.I think the extra information you are looking for can be achieved by consuming the right APIs and the required features of SAC.

      I request you to explore the available CPI OData APIs and then you can extend the dashboard accordingly.

       

      Regards,

      Sunny

      Author's profile photo Manuel Lopez
      Manuel Lopez

      Hi Sunny Kapoor,

      First of all, thanks a lot for your post, very interesting and useful one.

      I was able to connect the SAC Dashboard with a CPI instance (both running on CF environment) and everything looks perfect except from data model SAP__ALL_GEN_IM_CPIRUNTIMEARTIFACTS which can't be refreshed:

       

      Everything else looks ok and SAC story was updated with proper data except from artifacts information.

      Have you ever faced this issue?

      Many thanks in advance

      Manuel

      Author's profile photo Sunny Kapoor
      Sunny Kapoor
      Blog Post Author

      Hi Manuel Lopez ,

       

      I have not seen this issue before. Are you getting this error on the Cloud Foundry tenant?

      Have you tried the same with any other neo tenant?

       

      Regards,
      Sunny

      Author's profile photo Manuel Lopez
      Manuel Lopez

      Hi Sunny Kapoor

      Yes, I'm getting this issue on the Cloud Foundry tenant.

      Same issue when trying to fetch data from SAC running on NEO from CPI running on CF. Unfortunately, I can't test with CPI running on NEO.

      Cheers.

      Manuel

      Author's profile photo Sunny Kapoor
      Sunny Kapoor
      Blog Post Author

      Hi Manuel Lopez

      The current dashboard is developed and tested using OData APIs on CPI tenant running on NEO environment and the error which you are getting is on CPI CF environment where IntegrationRuntimeArtifacts API is not available yet.

      It is in testing phase and most likely, it would be available by end of October.

      https://help.sap.com/viewer/42093f14b43c485fbe3adbbe81eff6c8/release/en-US/d95a6f35129449f98daa9c08f9071ac7.html

       

      Regards,

      Sunny

      Author's profile photo Sunny Kapoor
      Sunny Kapoor
      Blog Post Author

      Hi All,

       

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

       

      Regards,
      Sunny

      Author's profile photo Vishal Kulkarni
      Vishal Kulkarni

      Hi Sunny Kapoor ,

       

      Is the content available and applicable for SAC Embedded Edition as well?

       

      Regards,

      Vishal

       

      Author's profile photo Sunny Kapoor
      Sunny Kapoor
      Blog Post Author

      Hi Vishal Kulkarni,

       

      I don't think that SAC business content is available for Embedded Edition.

       

      Regards,

      Sunny

      Author's profile photo Nicole Bocibo
      Nicole Bocibo

      Hi,

      Thanks for article

       

      does a user require specific authorization rights to be able to  view the dashboard?

       

       

      thanks

      Author's profile photo Sunny Kapoor
      Sunny Kapoor
      Blog Post Author

      Hi Nicole Bocibo,

       

      Kindly check the blog post on SAP Analytics Cloud - Roles and Access Management

       

      Regards,

      Sunny

      Author's profile photo Colm Carroll
      Colm Carroll

      Hi Sunny,

      Are there any license implications or requirements we should be aware of before we set this up if we already have CPI and SAC tenants ?

      Thanks,

      Colm

      Author's profile photo Sunny Kapoor
      Sunny Kapoor
      Blog Post Author

      Hi Colm Carroll,

       

      If you can see this Business Content in SAC and able to import successfully then I don't think there is any license implications.

       

      But if you like to officially confirm this, kindly check with your SAP Account Executive.

       

      Regards,

      Sunny

      Author's profile photo Colm Carroll
      Colm Carroll

      Thanks Sunny, will do.

      Author's profile photo Madhav Poosarla
      Madhav Poosarla

      HI @Sunny,

       

      Can i customize the report, eg: if i wanted to extract only few set of interfaces to be available in the dashboard.

      is it possible?

       

      -Madhav

      Author's profile photo Sunny Kapoor
      Sunny Kapoor
      Blog Post Author

      Hi Madhav Poosarla,

       

      Yes, you can customize it as per your need. Kindly go through the SAC documntation to learn more about customizing SAC business content and various capabilities to achieve your usecase.

       

      Regards,

      Sunny

      Author's profile photo Kalyan Batabyal
      Kalyan Batabyal

      Hello Sunny,

       

      Could you please let me know what are my options if I want to connect multiple SAP CPI Tenants to the SAP Analytics Cloud.

       

      Regards,

      Kalyan

      Author's profile photo Sunny Kapoor
      Sunny Kapoor
      Blog Post Author

      Hi Kalyan Batabyal

       

      We have not evaluated this usecase yet. Once we have an update, will update you.

       

      Regards,
      Sunny

      Author's profile photo Aman Varshney
      Aman Varshney

      Hi Sunny Kapoor ,

      Thankyou so much for the blog.

      I tried with the steps but am stuck with the below error while refreshing the Odata services

      I have assigned Administrator rights and using Basic Authentication

      Any idea what can be missing?

      Author's profile photo Sunny Kapoor
      Sunny Kapoor
      Blog Post Author

      Hi Aman Varshney

       

      I am able to successfully import the content and establish the connection successfully in my SAC tenant.

      I think it has some other onfiguration issue. Kindly check the master KBA from SAC.

       

      Regards,

      Sunny

      Author's profile photo Rajasegaran Bhuvaneswari
      Rajasegaran Bhuvaneswari

      Error%20Screenshot%201Hi Sunny,

      Error Screenshot 1

       

      I am stuck with the same point. I am trying to configure my CPI Neo Environment with SAC.

       

      attached the screen shot for your reference.

       

       

      Author's profile photo Sunny Kapoor
      Sunny Kapoor
      Blog Post Author

      Hi Rajasegaran Bhuvaneswari

       

      I am able to successfully import the content and establish the connection successfully in my SAC tenant.

      I think it has some other onfiguration issue. Kindly check the master KBA from SAC.

       

      Regards,

      Sunny

      Author's profile photo Prakash Donda
      Prakash Donda

      Hi Sunny,

       

      This is very nice blog. I am able to follow the steps and is working great for us. My next thing is to see any updates coming to this package in the future or modify this package for our needs. Quick question, can analytics cloud save the data from CPI APIs locally, so we can get dashboards displayed for more period of time than the default one month data.

       

      Thanks

      Regards,

      Prakash

      Author's profile photo Sunny Kapoor
      Sunny Kapoor
      Blog Post Author

      Hi Prakash Donda,

       

      Thank you for your kind words.

      We have a new content package for SAP Intgeration Suite where we have packaged the dashboards for API Managment and the Cloud integration capabilities.

      Also if you have some more use cases for this dashboard, then you can simple extend it as well as per your requirements

      One of the advatnage of SAC dahboard is that it can display the hostorical data (more than 30 days) as it acquires the data from SAP Integration Suite via APIs and store it in the Hana DB of SAP Analytics Cloud. So the use case what you are saying is absolutely possible with SAC dashboard of SAP Integration Suite.

       

      Regards,
      Sunny

       

      Regards,

      Sunny