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 do you understand by the term 'aggregate cache'?

573


What are the steps to import the two data sources in framework manager?

618


What is looping and how to avoid it in framework manager?

669


What are the types of hierarchies?

561


Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

1668






2. What functional area you worked on.

1915


how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?

1875


What is the advantage of using shortcuts?

644


-------------How you design DWH?

1894


What are the different uses of a repository manager?

605


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

619


How can we create a dynamic column name in cognos?

539


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

1604


What is catalog and types of catalogs in cagonos and which is better?

521


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?

2085