Cognos Analytics

 View Only
Expand all | Collapse all

Automating PDF Report Retrieval from IBM Cognos BI via IBM Cloud Functions

  • 1.  Automating PDF Report Retrieval from IBM Cognos BI via IBM Cloud Functions

    Posted Tue September 26, 2023 03:16 PM

    Hello everyone,

    I'm using IBM Watson Assistant to facilitate user interactions where they can request specific client reports. Currently, the process generates a URL that directs the user to our IBM Cognos BI dashboard to view the report. However, for better user experience and access restrictions, I'd like to retrieve the report directly in PDF format instead of just generating the link.

    What I Have Now:

    1. A Watson Assistant flow that captures user intent and desired client name for the report.
    2. An IBM Cloud Function that, based on the client name:
      • Maps the name to a unique client ID.
      • Constructs a URL to the Cognos dashboard for the report specific to that client.

    Objective:

    Instead of returning the URL, I want the cloud function to:

    • Use the constructed URL to access the Cognos dashboard.
    • Download the report in PDF format.
    • Return the PDF (or a link to the stored PDF) to Watson Assistant, so the user can directly download/view it without accessing the Cognos dashboard.


    ------------------------------
    SRIHARI CHANDRAMOULI
    ------------------------------


  • 2.  RE: Automating PDF Report Retrieval from IBM Cognos BI via IBM Cloud Functions

    Posted Fri September 29, 2023 12:20 PM

    Hi Srihari,

    I think we've covered/answered this one in our other thread, here, correct? 

    I just wanted to check, to make sure this was resolved for you.



    ------------------------------
    Jim Boland

    LinkedIn: https://www.linkedin.com/in/jimboland
    Website: https://coreinsightz.com
    Email: jimboland@coreinsightz.com
    ------------------------------



  • 3.  RE: Automating PDF Report Retrieval from IBM Cognos BI via IBM Cloud Functions

    Posted Fri September 29, 2023 12:25 PM

    Hi Jim, this was resolved. Thank so much for all the help :)



    ------------------------------
    SRIHARI CHANDRAMOULI
    ------------------------------