EazyBI calculated member

Question

I need help with putting together an EazyBI calculated member to show the sprint date of a dependency.

For example: Issue 1 depends on issue 2. I would like to show Issue 2 sprint date/name in the row for issue 1 showing that linkage.

On the same topic, is there a way to show the dependency due date pulled from issue 2?

Daina Tupule eazyBI · Answer

Hi @Roman Osatinski

You would like to import linked issues into eazyBI. While eazyBI supports linked issue import, you would like to specify what linked issues you would like to import. You can define several linked issue imports for different scenarios.

See our documentation on linked issues and this eazyBI community tips and tricks post for issue linking describing link import in more detail.

After import, you can address those linked issues in your reports. You might need formulas for this.

Here are example formulas to get the sprint and due date from a linked issue. Both examples will use a default imported link value - representing the parent issue for the sub-task.

Parent Sprint

[Issue].[Issue].GetMemberByKey([Issue].CurrentHierarchyMember.get('Parent issue key')).Get('Sprint')

Parent due date:

[Issue].[Issue].GetMemberByKey([Issue].CurrentHierarchyMember.get('Parent issue key')).GetDate('Due date')

The formulas might be more complex if you have several linked issues (imported with option multiple_values = true). You can check out  example formulas based on the multiple-values link field Bugs (representing linked Bugs to stories). In this case, you would like to show all values or the last/first value based on some rules. You would like to replace the link field name Bugs

In the formulas above, Parent issue key represents the link field name, the example reports in our demo training account use link field Bugs. You can use any of the examples, remember to switch to your field names. Please use MDX autocomplete to fill in any field names.

Daina / support@eazybi.com

Fabian Lim · Answer

Hi @Roman Osatinski

You can find some good examples on the second point here: https://community.eazybi.com/t/report-linked-issues-of-any-type/149

For the first one it's possible as well and if you are paying for the subscription, contact their support team and they will help you.