Create a report of issues with more than 1 components

Questions & Answers
1

Hi team,
Can you please help me out in creating a report that shows only those issues that contains 2 or more components in them.

Thanks,
Simar

2

You would like to use an issue level calculation using MDX formulas to count components in issues. The best option would be using issue properites for this counter. However, eazyBI does not imports comonents as properties just yet. We are planning to release the option in the version 6.1.

Meantime you can use this calculation:

NonZero(Count(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    Sum(Filter(
      [Project].[Project].GetMemberByKey([Issue].CurrentHierarchyMember.parent.key).Children,
      [Project].CurrentHierarchyMember.Name <> "(no component)"),
      [Measures].[Issues created] 
    ) > 1
  )
))

The calcualtion might work slow or timeout in account with a large issue set. I will add an update to this post once the option with component properties will be released.

Daina / support@eazybi.com