Exclude Component with multiple values

Questions & Answers
,
1

Imported component as a field using script given in this link:

https://docs.eazybi.com/eazybijira/data-import/custom-fields/javascript-calculated-custom-fields#JavaScriptcalculatedcustomfields-Component

After that, for my requirement, to exclude issues with component A,
I’ve created this calculated member in the imported component dimension.

Aggregate(
   Except(
     [Component].[Component].Members,
     { [Component].[Component].[A]
       }
   )
 )

Thing is I’m not able to exclude issues that has multiple components including component A. Can anyone help me with the query?

2

Hi @Sarath

You could try creating a calculated measure in “Measures” dimension that would
calculate issues without component A using this code:

[Measures].[Issues created count]
-
(
[Measures].[Issues created count],
[Component].[A]
)

That should exclude issues that have component A regardless of any other components.

Martins / eazyBI support