Cognos Analytics

 View Only
Expand all | Collapse all

Hyperlink data items in dashboard

  • 1.  Hyperlink data items in dashboard

    Posted Fri February 10, 2023 05:22 AM

    In a report we are able to add a hyperlink item, to change an url to external content  based on our data. This looks like this:

    Report sample
    How can we obtain the same result in the dashboard module? We can show the url in a table, but then it's not clickable. The webpage widget only supports a static link.
    Sample dashboard - not clickable



    ------------------------------
    JH Struik
    ------------------------------


  • 2.  RE: Hyperlink data items in dashboard

    IBM Champion
    Posted Mon February 13, 2023 05:17 AM

    Hi, As far as I know there is no according out-of-the-box functionality for this. Static links can be added by this extension (hopefully IBM will integrate it one day):  https://community.ibm.com/accelerators/catalog/content/Dashboard-widget-to-create-link-buttons-(11.1.7-FP2-and-above) I'm sure there are more extensions, maybe ones with URLs conditional on data. Without extensions you could use a drillthrough to a report showing external HTML with an iframe (HTML item). 



    ------------------------------
    Philipp Hornung
    Business Intelligence Manager
    Techniker Krankenkasse
    Hamburg Germany
    #IBMChampion
    ------------------------------



  • 3.  RE: Hyperlink data items in dashboard

    Posted Wed February 15, 2023 11:05 AM

    We used drill-through to a Cognos report with javaScript, which redirects to the url OnLoad.

     

    Not ideal, but works well.

     

     




    This email has been scanned for email related threats and delivered safely by Mimecast.
    For more information please visit http://www.mimecast.com





  • 4.  RE: Hyperlink data items in dashboard

    IBM Champion
    Posted Mon February 13, 2023 09:15 AM

    It looks like your data is fully formed HTML. Are you looking to embed that into the dashboard? And if so, do you have other fully formed HTML you would want to embed?

    Do you have separate URL and label fields? 



    ------------------------------
    Paul Mendelson
    ------------------------------



  • 5.  RE: Hyperlink data items in dashboard

    Posted Mon February 13, 2023 01:53 PM

    We are indeed looking to embed URL's in the dashboard. The fields aren't fully formed html tags, just the url's. The html is an additional calculated field in the data module. We have the URL and labels in seperate fields. At the moment, this is the only need for fully formed html in the dashboards



    ------------------------------
    JH Struik
    ------------------------------



  • 6.  RE: Hyperlink data items in dashboard

    Posted Wed September 06, 2023 10:34 AM

    Hi, I actually found a way how to do it.. I have a field with the url as a field in data module. In dashboard I have a table that includes this field. Selecting the table and going to "Actions" in top right corner

    As Action select "Open link in new tab" and Action Trigger "Data point double click"

    Double click on the url in the Table opens the website in a new tab... There's one extra setting - the field with the url needs to be the first column in that Table, otherwise the feature concatenates all field prior to the url field in to one, which gives an error in the end... 

    Try this out



    ------------------------------
    Gabriel Poliačik
    ------------------------------



  • 7.  RE: Hyperlink data items in dashboard

    Posted Thu September 07, 2023 08:33 AM

    Hi Gabriel

    I am correct to assume your working with CA 12 ?



    ------------------------------
    JH Struik
    ------------------------------



  • 8.  RE: Hyperlink data items in dashboard

    IBM Champion
    Posted Thu September 07, 2023 02:58 AM

    Hi JH

    I build a HTML list visualization for the purpose, you can customize it, after your needs. 

    You can find the custom visualization on our website :

    Html table - visualisering i Cognos Analytics (cognitech.dk)

    #IBMChampion



    ------------------------------
    René Kent Nielsen
    Brand manager
    CogniTech A/S
    Herning
    ------------------------------



  • 9.  RE: Hyperlink data items in dashboard

    Posted Thu April 11, 2024 08:57 PM

    Hello, Can you help me with HTML for 10 columns?



    ------------------------------
    Okoye Emmy
    ------------------------------



  • 10.  RE: Hyperlink data items in dashboard

    IBM Champion
    Posted Tue April 16, 2024 08:26 AM

    Hi,

    You can add the xtra columns needed in the vizdef.xml file

    Br



    ------------------------------
    René Kent Nielsen
    Brand manager
    CogniTech A/S
    Herning
    ------------------------------