eazyBI allows importing additional properties for dimensions and creating custom hierarchies. In this example, I will walk you through how to define and import property Department for Assignee and build a custom hierarchy in the dimension Assignee. You can use the same steps to add more details for assignees or any other user dimension.
You can use eazyBI as a basis to create your data source. Create a new empty report in eazyBI. Use Transition Author as a dimension on Rows with measure Issues history. Any user dimension might work. We use Transition Author. It is a user dimension with the best coverage of all users that participated in issues imported in the account.
Create a new report specific measure to show user key:
Here is an example report for this step:
Export the report to excel.
In excel, you can remove users that are not needed, for example, old users. Remove the column issues history. Add columns with some details you would like to import for your users. For example, I added a column Department. Fill in values for each user in this column. Add the heading name for each column.
If you are missing some users, you can add extra rows with more users. Please be careful adding the user key, it should match Jira username case sensitive.
Here is an example excel file prepared for this.
The column Assignee name is used to show the real assignee names. It might be easier to understand what users you are importing and what values. While it could be used for mapping, it is not needed for this example. You can remove it before uploading data to eazyBI. Key column is more reliable in mapping. Therefore we will use key column for mapping only.
Select the Issue cube (top left corner, not visible in the screenshot).
Then make mapping for the column with User key and any additional column you added and would like to import as property.
Use the same dimension name and level for all columns, in my case, dimension Assignee, level User.
Specify a mapping column. We will use Assignee key column and setup: Key column and option Skip missing. eazyBI will use this column to match users by key and import property values from other columns. Skip missing option will ignore rows if the match for assignee is not found.
Set the property name for any other column you would like to import as property. I used property name Department for the column Department.
Run an import.
In eazyBI, expand the dimension Assignee, and in section, All hierarchy level members (1) use the option Add custom hierarchy (2) > select the needed property to build a new hierarchy. I used the property Department. eayzBI created a new hierarchy Department (3) in the dimension Assignee.
After this, you can use the new hierarchy for your report. For example, I used the hierarchy in the report on Pages to see assigned issues from department Development only.
Daina / firstname.lastname@example.org