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'
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.
Zane / support@eazyBI.com