COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: shrini on 17 Feb 2010 10:51:54 PM

Title: Tree Prompts?
Post by: shrini on 17 Feb 2010 10:51:54 PM
Hi

   I have 2 tree prompts -
    1st tree prompt yearmonth
     2nd tree prompt product

1st tree prompt should be single select and 2nd tree prompt should filter based on the selection of 1st tree prompt.

so when i select an year,products belonging to that year shuld be displayed in the second tree prompt at the prompt page.

How can we achieve this?

Thanks,
Shrini
Title: Re: Tree Prompts?
Post by: paddhu on 19 Feb 2010 06:12:39 AM
1. Set the Multiselect of yearmonth tree prompt as No, and that of product prompt as Yes.
2. Say the parameter associated with yearmonth tree is ?yrmon? and that corresponding to product prompt is ?pdt?
3. Select the product tree prompt and in its Cascade property, select yrmon.
4. Select the yearmonth tree prompt and set its Auto submit property to Yes.

Hope this does what you want.