Hi
I have a report which shows a table of issues that can be filtered on Epic Link.
Within a given epic I have Stories and sub-tasks - however, when filtering on Epic Link, I can only drill down as far as Story level.
In the example below Story ISD-523 has a sub-task - there is an icon to expand - but you cannot expand any further (if you see what I mean).
So, how can I filter on Epic Link all the way from the top to the bottom of the tree?
Is it because sub-tasks do not inherit the Epic Link of the parent Story? Is there a way around this?
image2016-7-25 9:42:0.png
Hi Graeme,
yes, you are quite right - it is because of sub-tasks do not inherit the Epic Link of parent Story. I could not imagine how to avoid this restriction using Epic Link dimension as a Page filter.
Issue dimension Epic hierarchy Epic level members are the same as Epic link members. Therefore, as a workaround, you could create a calculated measure returning the Epic level issue name for all Issue dimension Epic hierarchy level members (from epic itself to sub-tasks) and then filter by this column to get only particular epic with all its stories and subtasks.
The calculation for such a measure could be the following:
CASE WHEN [Issue.Epic].CurrentMember.Level.Name matches 'Epic|Parent|Sub-task' THEN Ancestor([Issue.Epic].CurrentMember, [Issue.Epic].[Epic]).Name END
For more detailed assistance, please, contact support@eazyBI.com .
Ilze,
eazyBI Customer Support Consultant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.