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
Can we test the report other than manual testing?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
can we insert all types of charts in a list report? what r the realtime prompts?
What is Bitmap Index?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
9. What was the most complex type of report you dealt with?
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 is a Transformer?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
What is the use of report studio?
can you tell me what are the dimension tables are used in project
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What is dtm?
---------------Tell me about DWH Concepts?
what are the dimensions that you have in your current project?list them?