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 a Pivot?

0 Answers  

I want to schedule the report as sysdate-1.....how to do

2 Answers   TCS,

Hey Techies, Could you please tell me about query processing? and what is database only and what is Limited locale? brief plz..

2 Answers   Atos Origin,

What is Performance Tunning Test?

2 Answers   IBM,

Write various indexes used in cognos?

0 Answers  




suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?

4 Answers  

How do we run stored procedure?

1 Answers  

When we save a report in report studio with what extn it save?

0 Answers  

Why are meta service important then other services?

0 Answers  

Which one is better among Value and select & search prompts,in terms of performance?

2 Answers   L&T,

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this

2 Answers  

what does my folder and public folder contains? difference between the my folder and public folder?

3 Answers   HCL,

For more Cognos Interview Questions Click Here
Categories