Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  PDF Drill Thru in CA 11.2

    Posted Fri September 06, 2024 05:24 AM

    Hi all,

    can anyone think of any suggestions on where to start with this one... Drill thru works fine in HTML, but PDF report drill through isn't working.

    This is in CA 11.2.3, using chrome with the new JS PDF Viewer that became available in that version - which was there to make PDF drill available.

    Within the PDF, hovering over a place that drill thru shows no drill thru available.

    I know there is an option to revert back to the old PDF viewer behaviour but I need PDF drill working.

    I have no idea what setting in chrome could be preventing this from working or where to start looking.

    Any help appreciated.



    ------------------------------
    Marc Reed
    ------------------------------


  • 2.  RE: PDF Drill Thru in CA 11.2

    Posted Fri September 06, 2024 09:01 AM

    Hi Marc,

    Can you check in the Chrome Dev tools if there is a Correct SVG href link in the Drill-through object?

    Or you do not see a link at all in the PDF?


    ------------------------------
    Andrei Istomine
    Open to work - anything Cognos
    https://www.linkedin.com/in/andreii/
    ------------------------------



  • 3.  RE: PDF Drill Thru in CA 11.2

    Posted Mon September 09, 2024 03:35 AM

    That's interesting. There is no link:

    Yet the report definitely does have one:

    and if i download the PDF,  and open in Adobe Acrobat, there is one there: 

     



    ------------------------------
    Marc Reed
    ------------------------------



  • 4.  RE: PDF Drill Thru in CA 11.2

    Posted Mon September 09, 2024 09:07 AM

    I wonder if the issue is related to your specific Chrome setup.

    Have you tried any  other browsers?

    =========================

    https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=formats-pdf-drill-through-behavior

    PDF drill-through behavior

    Last Updated: 2024-01-29

    PDF drill-through behavior is slightly different in different versions of Cognos® Analytics.

    In Cognos Analytics 11.1.7 and earlier versions, PDF drill through is supported only in Internet Explorer, using Adobe Acrobat Reader. Acrobat Reader provides a mechanism that allows for generation of self-contained PDFs where the drill-through information is encapsulated in the PDF. Drill-through links work as long as the PDF is viewed in Acrobat Reader.

    Starting in Cognos Analytics 11.2.0, PDF drill through is available in all supported browsers and their respective PDF viewers. Because some of the viewers don't provide the same functionality as Acrobat Reader, the PDF output needs to be saved in Cognos Analytics for the drill-through links to work.

    For cases where the PDF output is not saved in Cognos Analytics, a change is delivered in Cognos Analytics 11.2.4 that allows the drill-through links to work like they did in Cognos Analytics 11.1.7: in self-contained PDF reports that can be viewed in Adobe Acrobat Reader. The drill-through links don't work if the PDF report is opened outside of Cognos Analytics, in a viewer other than Adobe Acrobat Reader.

    Downloaded PDF reports can be opened in any PDF viewer. However, drill-through links work only in the following situations:

    • The downloaded PDF report is viewed in Adobe Acrobat Reader.
    • The report output is saved in Cognos Analytics, such as when running a report in the background and selecting the Save delivery option.

    PDF reports that are viewed within Cognos Analytics work in all supported browsers.



    ------------------------------
    Andrei Istomine
    Open to work - anything Cognos
    https://www.linkedin.com/in/andreii/
    ------------------------------



  • 5.  RE: PDF Drill Thru in CA 11.2

    Posted Mon September 09, 2024 10:32 AM
    Edited by Marc Reed Mon September 09, 2024 10:34 AM

    Same behaviour in Edge, no drill through in PDF.

    I had seen that documentation you put in.   I think this is a case of the documentation being very ambiguous. 
    On other CA systems when using 11.2.3 and chrome I haven't needed to save output in order to get PDF drill to work, so I don't know why this documentation says that.
    Maybe you could test if you have drill through working - have you needed to save the output to get drill through working?

    I have also saved the PDF output as an output version in CA and drill through links are still not doing anything.

    Bit of a puzzle this one.



    ------------------------------
    Marc Reed
    ------------------------------



  • 6.  RE: PDF Drill Thru in CA 11.2

    Posted Mon September 09, 2024 11:22 AM
    Edited by Andrei Istomine Mon September 09, 2024 11:23 AM

    >Maybe you could test if you have drill through working - have you needed to save the output to get drill through working?

    No, I did not save the output, just selected Run as PDF.

    Though, the environment I'm testing still has some issue with the PDF drill-through.

    It has a GW and 2 APP servers. 

    After I try a few successful PDF runs, sometimes the drill-through link in the PDF will show up but its URL will  change to the APP server local name  instead of the GW FQDN... And then the drill-through will not run. Probably, the GW URL is not configured correctly on one of the APP servers. Unfortunately, I do not have remote access to these servers and can't troubleshoot the server config.



    ------------------------------
    Andrei Istomine
    Open to work - anything Cognos
    https://www.linkedin.com/in/andreii/
    ------------------------------



  • 7.  RE: PDF Drill Thru in CA 11.2

    Posted Mon September 09, 2024 11:27 AM

    Your testing backs up mine then. No need to do the Save as mentioned in the CA documentation. Not sure why that is in there.



    ------------------------------
    Marc Reed
    ------------------------------



  • 8.  RE: PDF Drill Thru in CA 11.2

    Posted Thu March 20, 2025 11:09 AM

    I thought I would update this thread as I finally found out what the issue was - and in case anyone finds this in the future with the same issue.

    It appears that if CA is configured to use a Web Gateway, then any drill thru links created within a PDF report are relative links. If the install does not have a gateway configured (ie just runs direct against the dispatcher) then PDF drill thru links are absolute URL links.

    The version of PDF.js (from around 2020) that is shipped with CA 11.2.3 does not support relative links. Hence users cannot click on links.

    It looks like PDF.js was updated in 2022 to support relative links. So if your version of CA contains a version of PDF.js from later than 2022, and you use a web gateway you should be ok.

    I wouldn't have thought using CA with a gateway was an edge test case. But this one looked like it slipped through testing all those years ago.



    ------------------------------
    Marc Reed
    Reporting Lead
    ------------------------------