OR condition between 2 dimension

Questions & Answers
1

I want to extract data for below JQL-:
project = MSE AND (“program / project” = Production OR “Responsible Team” = caprdi-production-team)

Please help me to create a calculated member using or condition between dimensions program / project and Responsible Team.

Regards,
Madhvi

2

eazyBI applies AND condition by default for two dimensions selections. You would like to define calculated measures to get the desired results instead of using this selection in reports.

In this case, you can use arithmetical calculations for this:

([Measures].[Issues created],
 [program / project].[Production])
 +
([Measures].[Issues created],
 [Responsible Team].[caprdi-production-team])
-
([Measures].[Issues created],
 [program / project].[Production],
 [Responsible Team].[caprdi-production-team])

The formula counts all created Production issues and All Responsible team issues and removes duplicate issues if the same issue is both production and for the particular team.

If there are many scenarios where you would need to use this selection you can consider defining a new dimension with value in those issues if they have any of the selection. Here is a training video I did in community days on this (use case 2).

Daina / support@eazybi.com

1 Like