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
Hi @hariprasad,
I am sorry this topic was not discussed earlier; it was hidden in the Tips and Trick section.
The first expression to generate hyperlinks for the issue itself is correct and works well.
For the second expression, the syntax for [Measures].[Issue depends on].CurrentMember.Key
is not right, so the calculation does not work. You might want to address the issue property similarly as you got the issue key: [Issue].CurrentMember.Get('depends on')
.
Please use autocomplete to get the correct property name holding information on linked issue.
You may also combine both hyperlinks into one expression like this:
CASE WHEN
[Issue].CurrenthierarchyMember.level.name = "Issue"
THEN
--issue key in italic
"[*"
||Cast([Issue].CurrentHierarchyMember.Key as string)
||"*]"
--concatenate link to issue
||"(https://jira.site.gs.com/browse/"
||Cast([Issue].CurrentHierarchyMember.Key as string)
||")"
--concatenate information on dependency issue
||
CASE WHEN
IsEmpty([Issue].CurrentMember.Get('depends on')) OR
[Issue].CurrentMember.Get('depends on') = "(none)"
THEN --print the text
" has no dependancies"
ELSE -- text to divide both issue links and hyperlinks
||" depends on "||
--issue key in italic
"[*"
||Cast([Issue].CurrentMember.Get('depends on') as string)
||"*]"
--concatenate link to dependency issues
||"(https://jira.site.gs.com/browse/"
||Cast([Issue].CurrentMember.Get('depends on') as string)
||")"
END
END
Best,
Zane / support@eazyBI.com