Issue link field dimensions
eazyBI for Jira
This page describes advanced JIRA and eazyBI integration. If you need help with this please contact eazyBI support.
Jira Software, Advanced Roadmaps, issue linking provides an option to build issue hierarchies in Jira and import new hierarchies into eazybi. Different fields could be managed on different hierarchy levels. This section describes an option to analyze data of lower levels, for example, time tracking, story points on stories, sub-tasks by fields on higher levels issues, for example, Epic Fix version. The same option could be used for single linked issue field analysis.
eazyBI supports building new dimensions for some Jira default fields (Fix Version, Label, Status, Resolution, Issue type, Priority) of linked issue, for example, Epic Fix version, Feature Label, etc.
If you would like to import linked field dimension into eazyBI you need to add the definition of this linked field dimension to advanced settings for custom fields.
At first, you need to give a name for this linked issue dimension, for example:
Then specify which Jira default field should be used, for example:
Now, you should set the reference to linked issue custom field
You can use ID column for default field Epic:
or key columns for any other custom field describing hierarchy level or one linked issue, for example, if you have custom field_feature with one linked Feature issue, you can use a reference to it:
Here are other options for
issue_key_column values using other default hierarchies:
issue_key_column = "subtask_parent_key"if you would like to get values from parent issues to sub-tasks
issue_key_column = "jpoh_parent_X"if you are using the Advanced roadmaps hierarchy and would like to get values in this hierarchy. Use a parent level number 1,2,3,.. instead of X counting parent levels on top of sub_tasks. 1 for story/standard issue level (jpoh_parent_1), 2 for epic level (jpoh_parent_2), 3 ...
then you can set a group in dimension selection:
Linked dimensions import and usage
After you have saved the advanced settings with linked field dimension definition then go to the Source Data tab and see if you have this dimension in the list of available linked dimensions in Additional options tab.
Select dimensions you need for data analysis for import in each account.
eazyBI builds link field dimensions with the same structure as default dimensions. They will have the same hierarchies and member structure as default dimensions. eazyBI support access to the same set of properties as default ones as well.
The example formula above retrieves release start date for Epic Fix version dimension members.
Epic Fix version
The example above describes how to analyze stories and sub-tasks based on Epic Fix version.
source_dimension in this case is Fix Version and you can use reserved ID field epic_id in
The example above describes how to analyze stories and sub-tasks based on Epic Status.
source_dimension in this case, is Status and you can use the reserved ID field epic_id in
issue_id_column. This definition is similar to the Epic Fix version, but the Status dimension is used instead of Fix version.
Parent Fix version
Similar to how to analyze stories based on the Epic Fix version, it can be done based on the Parent Fix version. In this case use
This example would work for Advanced Roadmaps hierarchy. Here we assume that Initiative is one level above Epic in the hierarchy.
See the chapter on the configuration above on how to use the right issue_key_column configuration here for Advanced Roadmaps hierarchy levels that you want to copy status values from to all levels below.
If you have a linked Feature grouping your Epics you can define it with Issue link import and then create a new dimension Feature Label enabling data analysis by Feature Labels in Epics, Stories, Sub-tasks:
The first definition describes issue link Feature. Then you can use the Feature custom field in
issue_key_column as a reference and specify field Label as