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