Exclude Component with multiple values

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


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

     { [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?

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],

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

Martins / eazyBI support