Cluster components

Hello,

Our issues may have 0, 1 or several components. Let’s assume there are the components A, B, C and D.

I would like to create a calculated member of the project dimension that contains all issues that have the component A but do not have the component B.

I would also like to create a calculated member that contains all issues that have both components (A and B).

Many thanks for your help.

Kind regards,

T.

Hi @tomahawk,

Maybe you want to try another approach - creating the calculated members in the Measures dimension that iterates through all issues and counts only those issues that match the criteria. For example, to get the number of issues that have the component “A”, but don’t have the component “B”, you try the formula below:

NonZero(
Count(
  Filter(
    --iterate through issues
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    --which have component A
    ([Measures].[Issues created],
    [Project].[Component].[A]) > 0
    --and don't have component B
    AND IsEmpty(
      ([Measures].[Issues created],
      [Project].[Component].[B]) )
  )
))

The calculated measure will look for components in issues from every project imported in the eazyBI cube. If you are looking for a specific project, you can change the members of the Project dimensions in the formula to point to the particular project:

[Project].[PROJECT_NAME].[A]

For the number of issues that have both components, try to create another calculated measure similar to the one in the first step. Instead of putting the component “B” inside the IsEmepty() function, try to apply the same principle as for the component “A”.

Kind regards,
Roberts // eazyBI support