I am creating a dependencies tracker and would like to insert a hyperlink for both the issue and the “issue depends on” measure.
This is what i have so far, i created a hyperlink using the query below but i am struggling with creating a hyperlink for the measure.
CASE WHEN
[Issue].CurrenthierarchyMember.level.name = "Issue"
THEN
"[*"
||Cast([Issue].CurrentHierarchyMember.Key as string)
||"*]"
||"(https://jira.site.gs.com/browse/"
||Cast([Issue].CurrentHierarchyMember.Key as string)
||")"
END
The query i am trying to use for the “issue depends on” measure is below:
CASE WHEN
[Issue].CurrenthierarchyMember.level.name = "Issue"
AND
[is a dependency of].CurrentMember IS [is a dependency of].DefaultMember
THEN
"[*"
||Cast([Measures].[Issue depends on].CurrentMember.Key as string)
||"*]"
||"(https://jira.site.gs.com/browse/"
||Cast([Measures].[Issue depends on].CurrentMember.Key as string)
||")"
END
Please help