Cognos Analytics with Watson

 View Only
  • 1.  Track filtered data on Cognos Dashboard

    Posted Wed June 01, 2022 10:29 AM

    Hi, team!

    I need to be able to track down which data has been filtered on my dashboard, per user.

    More specifically, what Opp Id was filtered (Image 1).

    Would it be possible to track down the opportunity selected by a user and see that in a report (Image 2)?

    Thanks in advance!

    Image 1


    Image 2



    ------------------------------
    Sergio Marinho da Silva
    ------------------------------


  • 2.  RE: Track filtered data on Cognos Dashboard

    Posted Thu June 02, 2022 06:02 AM
    Hi Sergio,

    If you use the Drill through feature from the dashboard to the report, you might retrieve ParamDisplayValue('pOppId').

    pOppId should be a valid parameter in your report. This is the value you will use when you create the Drill through definition in the dashboard.

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------



  • 3.  RE: Track filtered data on Cognos Dashboard

    Posted Thu June 02, 2022 12:32 PM

    Thanks for your reply!

    I don't have much experience with reports. I tried setting up a drillthrough on my dashboard and using ParamDisplayValue('pOppId') on a list, but it did not work.

    Also, would this method allow to collect and store which opportunities were selected on the dashboard?

    Image below: I added ParamDisplayValue('pOppId') to the text report expression and tried to use this report as a drill through for my dashboard. It did not work.



    ------------------------------
    Sergio Marinho da Silva
    ------------------------------