Dear Community,
I am trying to identify a solution for a problem I am facing in the EazyBI.
I’ll try to put down our requirement.
Issue types in scope:
Portfolio Epics (in Project A)
Bundles, Epics and Stories (Projects B,C,D,F)
Below is the linkage flow how these Issue types are linked:
Story >>Child of>> Epics >>Subordinate to>> Bundle(sometimes directly linked to Portfolio Epics) >>Subordinate to>> Portfolio Epic
We have already created a Issue Link called “Portfolio Subordinate to” that links Each Portfolio Epic in Project A to its children, children’s children and so on from the other projects.
we want to create some custom fields or Issue Link Dimensions that take the value from a specified field of each Portfolio Epic and pass it down the hierarchy based on the Issue Link “Portfolio Subordinate”
For example, a Portfolio Epic has a field called Area and the value in this field is Galaxy. Then the new custom field or the Issue Link Dimension should be created and this value should be passed down the hierarchy to all the linked issues. So when i apply the filter it should give me the respective count for Portfolio Epics, Bundles, Epics and Stories that satisfy the filter in the new custom field or the Link issue dimension.
I have been breaking my head for the past 3 weeks and no results. below is the code for the Hierarchy:
#Issue custom hierarchies Initiative-Theme-Portfolio Epic-Bundle-Epic-Story-Subtask
[jira.customfield_bundlesubordinateto]
name = “Bundle SubordinateTo”
outward_link = “subordinate to”
issue_type = “Bundle”
dimension = true
update_from_issue_key = “epic_key”
[jira.customfield_portfolio_epicsubordinateto]
name = “Portfolio Epic SubordinateTo”
outward_link = “subordinate to”
issue_type = “Portfolio Epic”
dimension = true
update_from_issue_key = “customfield_bundlesubordinateto”
[jira.customfield_themesubordinateto]
name = “Theme SubordinateTo”
outward_link = “subordinate to”
issue_type = “Theme”
dimension = true
update_from_issue_key = “customfield_portfolio_epicsubordinateto”
[jira.customfield_initiativesubordinateto]
name = “Initiative SubordinateTo”
outward_link = “subordinate to”
issue_type = “Initiative”
dimension = true
update_from_issue_key = “customfield_themesubordinateto”
[[jira.issue_hierarchies]]
name = “Initiative SubordinateTo”
all_member_name = “All issues Full hierarchies link from Initiative till Story”
levels = [
{name=“Initiative SubordinateTo”,key_column=“customfield_initiativesubordinateto”,issue_type=“Initiative”},
{name=“Theme SubordinateTo”,key_column=“customfield_themesubordinateto”,issue_type=“Theme”},
{name=“Portfolio Epic SubordinateTo”,key_column=“customfield_portfolio_epicsubordinateto”,issue_type=“Portfolio Epic”},
{name=“Bundle SubordinateTo”,key_column=“customfield_bundlesubordinateto”,issue_type=“Bundle”},
{name=“Epic”,key_column=“epic_key”},
{name=“Parent”,key_column=“epic_parent_key”},
{name=“Sub-task”,key_column=“subtask_key”}
]
#------End of HL All Hierarchy-------------
and Below is the code that i created for the Issu Link Dimensions:
[[jira.issue_link_field_dimensions]]
name = “Portfolio Component”
source_dimension = “Component”
issue_id_column = “customfield_portfolio_epicsubordinateto”
group = “Linked issue dimensions”
[[jira.issue_link_field_dimensions]]
name = “Portfolio Product Area”
source_dimension = “Product Area (multi)”
issue_id_column = “customfield_portfolio_epicsubordinateto”
group = “Linked issue dimensions”
[[jira.issue_link_field_dimensions]]
name = “Portfolio Implimentation Layer”
source_dimension = “Implementation Layer”
issue_id_column = “customfield_portfolio_epicsubordinateto”
group = “Linked issue dimensions”
[[jira.issue_link_field_dimensions]]
name = “Epic Implimentation Layer”
source_dimension = “Implementation Layer”
issue_id_column = “epic_id”
group = “Linked issue dimensions”
[[jira.issue_link_field_dimensions]]
name = “Portfolio Fix Version”
source_dimension = “Fix Version”
issue_id_column = “customfield_portfolio_epicsubordinateto”
group = “Linked issue dimensions”