How can I match an user inside an Asset object with the information in Jira for a report?

Questions & Answers
, , ,
1

Hi, Im trying to create a report (Jira Cloud) with information of Assets and Jira. I have an Assets object: “IT users” and I need to show the information related to each users inside that Asset and also the data related to issues in Jira, (issues assigned, time spent…), but I dont know how to match the users.
Thanks

2

HI @blara

There are two main ways to import Assets data in eazyBI:

  1. As a separate source application - this allows importing all Assets data regardless of whether it’s directly connected to Jira issues
  2. As additional data to your Jira source via custom fields - this works for Assets data directly linked with Jira issues

For your specific use case where you want to combine user information from Assets with Jira issue data, here’s a recommended approach:

  1. Import Assets data into a separate data cube
  2. Create a report showing all users and their properties from Assets
  3. Use the report result REST API as a data source to map the Assets properties to users in your Jira cube
  4. Once mapped, you can use these properties to filter and analyze Jira data (issues, time spent etc.) by user attributes from Assets

This allows you to maintain the connection between Assets user data and Jira issue data while keeping both data sources separate.

Best regards,
Nauris