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
------------------------------

#CognosAnalyticswithWatson

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
------------------------------

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
------------------------------

Original Message:
Sent: Thu June 02, 2022 06:01 AM
From: Patrick Neveu
Subject: Track filtered data on Cognos Dashboard

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
------------------------------