SAP ALM Analytics: SAP Cloud ALM Defects Dashboards

[Xavier]

Goal of this blog post

In this blog, we will create a simple panel displaying analytics for Defects entities 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 Defects Data Provider

The SAP Cloud ALM Defects data provider supports the following dimension:

Dimensions	Description	Filter
name	Defect Name	yes
GUID	Internal GUID of the defect
project	project of the defect	yes
projectName	Project name
scope	scope ID	yes
scopeName	Scope of the defect
defectStatus	defect status	yes
statusText	Text of the defect status
role	Assigned role to the defect	yes
priority	Priority	yes
team	Team assigned to the defect	yes
dueDate	Due date of the defect
testCaseId	Test case ID	yes
testCaseName	Test Case Name
workstream	workstream of the defect
counter	Defect 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 “Time Series” format.


• Select the data provider: “ALM Defects”


• Select the name of your project.


• Select the name of your project scope


• Select the following dimensions:
  
  
  
  • statusText
  
  
  
  

 

 

Visualisation

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

• Query transformation: Select the "Rename by regex" transformation to remove the measure name of the time-series legend. (Note: When multiple series are returned for a drill-down the name of the measure is automatically added to the name of the time-series).

 

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

 

 

Result

The result will show a bar chart displaying the progress over weeks for defects status for a given project managed in your SAP Cloud ALM instance.

 

 

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

 

Thanks for reading.

[Rodion]

Hi xavier.deprat. Thanks for the post.

It seems that currently there is no way to see the link between Defect and Test Execution is it correct?

I.E. Customer would like to start prioritizing developer work before go live. To drive the test script completion percentage up. However they cannot seem to be able to run reports from CALM that show the ID of the defects linked to a failed script.

[Xavier]

Hello,

The DP_DEFECTS (https://help.sap.com/docs/cloud-alm/apis/defects-analytics-api) and the DP_TESTS (https://help.sap.com/docs/cloud-alm/apis/test-management-analytics-api) can be linked by the TestCaseId Dimension.