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?
- 4 Answers
- 8825 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / itesh
simple man ,
create country prompt with 2 dynamic prompt value dispay
value WESTERN_COUNTRIES>use vale (1)ASIAN_COUNTRIES (2)
in report query put filter
write a if statement
if (?country?)=1
then country in (USA,UK)
else country in (INDIA, CHINA)
cheers
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
whats the difference between previous version of cognos and cognos 8 BI?
What are the components used in web tier?
What are the types of catalogs in cognos?
How to generate cubes in cognos?
Mention the difference between ‘macros’ and ‘prompt’?
how u will design the report if the objects are available
Define metrics studio?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
Can you define a catalog and types of catalogs in cognos?
How is cognos model organization works?
what are the errors faced while bursting the reports and how to solve those errors?
What is the use of powerhouse?
Can you define materialized view?
