How to pull Issue's linked issue details from a different project using EazyBI

[Samuel Srungarapati]

Hello,

I've been working with EazyBI reporting stuff.

There are issues in the project A which are linked with the issues from project B.

From project A's standpoint, I'm trying to build a report to list out all the open issues in A, along-with corresponding linked issues from project B.

Any help would be appreciated!

[Pasam Venkateshwarrao]

Hi @Samuel Srungarapati 

Please import both projects into the eazyBI and use the GetMemberByKey() function to get all the properties.

In Eazy Bi create a measure Linked issue by status count

Sum(
--go through all linked Bugs
Filter(
DescendantsSet([Bugs].CurrentMember,[Bugs].[Bugs]),
--check if linked Bug Priority matches selected Priority
DefaultContext((
[Measures].[Issues created],
[Issue].[Issue].GetMemberByKey(
[Bugs].CurrentMember.KEY),
[Status].CurrentHierarchy.CurrentMember
)) > 0
),
--aggregate linked Bugs ignoring the Issue Priority
([Measures].[Issues created],
[Status].CurrentHierarchy.DefaultMember)
)