1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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?

Question Posted / gajendra kumar

Answer Posted / gajendra kumar

Just add static choices to value parameter as WESTERN_COUNTRIES, ASIAN_COUNTRIES. In report query add the filter (?parameter? = 'WESTERN_COUNTRIES' and [Dataitem] in ('USA', 'UK'))
or
(?parameter? = 'ASIAN_COUNTRIES' and [Dataitem] in ('INDIA', 'CHINA'))

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to publish a package by running Java Script?

1604

what is the role of cognos comsultant?what actually it means?pls reply

1883

What are cognos connection initial page components?

600

is cognos 7 is better than cognos 8

1690

How is cognos model organization works?

599




Cleared COG-112 with 100% score today. What next certification should i go for?

1419

What are the message flows?

560

Name the types of gateway?

601

what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

1601

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?

1655

How can I schedule reports in cognos?

599

What are shortcuts? Where it can be used? What are the advantages?

555

what is the difference between native sql and cognos sql?

512

Mention the difference between ‘macros’ and ‘prompt’?

607

What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

3919