Display Products by Country in Cognos Report Studio

I have two prompts with country and product line, for the selected item in country prompt few items of the product line should be shown instead of showing all, how can I achieve this?

Showing Answers 1 - 3 of 3 Answers


  • Aug 30th, 2016

If you want show values of Product Line prompt based on the selection of Country prompt then use cascade property of Product Line prompt so that Product Line prompt will populate values based on the selection of country prompt

  Was this answer useful?  Yes

Martina Vaz

  • Jun 26th, 2017

Use cascading prompt feature. For the product prompt select cascading prompt property as Yes, and select country parameter. the product query is filtered with selected country.

  Was this answer useful?  Yes

Mayank Sanghvi

  • Mar 21st, 2018

Cascading prompt is the answer for your question. We use cascading when we need to load data in one prompt based on the other. So in the above scenario Country is the first prompt and Product Line is dependent on Country.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions