Can someone tell me whether we can apply filter on list of
values in the 'Value Prompt'? e.g. I have a value prompt
(named city) and the prompting is holding around 2000
cities but I want to apply filters on cities so users can
select only 15 cities out of 2000 and then run the report.
Users should be flexible enought to select any 15 cities
from the list. Is it possible. Please advice!

Answers were Sorted based on User's Feedback



Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'?..

Answer / sreenivasulu pokuru

Step1:take a list report with country column.
step2:create a value prompt based on country.
step3:go to query explorer
step4: select query-2 based on value prompt.
step5: drag country query item into detailed filter.
step6: write a filter condition like(country in
'india','china',............)
step7:run the report

Diffenetly u will get what requirement u have to do.

Thanks & regards
Sreenivasulu pokuru

Is This Answer Correct ?    3 Yes 0 No

Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'?..

Answer / keyrun

Yes it is possible using Mapping Variable & Mapping parameters!

Is This Answer Correct ?    4 Yes 2 No

Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'?..

Answer / shah

Hello Keyrun, Thanks for your answer.

Can you please share with me the steps.

Thanks again!

Is This Answer Correct ?    3 Yes 1 No

Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'?..

Answer / sathish kumar

first you create value prompt as usual with parameter and applying the filter on city.

In the next step,you need to create the static choices to select the 15 cities among 2000.

And run your report..,
am sure you will definitively get the output.

Is This Answer Correct ?    2 Yes 1 No

Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'?..

Answer / shah

Hi Satish,
Here the question is that the user should be flexible enough
to select any 15 cities and not a specific 15 cities...so
I'm not sure how much the static choice technic will help.
Please advice!

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Cognos Interview Questions

what are the tabs in cognos ?

2 Answers  


What are the types of security?

0 Answers  


What are Governer Settings?

2 Answers  


Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

0 Answers  


What is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?

0 Answers   IBM,






Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

0 Answers   IBM,


What are the methods by which it non-durable model could be changed into the durable model?

0 Answers  


what are slowly changing dimensions? Why we are used scd?

0 Answers   IBM,


im having null data in one of the cell in my report i have to display as "no data" when u run the report how can i achive this problem?

6 Answers   IBM,


Cleared COG-112 with 100% score today. What next certification should i go for?

0 Answers   IBM,


can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

0 Answers   TCS,


what is your project workflow and your role in the project?

5 Answers   Syntel,


Categories