How to show Parent link Summary

Questions & Answers
1

I’m creating a report to show the progress of the Initiatives (Parent link) but I’m not able to display the names of the Initiatives. Can someone help?

Screen Shot 2021-11-09 at 10.37.11 AM
Screen Shot 2021-11-09 at 10.37.11 AM1374×667 63.3 KB

2

Hi @Deepanshu_D,

There are several dimensions for the Advanced roadmaps. If you are looking for all the Initiatives, I would suggest you use the Advanced Roadmaps Initiative dimension which also would have an issue summary.

If this does not suit you, you can fetch the summary of Parent Link dimension member from Issue dimension with the following calculated member:

CASE WHEN NOT [Parent Link].CurrentHierarchyMember.Name MATCHES "All Parent Links|\(none\)"
THEN
ExtractString(
  [Issue].[Issue].GetMemberByKey(
    [Parent Link].CurrentMember.key
  ).GetCaption,
  ".*\-\d+\s(.*)", 1
)
END

Lauma / support@eazybi.com

3

Hey @lauma.cirule , It’s randomly skipping some of the Initiative Summary. Could you take a look? I

Screen Shot 2023-01-05 at 11.10.50 AM
Screen Shot 2023-01-05 at 11.10.50 AM1817×525 27.2 KB

appreciate any help you can provide.

4

Hi @Deepanshu_D ,

The formula uses the Issues dimension to get the summary of the Parent Link issue. I would check if you have issues missing the summary in the Issue dimension (you can use the Issue dimension search for this).

Lauma / support@eazybi.com