Technical Articles
SAP ALM Analytics: SAP Cloud ALM Test Executions Dashboards
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:
| 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) |
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 Health Monitoring analytics.
Thanks for reading.