COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognosun on 06 Jul 2013 01:47:12 PM

Title: Cascading prompt - default selecting
Post by: cognosun on 06 Jul 2013 01:47:12 PM
Hi Gurus.

I have a child prompt "C" with a cascade source "P" to it, for this P, as you know Auto submit is YES and multi-select is NO.

This child Prompt "C" got 2 default selections ( multi select 'yes')

What I've observed is, Cognos is only accepting 1 default selection in this cascading scenario ( scenario i mean , autopopulating values from P-->C) If i give 2 default selections in "C", which is my requirement, it's not accepting.

Can anyone help.

Title: Re: Cascading prompt - default selecting
Post by: cognosun on 07 Jul 2013 01:06:00 PM
Any clues :-)
Title: Re: Cascading prompt - default selecting
Post by: HalfBloodPrince on 08 Jul 2013 12:19:52 AM
Drag a layout calculation in report and check what  values are passed to the query .then check the filter in main query for  prompt c.
Title: Re: Cascading prompt - default selecting
Post by: cognosun on 08 Jul 2013 11:07:43 AM
This is working when I add a default Selection to the Cascading parent column.