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.

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

The ALM Tests Execution data provider supports the following dimension:

Query

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

Visualisation

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.

Result

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 status events analytics.

Thanks for reading.