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

Question

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!

Gerda Grantiņa _ eazyBI · Answer

Hello @Samuel Srungarapati 
First you need to import the issue link dimension using account import options. You can do it by following the instructions provided in the eazyBI documentation.After you import the dimension, you will be able to use the issue property "Issue ISSUE LINK DIMENSION NAME" to see all the linked issues.

If you need to have any formulas on your linked issues, then you can check the formulas here. Copy the into your eazyBI account and replace "Bugs" with the actual name of you issue link dimension.
For example, use this to get the Linked bug count:

CASE WHEN --individual issues on report rows
  [Issue].CurrentMember.Level.Name = "Issue"
  AND
  [Bugs].CurrentMember is [Bugs].DefaultMember
THEN
  -- retrieve Bugs information from Issue property Bugs
  Nonzero(Count(
    [Issue].CurrentHierarchy.GetLinkedMembers('Bugs')
  ))

ELSE
 -- total calculation for any issue, data on Bugs level
  NonZero(Sum(
    Descendants([Bugs].CurrentMember, [Bugs].[Bugs]),
    -- counts how many times Bugs are reference with issues, this works as a filter as well
    [Measures].[Issues created]
 ))

END

Best,
Gerda // support@eazybi.com

Pasam Venkateshwarrao · Answer

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)
)