Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9961 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
What is the difference between Open Connection command ang Open Session Command?
what is the difference between list report and crosstab report?
What is main advantage datawarehousing over oracle?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
What is called Cognos powerplay?
What are the types of studio?
What are the different kinds of panes included in cognos?
What are the methods by which it non-durable model could be changed into the durable model?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
what is log in cognos?
What is the complex report you faced in real time?
What are products of cognos?
Explain informatica architecture?
