Filter by Parent values

Hi everyone. I’m trying to filter records by their parent values, but not getting anywhere (0 results).

Can anyone help me understand what is wrong with this MDX?

    [Issue].CurrentHierarchyMember.Parent.get('Delivery Team') = 'Team1'


Hi @pgordalina,

The MDX calcaution might work if the individual issue is on report rows. I would not recommend making such aggregate calculations in the “Issue” dimension as this might affect report performance significantly.

In your case, importing the “Parent Team” as a separate dimension would be a more convenient and faster solution. In eazyBI advanced settings, you can define a new dimension to check on Delivery Team and pass this value down to child issues.

For more details please and code examples, please see this documentation page: JavaScript calculated custom fields.

Zane /