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
Showing results for 
Search instead for 
Did you mean: 
Xavier
Advisor
Advisor

Goal of this blog post


In this blog, we will create a simple panel displaying analytics for Status Events entities managed by SAP Cloud ALM with the ALM Grafana plugin.

 




Pre-requisites



  • You have created a service key to your SAP Cloud ALM tenants (check this blog).

  • You should configure a Grafana data source connected to your SAP Cloud ALM tenant.

  • You have configured at least one project in your SAP Cloud ALM tenant. (check the SAP support portal)


 


ALM Status Events Data Provider


The SAP Cloud ALM Status Events data provider supports the following dimensions:














































































Dimensions Description Filter
type Service categories (CloudService, BusinessService, TechnicalSystem) yes
serviceType Type of the service yes
serviceName Name of the Service
serviceId ID of the service yes
serviceDescription Description of the service
eventType Type of Event (Maintenance, Disruption, Degradation) yes
eventName Name of the event yes
eventDescription Description of the event
eventStatus Event status (Open, In approval, In Process, Closed, Scheduled) yes
eventSource Event Source (SAP, Customer) yes
eventStartTime start time of the event
eventEndTime end time of the event
duration Duration of events(Measures)
counter Number of events (Measures)

 

Query


From your Grafana instance, create the following query in your dashboard:

  • Add a Panel

  • Select your SAP Cloud ALM “Data source”.

  • Select the “Table” format.

  • Select the data provider: “ALM Business Service Management

  • Select the following dimensions:

    • type

    • eventType



  • Select the following measures

    • counter

    • duration





Visualisation


Select the "Table" visualisation with the following settings:

  • Query transformation: Select the "Group by" transformation to group all values by type and event type. Select the "calculate" method for the selected measures.



 

  • Query transformation: Select the "Organisation fields" transformation to arrange and rename the table columns.



 


 

Result


The result will show a table displaying a summary for your business services status events summary for the selected period:



 

Query


From your Grafana instance, create the following query in your dashboard:

  • Add a Panel

  • Select your SAP Cloud ALM “Data source”.

  • Select the “Time Series” format.

  • Select the data provider: “ALM Business Service Management

  • Select the following filters:

    • eventType set to 'Maintenance'

    • eventStatus set to 'In Process'



  • Select the following dimensions:

    • eventType



  • Select the following measures

    • counter





 

 

Visualisation


Select the "Stat Chart" visualisation

 

Result


The result will show a stat chart with the current number of maintenance events in process.



 

 

 

Thanks for reading.

 

First blog of the SAP ALM Analytics blog series
1 Comment