Skip to Content
Technical Articles
Author's profile photo Xavier DUPEYRAT
Xavier DUPEYRAT
March 17, 2023 2 minute read

SAP ALM Analytics: SAP Cloud ALM Status Events Dashboards

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

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.