Need data of linked issues

[Spandhana]

Hi Team, 

I need a report from eazyBI cloud where column1( project-A key), column2;project A status),column3(linked issues of project-B key), column4(linked issue status) . I pulled report till here and they need columm5(linked issue project-B component), column6(project-B fix version), column7(project-B forecasted release date)

Tried in different ways but no luck. Can you please help on this. And issue links “is blocked by”.

Thanks in advance!

[Gerda Grantiņa]

Hello @Spandhana 

Here are the formulas; change the "Bugs" to the name you have for your linked issue dimension:

- columm5(linked issue project-B component)

[Project].[Component].getMemberNamesByKeys(
  [Bugs].CurrentHierarchyMember.get('Component IDs')
)

- column6(project-B fix version)

[Fix Version].[Version].getMemberNamesByKeys(
  [Bugs].CurrentHierarchyMember.get('Fix version IDs')
)

- column7(project-B forecasted release date)

[Bugs].CurrentHierarchyMember.Get('Due date')

When in doubt about how to correctly address the property, find the issue property in the Measures and copy the expression eazyBI has generated. Then, use the copied expression and replace [Issue] with the linked issue dimension name.

See more formula examples in our documentation: https://docs.eazybi.com/eazybi/learn-more/learn-eazybi-through-examples/mdx-formulas-for-issue-links-dimensions


Gerda // support@eazybi.com

[Pasam Venkateshwarrao]

Hi @Spandhana 

Welcome to the community,

Linked issue Data in EazyBI refer the doc issuelinks

Hope this helps