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!

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

6149


hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

1696


What is model filter?

717


Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2222


We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2171






Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

1715


What is the difference between a cascading report and drill through report?

744


What are initial page components of Cognos connection?

692


After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

1694


What is the difference between Standard and Metrics folder?

665


What are the two types of framework manager?

763


What are the types of studio?

788


---------------Tell me about DWH Concepts?

1707


What is defined as Cognos Impromptu?

730


faq's on cognos

3718