Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Conditional drill through to externa link/url

    Posted Wed January 19, 2022 07:15 PM
    Hi Friends,

    I have a requirement where I need to create a conditional drill through on a column such that if the condition is not satisfied then the drill through link takes you to another report but when the condition is satisfied, the drill through link should take you to an external link/url. Additionally, I should also be able to pass the column value as parameter to  the url.


    Regards,


    ------------------------------
    Mack L
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Conditional drill through to externa link/url

    Posted Thu January 20, 2022 07:00 AM

    Mack L – my comments, on the assumption that you are using Report:

    -       To control the rendering of the link, you could use Variables to conditionally display an object (e.g link, text)

    -       To generate the URL and add additional parameters, pending on how you render (for example, in a list or just a one off text item, or a singleton), you could craft the link using a calculated query item or using Report Expressions

     

    Hope this helps. 

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Peter Chan

    613-295--0428

     




    Original Message


  • 3.  RE: Conditional drill through to externa link/url

    Posted Thu January 20, 2022 12:01 PM
    Thank you Peter.

    I am using calculated item within a HTML item to display the url. It is a list report.
    I am stuck with what syntax to be used for passing a data item to the external link.

    What I tried is like below:
    'https://cis.abc.defg.com/sss/bc/2ui/flp#Shell-startGUI?sap-ui2-tcode=ES62%20EVBSD-VSTELLE='+[Acc Number]+ '&sap-system=APG_MENU'

    In the above, [Acc Number] is the data item I am trying to pass to the url. Would like to know if the syntax is correct.
    If I get the syntax right and the url works with the data item passed, then I can use it within a HTML item to get it right. 



    regards,




    ------------------------------
    Mack L
    ------------------------------

    Original Message


  • 4.  RE: Conditional drill through to externa link/url

    Posted Thu January 20, 2022 01:32 PM

    Mack L – I believe I was incorrect in my first comment.  I ended up using a "Hyperlink" object instead.  Hope the screen shots and the report spec attachment comes through.  I created a sample report using the "Boston 311 Calls" data module (see IBM Samples).

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Peter Chan

    613-295--0428

     




    Original Message


  • 5.  RE: Conditional drill through to externa link/url

    Posted Fri January 21, 2022 07:48 AM
    Hi Peter,

    Thank you for the screenshots. I finally achieved the result using  calculated items and HTML item.
    It worked when I used the calculated item as data item value in the HTML tag.


    cheers!

    ------------------------------
    Mack L
    ------------------------------

    Original Message


  • 6.  RE: Conditional drill through to externa link/url

    Posted Wed July 24, 2024 10:56 AM

    I also have the same requirement but for crosstab , i.e. hyperlink and pass all dataitem values and parameters to the external link . Can you sent me the xml file of your report. 



    ------------------------------
    sumeet yadav
    ------------------------------

    Original Message


Related Content