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
