If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Tree Prompts?

Started by shrini, 17 Feb 2010 10:51:54 PM

Previous topic - Next topic

shrini

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

paddhu

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.