SAP ALM Analytics: SAP Cloud ALM Real User Monitoring Dashboards

[Xavier]

Goal of this blog post

In this blog, we will create 2 panels displaying analytics for Real User Monitoring data 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 Real User Monitoring Data Provider

The SAP Cloud ALM Real User Monitoring data provider supports the following dimensions:

Dimensions	Description	Filter
serviceType	Service type	yes
serviceId	Service id	yes
serviceName	Service name
requestType	Type of requests	yes
request	name of the request	yes
responseTime	response Time (Measures)
users	number of users (Measures)
requests	number of requests (Measures)
okStatus	number of requests with ok status (Measures)
warningStatus	number of requests with warning status (Measures)
criticalStatus	number of requests with critical status (Measures)

 

 

Query

From your Grafana instance, create a panel and add the following query:

• Select your SAP Cloud ALM “Data source”.


• Select the “Time Series” format.


• Select the data provider: “ALM Real User Monitoring”


• Select the filters:
  
  
  
  • serviceType
  
  
  • serviceId
  
  
  
  


• Select the following dimensions:
  
  
  
  • requestType
  
  
  
  


• Select the following dimensions:
  
  
  
  • responseTime
  
  
  
  

 

Add a configuration to select the 30 minutes resolutions:

 

Visualisation

Select the "Time Series" visualisation

Result

The result will show a time series chart with the response time per requests type for the selected services.

 

 

Query

From your Grafana instance, add the following queries:

query 1:

• Select your SAP Cloud ALM “Data source”.


• Select the “Time Series” format.


• Select the data provider: “ALM Real User Monitoring”


• Select the filters:
  
  
  
  • serviceType,
  
  
  • serviceId
  
  
  
  


• Select the following dimensions:
  
  
  
  • okStatus
  
  
  
  

query 2:

• Select your SAP Cloud ALM “Data source”.


• Select the “Time Series” format.


• Select the data provider: “ALM Real User Monitoring”


• Select the filters:
  
  
  
  • serviceType,
  
  
  • serviceId
  
  
  
  


• Select the following dimensions:
  
  
  
  • requests
  
  
  
  

Add a configuration to select the 5 minutes resolution:

 

Add a transformation "Add field from calculation" to compute the percentage of requests with an ok status:

 

Visualisation

Select the "Status History" visualisation

Result

The result will show a status history chart with the percentage of requests with good performance for your service or system.

 

In the next blog, we use the SAP Cloud ALM status events analytics data provider.

 

Thanks for reading.