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.
cancel
Showing results for 
Search instead for 
Did you mean: 
Xavier
Product and Topic Expert
Product and Topic Expert
0 Kudos
In this blog, we will create a panel displaying the status of selected projects 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 Projects Data Provider


The ALM projects data provider supports the following dimension:




























Dimensions Description Filter
name Name of the project yes
projectGUID Internal GUID of the project
Status Status of the project (On Track, Needs Attention, Critical) yes
State State of the project (Active, Hidden) yes

 

 

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 Projects”

  • Select the name of your project.

  • Select the following dimensions:

    • Status,

    • Name,

    • State,

    • ProjectGUID.





 

Visualisation


Select the "Table" visualisation with the following settings:

  • Value Mapping: Mappings change the display treatment of data that appears in a visualisation.



 

  • Query transformation: Transformations manipulate the data returned by the query to change the display of the visualisation.



 

  • Query Options:

    • Select “now/d” as relative time option in the “Query Options” panel to restrict dataset values to the latest available content.





 

 

Result


The result will show a table with the current state and status for each of the selected projects managed in your SAP Cloud ALM instance.


 

 

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

 

Thanks for reading.