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.
Showing results for 
Search instead for 
Did you mean: 
Product and Topic Expert
Product and Topic Expert

Goal of this blog post

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

This plug-in lets you extend your analytics solutions for application life-cycle management. This plugin is based on the SAP ALM analytics API. The main concepts of the SAP ALM Analytics API can be found in this blog.



  • 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 Tests Execution Data Provider

The ALM Tests Execution data provider supports the following dimension:

Dimensions Description Filter
project project of the test execution yes
projectName Project Name
scope scope ID yes
scopeName Scope of the test execution
status test execution Status yes
type type of the test yes
testcaseID ID of the test case yes
testcaseName Name of the test case
total counter (Measures)




From your Grafana instance, create a query for each project to be displayed in your dashboard:

  • Add a Panel

  • Select your SAP Cloud ALM “Data source”.

  • Select the “Table” format.

  • Select the data provider: “ALM Test Executions

  • Select the name of your project.

  • Select the name of your project scope

  • Select the following dimensions:

    • status




Select the "Pie Chart" visualisation with the following settings:

  • Query transformation: Select the "Rename by regex" transformation to remove the measure name of the time-series legend.


  • Query Options:

    • Select “6M” as relative time option in the “Query Options” panel.




The result will show a time series chart displaying the progress over weeks for test executions status for a given project, scope combination managed in your SAP Cloud ALM instance.



In the next blog, we will create a panel displaying Health Monitoring analytics.


Thanks for reading.