1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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!

Question Posted / shah.nawaz89

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 is difference between informatica power mart and power center?

0 Answers  

I have 3 dataitems in a list username,transaction type,transaction amount. In transaction type i have 3 types 'add','update','delete', i have almost 750 rows. After displaying the list report i want to know no. of add's,update's,delete's in 3 different rows

2 Answers  

give me scenario on cascading prompts&master-detail relation

4 Answers   IBM,

What are shortcuts? Where it can be used? What are the advantages?

0 Answers  

What are the types of folder present in cognos?

0 Answers  




What are links & Segments in Cognos Framework Manager?

1 Answers   Systime,

7. What is performance tuning?

0 Answers  

Explain about embedded & standalone filters?difference between them

1 Answers  

how can I test reports in cagnos?

0 Answers   IBM,

where we use page break  and page set. with example?

1 Answers   CNSI, IBM,

can anybody send me interview questions with answers on IBM cognos-FM and Report studio. My mail ID is: cskcognos@gmail.com

1 Answers  

What is the importance of having monitor service in cognos?

0 Answers  

For more Cognos Interview Questions Click Here
Categories