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 / 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
How to publish a package by running Java Script?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
How to deploy from one server to another server?
what are the dimensions that you have in your current project?list them?
Explain the difference between powerplay transformer and power play reports?
5. Which type of report you build more, list, crosstab or chart and why?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
What are all the components of Report Studio?
-----------------What is Direct and Conventional loading?
What are the message flows?
What is the difference between group and associare?
Why is auto-regression used in forecasting used on cognos platform?
Diff b/w Crossproduct and Outerjoin?
What is the difference between a cascading report and drill through the report?
explain how to create powerplay reports?