Hi all,

in my dashboard I have two summaries: the first shows a YTD Revenue and the second a "Prior YTD" Revenue
I would like to create a drill through definition in order to execute a report able to list the records representing the summary values. So, If i click on YTD summary I would like see the details of the YTD records, while, If I click on the "Prior YTD" summary, I would see the details about the Prior YTD records.
A very simple scenario!
In order to perform this, Can I create only ONE report and execute it in a conditional way passing a custom parameter from the dashboard? Or, shall I create two reports?

Moreover, in Cognos 10 I can see the passed parameters using a drill through definition. Is this still exist in cognos Analytics?

Many thanks in advance for your help

Regards

------------------------------
Camillo Gioè
------------------------------

#CognosAnalyticswithWatson

@Camillo Gioè

I'm making assumptions on how your data is modeled, ​but if you have a Summary viz for YTD, you can add a local filter for the current year, to the viz and that will be passed to the target report. The PYTD summary will have a drill-through to the same report but it will not pass any values  to the target report. Here is an example of the detail filter syntax for the target report:

(#prompt('p1','integer','2018')# = 2019and [Year] = #prompt('p1','integer','2018')#)
or
(#prompt('p1','integer','2018')# <> 2019 and [Year] = 2018)

The first clause will check to see if the parameter being passed is 2019 and if so, filter the query based on 2019

the or clause will check to see if the parameter is not equal to 2019 and filters the year by 2018

You can replace the hard coded years with extract(year,current_date) function to get the current year and  extract(year,_add_years(current_date, -1) ) to get the prior year.

------------------------------
DENNY NAREZNY
------------------------------

Hi,

thanks for your reply.
Can you tell me anything about the functionality which allows to see the passed parameters using a drill through definition? In Cognos 10 this was a very useful option and I used it many times with satisfaction in order to debug my drill through definition but I don't find it in Cognos Analytics :-(((
 Is this still exist in Cognos Analytics?
Many thanks again

------------------------------
Camillo Gioè
------------------------------

Original Message:
Sent: Thu June 13, 2019 01:57 PM
From: DENNY NAREZNY
Subject: Customize Drill Through from dashboard

@Camillo Gioè

I'm making assumptions on how your data is modeled, ​but if you have a Summary viz for YTD, you can add a local filter for the current year, to the viz and that will be passed to the target report. The PYTD summary will have a drill-through to the same report but it will not pass any values  to the target report. Here is an example of the detail filter syntax for the target report:

(#prompt('p1','integer','2018')# = 2019and [Year] = #prompt('p1','integer','2018')#)
or
(#prompt('p1','integer','2018')# <> 2019 and [Year] = 2018)

The first clause will check to see if the parameter being passed is 2019 and if so, filter the query based on 2019

the or clause will check to see if the parameter is not equal to 2019 and filters the year by 2018

You can replace the hard coded years with extract(year,current_date) function to get the current year and  extract(year,_add_years(current_date, -1) ) to get the prior year.

------------------------------
DENNY NAREZNY
------------------------------