Step1:take a list report with country column. step2:create a value prompt

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 / sreenivasulu pokuru

5 Answers
10284 Views
DELL, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what do u mean by bridge group? where we r using this one?

1979

What are slice and dice?

920

how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?

9183

What are the types of studio?

1139

Why is auto-regression used in forecasting used on cognos platform?

1011

is there any difference between operational database and data base?if yes what r they?

2061

Why are meta service important then other services?

971

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

1120

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

998

whats the difference between previous version of cognos and cognos 8 BI?

5527

---------------Describe OLAP Reporting and RDBMS Reporting?

2096

How to do Performence Tunning in Cognos Reports?

2473

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?