Inserting a Hyperlink for a measure "Issue Depends on"

Questions & Answers
, ,
1

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

2

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