i have 4 countries in my database as USA, UK, INDIA, CHANA.
In value prompt's prompt control list, i want
WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country
names.
When i click on WESTERN_COUNTRIES, it should retrieve USA,
UK records and when i click on ASIAN_COUNTRIES, it should
retrieve INDIA, CHINA records.
How is it possible?

Answer Posted / beckham

Use a customized data item in a query.this query is the
source query for the region prompt.Make sure the customized
data item is used in main query and filterd accordingly.

Is This Answer Correct ?    4 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write types of folders present in cognos?

572


What is a Query Subject?

663


Why cognos decision stream is used?

640


3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

2132


How to generate cubes in cognos?

574






What is the difference between a data mart and a data warehouse?

548


What is the complex report you faced in real time?

1735


How can you link a query to a data container manually in Report Studio?

1932


Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

1600


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

10751


Which lifecycle we will use for reporting?

565


Explain is there any comparison available for cognos reportnet vs crystal reports?

547


What is the difference between ‘macro’ and ‘prompt?

555


What are the types of studio?

687


What is cognos powerhouse?

586