Linked Issue Hierachy across projects and issue type including sub-tasks

Questions & Answers
1

Hi eaziBI community
we are building a cross project planning board based on initiatives.

An initiative can be linked to any EPIC, New Feature, Bug or Story of any project which is related to the initiative using linked issue “part of initiative”.

Now we want to build rollup reports (estimation, hours spent etc) based on this structure

We have created following settings

[jira.customfield_initiative]
name = “Initiative”
outward_link = “part of initiative”
inward_link = “part of initiative”
issue_type = “Initiative”
update_from_issue_key = “parent_issue_key”
dimension = true

[[jira.issue_hierarchies]]
name = “Initiative”
all_member_name = “All Issues by initiative”
levels = [
{name=“Initiative”,key_column=“customfield_initiative”,issue_type=“Initiative”},
{name=“Epic”,key_column=“epic_key”},
{name=“Parent”,key_column=“subtask_parent_key”},
{name=“Sub-task”,key_column=“subtask_key”}
]

This is working except that the EPIC hierarchy is not working

Question:
How can we have following hierarchy defined in EazyBI

1-Initiative

**2-EPIC
***3-Story/Bug/Task
****4-Sub-Task
**2-Story, New Feature,Task, Story
***3-Sub Tasks

Many thanks for your feedback

Best regards
Peter

2

Hi @peter.reiser

You can’t have the hierarchy you are looking for defined in eazyBI. The reason is that an issue type can’t be defined in two levels at once in an Issue dimension hierarchy.

From the example you used, it looks like the Story, New Feature, Task issues can be in both 3rd level (when they are under an Epic) and in the 2nd level if they are linked straight to the Initiative.

You can define two separate hierarchies. One with “Epics” in the 2nd level and the other with “Parents” at the 2nd level.

You would need to create another [jira.customfield_initiative_2] dimension for the hierarchy with epics and use the parameter:

update_from_issue_key = “epic_key”

The hierarchy parameters could look similar to the ones below:

##Hierarchy without Epics
[[jira.issue_hierarchies]]
name = “Initiative”
all_member_name = “All Issues by initiative”
levels = [
{name=“Initiative”,key_column=“customfield_initiative”,issue_type=“Initiative”},
{name=“Parent”,key_column=“subtask_parent_key”},
{name=“Sub-task”,key_column=“subtask_key”}
]

##Hierarchy with Epics
[[jira.issue_hierarchies]]
name = “Initiative_2”
all_member_name = “All Issues by initiative”
levels = [
{name=“Initiative”,key_column=“customfield_initiative_2”,issue_type=“Initiative”},
{name=“Epic”,key_column=“epic_key”},
{name=“Parent”,key_column=“subtask_parent_key”},
{name=“Sub-task”,key_column=“subtask_key”}
]

Please read more about this on our documentation page - https://docs.eazybi.com/eazybijira/data-import/advanced-data-import-options/additional-issue-hierarchies.

Best,
Roberts // eazyBI support

1 Like