SAP ALM Analytics: SAP Cloud ALM Tasks Dashboards

[Xavier]

Goal of this blog post

In this blog, we will create panels displaying analytics for Tasks entities managed by SAP Cloud ALM with the 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 Tasks Data Provider

The ALM Tasks data provider supports the following dimension:

Dimensions	Description	Filter
name	Task Name	yes
taskGUID	Internal GUID of the task
project	project of the Task	yes
project name	Project Name
scope	scope ID	yes
scope name	Scope of the Tasks
status	Task Status	yes
statusText	Text of the Task status
phase	Current Phase	yes
role	Assigned Role	yes
type	Task Type Text
typeID	Task Type ID
priority	Priority	yes
assignee	Assignee
dueDate	Due data of the task
timeboxName	TimeBox of the task
counter	Task counter (Measures)
storyPoint	Story Point (Measures)

 

Query

From your Grafana instance, create a query for each Tasks Status to display in your dashboard: Open, In Progress, Done,...

• Select your SAP Cloud ALM “Data source”.


• Select “Time-Series” format.


• Select data provider: “ALM Tasks”


• Select the name of your project.


• Select the name of your scope.


• Select the status to be filtered.


• Select the following dimensions:
  
  
  
  • StatusText
  
  
  
  

 

 

KPI Visualisation

Select the "Stat" visualisation for each of your query with the following settings:

• Thresholds: Adapt the thresholds to your requirements.


• Query Options: Select "now/d" in the "relative time" query options.

 

 

Burn-up Visualisation

 

Select the "Time Series" visualisation with the corresponding projects timeframe.

• Query Options: Select "6M" in the "relative time" query options.

 

Table Visualisation

 

Add the following Dimensions to your query to select which columns to display in the table:

 

Select the "Table" visualisation with the following settings:

• Value Mappings: Customise color coding for task priority and status.

 

• Data Links: This option opens the SAP Cloud ALM Tasks details of your SAP Cloud ALM tenant.

 

 

 

In the next blog, we will explain how to use variables to navigate between projects and tasks dashboards.

 

Thanks for reading.