COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: dsg1 on 12 Mar 2012 09:48:58 AM

Title: how to drill through to target report passing default prompt values
Post by: dsg1 on 12 Mar 2012 09:48:58 AM
I have a drill through report which opens up in a new page.

I have a 'week end from date' and 'week end to date' prompt present in the target report.

The issue is when I am drilling through from the source report, by default the target report should show the last 6 weeks data and the prompts will come into picture only when they are selected.

How can I achive this in Cognos? 

Thanks
dsg
Title: Re: how to drill through to target report passing default prompt values
Post by: ambuj2k50 on 20 Mar 2012 07:10:11 AM
Please clarify your Scenario !!

You have to pass the value of the parameters in the target report from the source report. i.e where you will specify the drillthrough definition in the source report... there you have to choose the target report and you have to specify the mapping for the parameter of the target promt to the values which is to be passed from source report.
Title: Re: how to drill through to target report passing default prompt values
Post by: charism on 28 Mar 2012 08:09:13 PM
check this out to see if it help:
http://publib.boulder.ibm.com/infocenter/caapps/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cc.8.4.1.doc/ug_cc_i_SetUpDrillParams.html