Connect 2 projects by 1 almost common field

Questions & Answers
1

Hi.
I have 2 projects imported into EazyBi:

  1. BUSINESS, with key, BUSINESS-xxx
  2. IT, with key IT-xxx

Then, i have fields in it:

1. BUSINESS

  • Busisness Area (custom field not available in IT project, so not shared/common)
  • and many others customs for business

2. IT

  • Team (Tempo)
  • Logged by Team (Tempo)
  • Epic Link
  • BusinessID custom field, where we have almost same key inserted by Automation, as BUSINESS project Key. This is for purpose of creating relation.
    Example: when in project=BUSINESS and Key=“BUSINESS-1111”, then in project=IT we have BusinessID=“*IT_*BUSINESS-1111”.

I’m able to show amount of time logged, lets assume on Epic level. But im not able to show time logged in IT project, by some fields from Business project.

What i need to do, is

  • present business areas (fields from business projects)
  • show teams which logged time on IT project, on Epics (all issuetypes) (data from it projects)
  • show amount of time logged by each team (data from it projects)

What i’m not able to do, and need your help is to somehow connect data from 2 projects. I see 1 field is ALMOST common for projects around organization:
BUSINESS project Key=“BUSINESS-1111”, and BusinessID=“IT_BUSINESS-1111”.

I want to find solution in EazyBi, not in Jira.

Is it possible?

2

This problem is stil valid for me, if someone is able to help

3

Hi @paka,
​
​The solution would be to import the Business ID as a dimension and then you might address the values in the followinf way - iterate through Business project to dine the relevant Business project issues, ignoring the IT project specifics along the way.
​When the relevant Business project issues are identified, retrieve the aggregated values from IT project, but now ignore the Business project specifics.
​
​The expression might look as follows.
​

Sum(
--retrieve Business project relevant issues  
  Filter(
   [Issue].[<Business project>].Children,
   ([Measures].[Issues created],
--reset the dimensions form IT project
    [IT Project dimension 1].DefaultMember,
    [IT Project dimension 2].DefaultMember,
    [IT Project dimension 3].DefaultMember)>0
   ),
--numeric value for sum
   ( [<BusinessID dimension name>].[<BusinessID dimension level name>].GetMemberByKey(
       [Issue].CurrentMember.Key),
--now reset all Business project dimensions, including the Issue dimension
      [Issue].DefaultMember,
      [Business Project dimension 1].DefaultMember,
      [Business Project dimension 2].DefaultMember,
      [Business Project dimension 3].DefaultMember,
--actual measure from IT project
    [Measures].[<measure from IT project>])
)

regards,
​Oskars / support@eazyBI.com